public void CreateCategoryCampaignCSTM(CreateCategoryCampaignDTO createCategoryCampaignDTO) { // HANDLE sql String catCampaignSql = @"INSERT INTO CAMPAIGN_CATEGORY_CSTM(ID_C) VALUES(@ID_C)"; DynamicParameters paramCstm = new DynamicParameters(); paramCstm.Add("@ID_C", createCategoryCampaignDTO.ID); DapperORM.InsertOne(catCampaignSql, paramCstm); }
//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 IActionResult CreateCategoryCampaign([FromBody] CreateCategoryCampaignDTO createCategoryCampaign) { try { //ValidateResultDto check = validate.CreateNewCampaignCategory(createCategoryCampaign); //if (check.code != 0) return StatusCode(check.code, new { message = check.message }); string newCatCampaign = _campaignCategoryRepository.CreateCategoryCampaign(createCategoryCampaign, User.FindFirst(ClaimTypes.NameIdentifier).Value); ResponseForm <string> res = new ResponseForm <string>(newCatCampaign, "Record has been created successfully", 200); var json = JsonConvert.SerializeObject(res); return(Content(json, "application/json")); } catch (Exception e) { return(StatusCode(400, new { message = e.Message })); } }
public ValidateResultDto CreateNewCampaignCategory(CreateCategoryCampaignDTO categoryCampaignDTO) { if (string.IsNullOrWhiteSpace(categoryCampaignDTO.ID)) { if (string.IsNullOrEmpty(categoryCampaignDTO.DESCRIPTION)) { return(new ValidateResultDto(400, "The DESCRIPTION parameter is required")); } if (string.IsNullOrEmpty(categoryCampaignDTO.NAME)) { return(new ValidateResultDto(400, "The NAME parameter is required")); } if (string.IsNullOrEmpty(categoryCampaignDTO.KB_DOCUMENT)) { return(new ValidateResultDto(400, "The KB_DOCUMENT parameter is required")); } //if (string.IsNullOrEmpty(categoryCampaignDTO.ACW_C.ToString())) //{ // return new ValidateResultDto(400, "The ACW_C parameter is required"); //} } return(new ValidateResultDto(0, "")); }
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()); } }