Example #1
0
        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);
        }
Example #2
0
 public long insertLeadComs(long leadId, ILeadComsMethods leadComsMethods)
 {
     return(1);
 }