public long insertLeadComs(long leadId, ILeadComsMethods newleadComsMethods) { var leadComsMethods = newleadComsMethods.getLeadComsMethodsDto(); int count = 0; using (var db = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlServerConnString"].ConnectionString)) { string sql = @"INSERT INTO LeadComsMethod (LeadID, ComsMethodID) VALUES (@LeadID, @ComsMethodID)"; db.Open(); foreach (var leadComsMethod in leadComsMethods) { count += db.Execute(sql, new { LeadID = leadId, ComsMethodID = leadComsMethod.comsMethodId }); } } return(count); }
public long insertLeadComs(long leadId, ILeadComsMethods leadComsMethods) { return(1); }