ASP.NET

Danpeking wrote:

Thanks for the replies guys, it would be great to have one central table containing the IPT rates and dates effective but this would be extremely difficult to do given there is only 2 developers in the team and the IPT is a rating factor in a few products quote engines.

public static CustomerResponseLogCollection FindAll(int orderID)
       {
           Database db = EmersonDataHelper.CreateConnection();
           CustomerResponseLogCollection customerResponseLogs = new CustomerResponseLogCollection();

           var c = db.ExecuteSprocAccessor<CustomerResponseLog>(ConstantsDB.USPGetResponseLogsByOrderID, orderID).ToList();

           foreach (CustomerResponseLog item in c)
           {
               customerResponseLogs.Add(item);
           }

           return customerResponseLogs;
       }

future3839 wrote:

Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them?
is there any approach to insert data with writing just one SP.