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