//
// GET: /Campaign/
public ActionResult Index()
{
return(View(new CampaignUIModel()
{
Campaigns = CampaignBO.GetInstance().GetAll()
}));
}
public ActionResult View(int id)
{
CampaignDetailUIModel model = new CampaignDetailUIModel();
model.Campaign = CampaignBO.GetInstance().Get(id);
model.ActivitiesToExecute = CampaignBO.GetInstance().GetCampaignActivities(id);
return(View(model));
}
public int InsertCampaign(CampaignBO argObject, DataTable argdtT, DataTable argdtQ)
{
int identity = 0;
BsfGlobal.OpenCRMDB();
try
{
SqlCommand cmd;
string campaignDate = string.Format("{0:dd/MMM/yyyy}", argObject.CampaignDate);
string sSql = "Insert Into dbo.CampaignDetails (CCId,RequestId,CampaignDate,CampaignName,DurationType,DurationPeriod,TotAmount,NetAmount) " +
"Values(" + argObject.CCId + ",'" + argObject.CReqId + "','" + campaignDate + "', '" + argObject.CampName + "','" +
argObject.DurType + "'," + argObject.DurPeriod + ", " + argObject.TotAmount + ", " + argObject.NetAmount + ") SELECT SCOPE_IDENTITY();";
BsfGlobal.OpenCRMDB();
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
identity = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
if (argdtT != null)
{
for (int i = 0; i < argdtT.Rows.Count; i++)
{
if (Convert.ToBoolean(argdtT.Rows[i]["Sel"]) == true)
{
sSql = "Insert Into dbo.CampaignTrans(CampaignId,CostCentreId,Amount,NetAmount)Values(" + identity + "," +
" " + argdtT.Rows[i]["CostCentreId"] + ",'" + argdtT.Rows[i]["Amount"] + "'," + argdtT.Rows[i]["NetAmount"] + ")";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
if (argdtQ != null)
{
for (int i = 0; i < argdtQ.Rows.Count; i++)
{
sSql = "Insert Into dbo.CampaignQualifier(CampaignId,CostCentreId,Description,Flag,Amount)Values(" + identity + "," + argdtQ.Rows[i]["CostCentreId"] + "," +
" '" + argdtQ.Rows[i]["Description"] + "','" + argdtQ.Rows[i]["Flag"] + "'," + argdtQ.Rows[i]["Amount"] + ")";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(identity);
}
// Si la actividad devuelve un valor, se debe derivar de CodeActivity<TResult>
// y devolver el valor desde el método Execute.
protected override void Execute(CodeActivityContext context)
{
// Obtenga el valor de tiempo de ejecución del argumento de entrada Text
string name = context.GetValue(this.Name);
int workflowID = context.GetValue(this.WorkflowID);
CampaignDataModel model = new CampaignDataModel();
model.Name = name;
model.WorkflowID = workflowID;
CampaignBO.GetInstance().Create(model);
}
public ActionResult Start(int id)
{
var input = new Dictionary <string, object> {
{ "CampaignID", id }
};
WorkflowInvoker.Invoke(new BusinessWorkflow.MainActivity(), input);
CampaignDataModel model = CampaignBO.GetInstance().Get(id);
return(View("~/Views/Campaign/View.cshtml", model));
}
public List <Model.Campaign> CampaignInfo(Model.Campaign request)
{
try
{
CampaignBO campaignBO = new CampaignBO();
return(campaignBO.CampaignInfo(request));
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMod");
throw;
}
}
public IEnumerable <GetDataForDropDownList> GetMasterDropDownDataforMasterTables(string MasterTableID, string MasterTableDescription, string MasterTableName)
{
try
{
CampaignBO campaignBO = new CampaignBO();
return(campaignBO.GetMasterDropDownDataforMasterTables(MasterTableID, MasterTableDescription, MasterTableName));
}
catch (Exception ex)
{
Error.WriteException(TraceEventType.Error, ex.Message.ToString(), "CampaignMod");
throw;
}
}
// Si la actividad devuelve un valor, se debe derivar de CodeActivity<TResult>
// y devolver el valor desde el método Execute.
protected override void Execute(CodeActivityContext context)
{
// Obtenga el valor de tiempo de ejecución del argumento de entrada Text
int campaignID = context.GetValue(this.CampaignID);
CampaignDataModel model = CampaignBO.GetInstance().Get(campaignID);
if (model.DateStarted != DateTime.MinValue)
{
throw new Exception("Campaign already started");
}
model.DateStarted = DateTime.Now;
CampaignBO.GetInstance().Update(model);
context.SetValue(WorkflowID, model.WorkflowID);
}
public ActionResult RenderLeftMenu(int campaignId = 0)
{
CampaignClient campaignService = new CampaignClient();
ACM.Model.PartialViewInfo partialView = new Model.PartialViewInfo();
if (Session["CampaignId"] != null)
partialView.CampaignId = (Int32)Session["CampaignId"];
else
partialView.CampaignId = campaignId;
CampaignBO campaignBO = new CampaignBO();
partialView = campaignBO.CampaignLeftNavigationDetails(partialView.CampaignId);
if (Session["DeploymentPeriodId"] != null)
{
partialView.DeploymentPeriodId = (int)Session["DeploymentPeriodId"];
}
return PartialView("_LeftMenu", partialView);
}
public PartialViewInfo CampaignLeftNavigationDetails(int campaignId)
{
CampaignBO campaignBO = new CampaignBO();
return(campaignBO.CampaignLeftNavigationDetails(campaignId));
}
public void UpdateCampaign(CampaignBO argObject, DataTable argdtT, DataTable argdtQ)
{
oOppCapDL.UpdateCampaign(argObject, argdtT, argdtQ);
}
public int InsertCampaign(CampaignBO argObject, DataTable argdtT, DataTable argdtQ)
{
return(oOppCapDL.InsertCampaign(argObject, argdtT, argdtQ));
}
public void UpdateCampaign(CampaignBO argObject, DataTable argdtT, DataTable argdtQ)
{
try
{
SqlCommand cmd;
string campaignDate = string.Format("{0:dd/MMM/yyyy}", argObject.CampaignDate);
string sSql = "Update dbo.CampaignDetails set CCId=" + argObject.CCId + ",RequestId='" + argObject.CReqId + "',CampaignDate='" + campaignDate + "', CampaignName='" +
argObject.CampName + "',DurationType='" + argObject.DurType + "',DurationPeriod=" + argObject.DurPeriod + ",TotAmount=" +
argObject.TotAmount + ",NetAmount=" + argObject.NetAmount + " Where CampaignId=" + argObject.CampId + "";
BsfGlobal.OpenCRMDB();
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Delete From dbo.CampaignTrans Where CampaignId=" + argObject.CampId + "";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "Delete From dbo.CampaignQualifier Where CampaignId=" + argObject.CampId + "";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (argdtT != null)
{
for (int i = 0; i < argdtT.Rows.Count; i++)
{
if (Convert.ToBoolean(argdtT.Rows[i]["Sel"]) == true)
{
sSql = "Insert Into dbo.CampaignTrans(CampaignId,CostCentreId,Amount,NetAmount)Values(" + argObject.CampId + "," +
" " + argdtT.Rows[i]["CostCentreId"] + ",'" + argdtT.Rows[i]["Amount"] + "'," + argdtT.Rows[i]["NetAmount"] + ")";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
if (argdtQ != null)
{
for (int i = 0; i < argdtQ.Rows.Count; i++)
{
sSql = "Insert Into dbo.CampaignQualifier(CampaignId,CostCentreId,Description,Flag,Amount)Values(" + argObject.CampId + "," + argdtQ.Rows[i]["CostCentreId"] + "," +
" '" + argdtQ.Rows[i]["Description"] + "','" + argdtQ.Rows[i]["Flag"] + "'," + argdtQ.Rows[i]["Amount"] + ")";
cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
//if (argdt != null)
//{
// if (argdt.Rows.Count > 0)
// {
// sSql = "Delete From dbo.CampaignQualifier Where CampaignId=" + argObject.CampId + "";
// cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
// cmd.ExecuteNonQuery();
// cmd.Dispose();
// for (int i = 0; i < argdt.Rows.Count; i++)
// {
// sSql = "Insert Into dbo.CampaignQualifier(CampaignId,Description,Flag,Amount)Values(" + argObject.CampId + "," +
// " '" + argdt.Rows[i]["Description"] + "','" + argdt.Rows[i]["Flag"] + "'," + argdt.Rows[i]["Amount"] + ")";
// cmd = new SqlCommand(sSql, BsfGlobal.g_CRMDB);
// cmd.ExecuteNonQuery();
// cmd.Dispose();
// }
// }
//}
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
public ActionResult Create(CampaignDataModel campaign)
{
CampaignBO.GetInstance().Create(campaign);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
return(View(CampaignBO.GetInstance().Get(id)));
}
//
// GET: /ManageCampaign/
public ActionResult Index()
{
return(View(CampaignBO.GetInstance().GetAll()));
}
