public int Insert(LeadDetailsInputModel data) { using (SqlConnection conn = new SqlConnection(_configuration.Get("ConnectionString:SQLConnection"))) { try { var dbParams = new DynamicParameters(); conn.Open(); dbParams.Add("@LeadDetail", Newtonsoft.Json.JsonConvert.SerializeObject(data)); dbParams.Add("@leadId", dbType: DbType.Guid, direction: ParameterDirection.Output); var reader = conn.ExecuteReader( sql: "[CRM].[CRM_SP_EMAIL_LEAD_INSERT]", param: dbParams, commandType: CommandType.StoredProcedure); var leadId = dbParams.Get <Guid>("@leadId"); foreach (var item in data.Quotes) { var param = new EntitiesNoteInputModel(); param.Note = item.text; param.RefId = leadId; _note.InsertNote(param); } return(1); } catch (Exception) { throw; } finally { conn.Close(); } } }
public int InsertNote(EntitiesNoteInputModel data) { using (SqlConnection conn = new SqlConnection(_configuration.Get("ConnectionString:SQLConnection"))) { try { var dbParams = new DynamicParameters(); conn.Open(); dbParams.Add("@refId", data.RefId); dbParams.Add("@date", Convert.ToString(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); dbParams.Add("@note", data.Note); dbParams.Add("@userId", data.UserId); var reader = conn.ExecuteReader( sql: "[CRM].[CRM_SP_ENTITIES_NOTE_INSERT]", param: dbParams, commandType: CommandType.StoredProcedure); return(1); } catch (Exception ex) { throw ex; } finally { conn.Close(); } } }