//public void UpdateCateGoryCampaignCSTM(CreateCategoryCampaignDTO createCategoryCampaignDTO)
//{
// String catCampaignSql = @"UPDATE CAMPAIGN_CATEGORY_CSTM set ID_C = @ID_C ";
// DynamicParameters paramCstm = new DynamicParameters();
// paramCstm.Add("@ID_C", createCategoryCampaignDTO.ID);
// if(createCategoryCampaignDTO.ACW_C > 0)
// {
// catCampaignSql += " , ACW_C = @ACW_C";
// paramCstm.Add("@ACW_C", createCategoryCampaignDTO.ACW_C);
// }
// if (createCategoryCampaignDTO.CUSTOMER_NOT_PICK_RECALL_C > 0)
// {
// catCampaignSql += " , CUSTOMER_NOT_PICK_RECALL_C = @CUSTOMER_NOT_PICK_RECALL_C";
// paramCstm.Add("@CUSTOMER_NOT_PICK_RECALL_C", createCategoryCampaignDTO.CUSTOMER_NOT_PICK_RECALL_C);
// }
// if (createCategoryCampaignDTO.NOT_PICK_FREQUENCY_C > 0)
// {
// catCampaignSql += " , NOT_PICK_FREQUENCY_C = @NOT_PICK_FREQUENCY_C";
// paramCstm.Add("@NOT_PICK_FREQUENCY_C", createCategoryCampaignDTO.NOT_PICK_FREQUENCY_C);
// }
// if (createCategoryCampaignDTO.ACW_C > 0)
// {
// catCampaignSql += " , CUSTOMER_NO_SIGNAL_RECALL_C = @CUSTOMER_NO_SIGNAL_RECALL_C";
// paramCstm.Add("@CUSTOMER_NO_SIGNAL_RECALL_C", createCategoryCampaignDTO.ACW_C);
// }
// if (createCategoryCampaignDTO.ACW_C > 0)
// {
// catCampaignSql += " , NO_SIGNAL_FREQUENCY_C = @NO_SIGNAL_FREQUENCY_C";
// paramCstm.Add("@NO_SIGNAL_FREQUENCY_C", createCategoryCampaignDTO.NO_SIGNAL_FREQUENCY_C);
// }
// if (createCategoryCampaignDTO.CUSTOMER_IS_BUSY_RECALL_C > 0)
// {
// catCampaignSql += " , CUSTOMER_IS_BUSY_RECALL_C = @CUSTOMER_IS_BUSY_RECALL_C";
// paramCstm.Add("@CUSTOMER_IS_BUSY_RECALL_C", createCategoryCampaignDTO.CUSTOMER_IS_BUSY_RECALL_C);
// }
// if (createCategoryCampaignDTO.ACW_C > 0)
// {
// catCampaignSql += " , IS_BUSY_FREQUENCY_C = @IS_BUSY_FREQUENCY_C";
// paramCstm.Add("@IS_BUSY_FREQUENCY_C", createCategoryCampaignDTO.IS_BUSY_FREQUENCY_C);
// }
// catCampaignSql += " WHERE ID_C = @ID_C;";
// DapperORM.Execute(catCampaignSql, paramCstm);
//}
public CampaignCategorise GenCategoryCampaign(CreateCategoryCampaignDTO createCategoryCampaignDTO)
{
CampaignCategorise categoryCampaign = new CampaignCategorise();
categoryCampaign.ID = string.IsNullOrWhiteSpace(createCategoryCampaignDTO.ID) ? Guid.NewGuid() : new Guid(createCategoryCampaignDTO.ID);
categoryCampaign.NAME = createCategoryCampaignDTO.NAME;
categoryCampaign.DESCRIPTION = createCategoryCampaignDTO.DESCRIPTION;
categoryCampaign.KB_DOCUMENT = createCategoryCampaignDTO.KB_DOCUMENT;
return(categoryCampaign);
}
public string CreateCategoryCampaign(CreateCategoryCampaignDTO createCategoryCampaignDTO, string USER_ID)
{
DateTime now = DateTime.Now;
// Insert CategoryCampaign
if (string.IsNullOrWhiteSpace(createCategoryCampaignDTO.ID.ToString()))
{
CampaignCategorise categoryCampaignByName = GetCategoryCampaignByName(createCategoryCampaignDTO.NAME);
if (categoryCampaignByName != null)
{
throw new Exception("NAME already exists");
}
// Genarate new id
Guid id = Guid.NewGuid();
createCategoryCampaignDTO.ID = id.ToString();
// HANDLE sql
String catCampaignSql = @"INSERT INTO CAMPAIGN_CATEGORY(ID, NAME, DESCRIPTION, KB_DOCUMENT, DATE_ENTERED, DATE_MODIFIED, DATE_MODIFIED_UTC,MODIFIED_USER_ID,CREATED_BY)
VALUES(@ID, @NAME, @DESCRIPTION, @KB_DOCUMENT, @DATE_ENTERED, @DATE_MODIFIED, @DATE_MODIFIED_UTC,@MODIFIED_USER_ID,@CREATED_BY)";
DynamicParameters paramCstm = new DynamicParameters();
paramCstm.Add("@ID", createCategoryCampaignDTO.ID);
paramCstm.Add("@NAME", createCategoryCampaignDTO.NAME);
paramCstm.Add("@DESCRIPTION", createCategoryCampaignDTO.DESCRIPTION);
paramCstm.Add("@KB_DOCUMENT", createCategoryCampaignDTO.KB_DOCUMENT);
paramCstm.Add("@DATE_ENTERED", DateTime.Now);
paramCstm.Add("@DATE_MODIFIED", now);
paramCstm.Add("@DATE_MODIFIED_UTC", now);
paramCstm.Add("@MODIFIED_USER_ID", USER_ID);
paramCstm.Add("@CREATED_BY", USER_ID);
DapperORM.InsertOne(catCampaignSql, paramCstm);
CreateCategoryCampaignCSTM(createCategoryCampaignDTO);
return(id.ToString());
}
else
{
CampaignCategorise categoryCampaign = GenCategoryCampaign(createCategoryCampaignDTO);
// Update CategoryCampaign
// CHECK ID
CampaignCategorise categoryCampaignById = GetCategoryCampaignById(categoryCampaign.ID);
if (categoryCampaignById == null)
{
throw new Exception("ID not found");
}
// CHECK NAME
if (categoryCampaignById.NAME != categoryCampaign.NAME)
{
CampaignCategorise categoryCampaignByName = GetCategoryCampaignByName(categoryCampaign.NAME);
if (categoryCampaignByName != null)
{
throw new Exception("NAME already exists");
}
}
// HANDLE sql
DynamicParameters paramCstm = new DynamicParameters();
String catCampaignSql = @"UPDATE CAMPAIGN_CATEGORY set DATE_MODIFIED = @DATE_MODIFIED, DATE_MODIFIED_UTC = @DATE_MODIFIED_UTC ";
paramCstm.Add("@DATE_MODIFIED_UTC", now);
paramCstm.Add("@DATE_MODIFIED", now);
if (!string.IsNullOrEmpty(categoryCampaign.NAME))
{
catCampaignSql += " ,NAME = @NAME";
paramCstm.Add("@NAME", categoryCampaign.NAME);
}
if (!string.IsNullOrEmpty(categoryCampaign.KB_DOCUMENT))
{
catCampaignSql += " ,DESCRIPTION = @DESCRIPTION";
paramCstm.Add("@DESCRIPTION", categoryCampaign.DESCRIPTION);
}
if (!string.IsNullOrEmpty(categoryCampaign.KB_DOCUMENT))
{
catCampaignSql += " ,KB_DOCUMENT = @KB_DOCUMENT";
paramCstm.Add("@KB_DOCUMENT", categoryCampaign.KB_DOCUMENT);
}
catCampaignSql += " ,MODIFIED_USER_ID = @MODIFIED_USER_ID";
paramCstm.Add("@MODIFIED_USER_ID", USER_ID);
catCampaignSql += " where ID = @ID;";
paramCstm.Add("@ID", categoryCampaign.ID);
DapperORM.Execute(catCampaignSql, paramCstm);
//UpdateCateGoryCampaignCSTM(createCategoryCampaignDTO);
return(categoryCampaignById.ID.ToString());
}
}
