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