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();
}
}
}
