//Update create campaign details pooja public bool updateCampaignMaster(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "updateCampaignMaster"; cmd.Parameters.AddWithValue("_campaignId", campaignId); cmd.Parameters.AddWithValue("_campTitle", campTitle); cmd.Parameters.AddWithValue("_campDesc", campDesc); cmd.Parameters.AddWithValue("_opt1", opt1); cmd.Parameters.AddWithValue("_opt2", opt2); cmd.Parameters.AddWithValue("_opt3", opt3); cmd.Parameters.AddWithValue("_opt4", opt4); cmd.Parameters.AddWithValue("_opt5", opt5); cmd.Parameters.AddWithValue("_opt6", opt6); cmd.Parameters.AddWithValue("_opt7", opt7); cmd.Parameters.AddWithValue("_opt8", opt8); cmd.Parameters.AddWithValue("_comId", comId); cmd.Parameters.AddWithValue("_boothId", boothid); cmd.Parameters.AddWithValue("_regId", regid); cmd.Parameters.AddWithValue("_constid", constid); cmd.Parameters.AddWithValue("_areaid", areaid); return(dalObj.getExecuteData(cmd, out errMsg)); } }
public static string saveData(string options, string title, string description, string community, string constituency, string region, string area, string boothNo) { campaignBLL cmpinObj = new campaignBLL(); List <string> val = options.Split(',').ToList(); for (int i = val.Count; i < 8; i++) { val.Add(""); } cmpinObj.opt1 = val[0]; cmpinObj.opt2 = val[1]; cmpinObj.opt3 = val[2]; cmpinObj.opt4 = val[3]; cmpinObj.opt5 = val[4]; cmpinObj.opt6 = val[5]; cmpinObj.opt7 = val[6]; cmpinObj.opt8 = val[7]; cmpinObj.opt8 = val[7]; cmpinObj.campTitle = title; cmpinObj.campDesc = description; cmpinObj.comId = community; cmpinObj.constid = constituency; cmpinObj.regid = region; cmpinObj.areaid = area; cmpinObj.boothid = boothNo; cmpinObj.saveCampaignMasterAndDetails(); return(""); }
//editCampaignOptionById public DataTable editCampaignOption(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "editCampaignOption"; cmd.Parameters.AddWithValue("_campOptionId", campaignId); return(dalObj.getSelectData(cmd, out errMsg)); } }
//deleteCampaignOptionById public bool deletecampaignOption(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "deleteCampaignOption"; cmd.Parameters.AddWithValue("_campOptionId", campaignId); return(dalObj.getExecuteData(cmd, out errMsg)); } }
public static string getAllOptions(string rblCampaignType) { string JSON = ""; campaignBLL cmpinObj = new campaignBLL(); DataTable dtTemp = cmpinObj.getAllOptionsByCampaignType(rblCampaignType); JSON = JsonConvert.SerializeObject(dtTemp, Newtonsoft.Json.Formatting.Indented); return(JSON); }
//getCampaignReportDetailsByCampaignId public DataTable getCampaignReportDetailsByCampaignId(campaignBLL cmpObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "getCampaignReportDetailsByCampaignId"; cmd.Parameters.AddWithValue("_campaignId", campaignId); cmd.Parameters.AddWithValue("_option", option); return(dalObj.getSelectData(cmd, out errMsg)); } }
public bool SaveCampaignOption(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "saveCampaignOptions"; cmd.Parameters.AddWithValue("_campaignType", campaignType); cmd.Parameters.AddWithValue("_option", option); return(dalObj.getExecuteData(cmd, out errMsg)); } }
public bool saveRecordedFile(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "saveRecordedFile"; cmd.Parameters.AddWithValue("_recordedFile", cmpinObj.recordedFile); cmd.Parameters.AddWithValue("_recordDuration", cmpinObj.recordDuration); cmd.Parameters.AddWithValue("_callStatus", cmpinObj.callStatus); cmd.Parameters.AddWithValue("_sId", cmpinObj.sId); return(dalObj.getExecuteData(cmd, out errMsg)); } }
public bool SaveCampaignReports(campaignBLL cmpinObj) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "saveCampaignReports"; cmd.Parameters.AddWithValue("_campaignId", cmpinObj.campaignId); cmd.Parameters.AddWithValue("_primaryContactNo", cmpinObj.primaryContactNo); cmd.Parameters.AddWithValue("_digit", cmpinObj.digit); cmd.Parameters.AddWithValue("_callFrom", cmpinObj.callfrom); cmd.Parameters.AddWithValue("_sId", cmpinObj.sId); cmd.Parameters.AddWithValue("_dateCreated", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); return(dalObj.getExecuteData(cmd, out errMsg)); } }