//Adding Record into Replica table public void AddOldAMDetails(FormCollection _formcollectionobj) { var QuaterObj = _formcollectionobj.AllKeys.Where(i => i.Contains("_FC")); bool IsActive = true; int SalesForceCastID = 0; //if (Convert.ToInt16(_formcollectionobj["DealStageId"]) == 4 && !string.IsNullOrEmpty(_formcollectionobj["OpportunityName"]) // /* && Convert.ToInt16(_formcollectionobj["ProjectId"]) != 0*/) //{ // IsActive = false; //} //else //{ // IsActive = true; //} Random rnd = new Random(); string rndmvalue = string.Empty; for (int x = 0; x <= 15; x++) { long salesForceCastIDRndm = rnd.Next(1, 999999999); var value = financetoolentities.OpportunityForecastBySales.Where(i => i.SalesForceGuid == salesForceCastIDRndm).ToList(); rndmvalue = Convert.ToString(salesForceCastIDRndm); if (value.Count > 0) { continue; } else { break; } } OpportunityLatestInsert = financetoolentities.Usp_InsertOpportunityLatest(Convert.ToInt16(_formcollectionobj["OpportunityID"]), _formcollectionobj["OpportunityName"], Convert.ToInt32(_formcollectionobj["DealStageId"]), Convert.ToInt32(_formcollectionobj["sowvalue"]), Convert.ToInt16(_formcollectionobj["AMId"]), Convert.ToInt16(_formcollectionobj["CustomerId"]), _formcollectionobj["ProgramName"], Convert.ToInt16(_formcollectionobj["ServiceLineId"]), Convert.ToInt16(_formcollectionobj["ProductGroupId"]), Convert.ToInt16(_formcollectionobj["DBBLDuId"]), decimal.Parse(_formcollectionobj["TCV"]), decimal.Parse(_formcollectionobj["acv"]), Convert.ToInt16(_formcollectionobj["sowvalue"]), Convert.ToDateTime(_formcollectionobj["BillingStratDate"]), _formcollectionobj["Note_Comment"], Session["UserName"].ToString(), System.DateTime.Now, Session["UserName"].ToString(), System.DateTime.Now, 0, IsActive, long.Parse(rndmvalue), Convert.ToInt16(_formcollectionobj["DuId"]), Convert.ToInt16(_formcollectionobj["LobId"]), Convert.ToDecimal(_formcollectionobj["SowStatusValue"]), Convert.ToInt16(Session["UserId"]), Convert.ToInt16(Session["RoleId"]), false, false, _formcollectionobj["OpportunityCategory"]); List <Quater> QuaterList = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList(); foreach (var dbquater in QuaterList) { foreach (var Quarter in QuaterObj) { if (Quarter == dbquater.QuaterName + "_FC") { OpportunityForecastBySale opportunityForecastBySale = new OpportunityForecastBySale(); opportunityForecastBySale.QuaterID = dbquater.QuaterID; opportunityForecastBySale.forecastvaluebysales = string.IsNullOrEmpty(_formcollectionobj[Quarter].ToString()) == true ? 0 : decimal.Parse(_formcollectionobj[Quarter]); opportunityForecastBySale.SalesForceGuid = long.Parse(rndmvalue); opportunityForecastBySale.Createdby = Session["UserName"].ToString(); opportunityForecastBySale.Createddate = System.DateTime.Now; opportunityForecastBySale.Modifiedby = Session["UserName"].ToString(); opportunityForecastBySale.ModifiedDate = System.DateTime.Now; financetoolentities.OpportunityForecastBySales.Add(opportunityForecastBySale); opportunityForecastBySaleInsert = financetoolentities.SaveChanges(); SalesForceCastID = opportunityForecastBySale.SalesForceCastID; } } } }
public string Create([Bind(Exclude = "ProjectID")] FinaceTool.Models.ProjectTemp projecttemp) { string msg; if (projecttemp.OpportunityName != 0 && projecttemp.SOWStatus != 0) { Project project = new Project(); project.Createddate = System.DateTime.Now; project.IsActive = true; project.SowStatusID = projecttemp.SOWStatus; project.OpportunityID = projecttemp.OpportunityName; project.Createdby = Session["UserName"].ToString(); project.Modifiedby = Session["UserName"].ToString(); project.ProjectName = projecttemp.ProjectName; project.poavilable = projecttemp.poavilable; project.pobalance = projecttemp.pobalance; project.Note = projecttemp.Note; project.ProjectCode = projecttemp.ProjectCode; db.Projects.Add(project); db.SaveChanges(); int i = db.Usp_Update_Opportunity_IsMapped(projecttemp.OpportunityName); // GetOpportunityNames(); msg = "Saved Successfully"; } else { msg = "Opportunity Name Should provide to create a Project"; } return(msg); }
public string Create([Bind(Exclude = "ServiceLineID")] ServiceLine serviceLine) { string msg; if (ModelState.IsValid) { serviceLine.Createdby = Session["UserName"].ToString(); serviceLine.Modifiedby = Session["UserName"].ToString(); db.ServiceLines.Add(serviceLine); db.SaveChanges(); } msg = "Saved Successfully"; return(msg); }
public string Create([Bind(Exclude = "CustomerID")] customer customerec) { string msg; if (ModelState.IsValid) { customerec.Createdby = Session["UserName"].ToString(); customerec.Modifiedby = Session["UserName"].ToString(); db.customers.Add(customerec); db.SaveChanges(); } msg = "Saved Successfully"; return(msg); }
public string Create([Bind(Exclude = "ProductGroupID")] ProductGroup productrec) { string msg; if (ModelState.IsValid) { productrec.Createdby = Session["UserName"].ToString(); productrec.Modifiedby = Session["UserName"].ToString(); db.ProductGroups.Add(productrec); db.SaveChanges(); } msg = "Saved Successfully"; return(msg); }
public string Create([Bind(Exclude = "RoleID")] Role rolerec) { string msg; if (ModelState.IsValid) { rolerec.Createdby = Session["UserName"].ToString(); rolerec.Modifiedby = Session["UserName"].ToString(); db.Roles.Add(rolerec); db.SaveChanges(); } msg = "Role added Successfully"; return(msg); }
public string Create([Bind(Exclude = "SDUID")] FinaceTool.Models.SDUTemp sdurec) { string msg; SDU sdu = new SDU(); if (sdurec.LOBName != 0) { sdu.LOBID = sdurec.LOBName; sdu.Createdby = Session["UserName"].ToString(); sdu.Modifiedby = Session["UserName"].ToString(); db.SDUs.Add(sdu); db.SaveChanges(); } msg = "SDU added Successfully"; return(msg); }
public ActionResult PostCustomerRecord(customer customerrec) { FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); FinanceToolEntities2.customers.Add(customerrec); FinanceToolEntities2.SaveChanges(); return(View()); }
public ActionResult AddRole(Role role) { FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); FinanceToolEntities2.Roles.Add(role); FinanceToolEntities2.SaveChanges(); return(View("GetRole")); }
public ActionResult AddLOB(LOB lob) { FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); lob.Createddate = System.DateTime.Now; FinanceToolEntities2.LOBs.Add(lob); FinanceToolEntities2.SaveChanges(); return(View("GetLOB")); }
public ActionResult AddCustomer(customer customerrec) { FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); customerrec.Createddate = System.DateTime.Now; FinanceToolEntities2.customers.Add(customerrec); FinanceToolEntities2.SaveChanges(); return(View("AddCustomer")); }
public ActionResult AddSDU(SDU sdu) { if (ModelState.IsValid) { sdu.Createddate = System.DateTime.Now; FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); FinanceToolEntities2.SDUs.Add(sdu); FinanceToolEntities2.SaveChanges(); } return(View("GetSDU")); }
public string Create([Bind(Exclude = "UserID")] FinaceTool.Models.UserTemp userrec) { string rolename = Session["RoleName"].ToString(); string msg; User user = new User(); if (userrec.RoleName != 0) { user.RoleID = userrec.RoleName; user.Createdby = rolename; user.Modifiedby = rolename; user.Createddate = System.DateTime.Now; user.Password = userrec.Password; user.ISActive = userrec.ISActive; db.Users.Add(user); db.SaveChanges(); } msg = "Saved Successfully"; return(msg); }
public string Create([Bind(Exclude = "DUID")] FinaceTool.Models.DUTemp dutemp) { string msg; if (dutemp.AMName != 0 && dutemp.SDUName != 0) { DU Dbdu = new DU(); Dbdu.AMID = dutemp.AMName; Dbdu.SDUID = dutemp.SDUName; Dbdu.DUName = dutemp.DUName; Dbdu.DUHeadID = Convert.ToInt16(dutemp.DUHeadName); Dbdu.Createdby = Session["UserName"].ToString(); Dbdu.Modifiedby = Session["UserName"].ToString(); Dbdu.Createddate = System.DateTime.Now; Dbdu.IsActive = true; db.DUs.Add(Dbdu); db.SaveChanges(); } msg = "Saved Successfully"; return(msg); }
public ActionResult UpdateDUHData(FormCollection formcollection) { var UiFCQuaterobj = formcollection.AllKeys.Where(i => i.Contains("_FC")); var UiActQuaterobj = formcollection.AllKeys.Where(i => i.Contains("_AC")); int ProjectId = Convert.ToInt32(formcollection["ProjectID"]); string projectname = string.IsNullOrEmpty(formcollection["hdnProjectName"]) ? formcollection["ProjectName"] : formcollection["hdnProjectName"]; string OpportunityName = string.IsNullOrEmpty(formcollection["hdnOpportunityName"]) ? formcollection["OpportunityName"] : formcollection["hdnOpportunityName"]; int OpportunityId = Convert.ToInt16(formcollection["OpportunityID"]); int DealStageID = 0; decimal? TCV; decimal? ACV; DateTime?BillingStratDate; string Note = string.Empty; string CreatedBy = string.Empty; int SalesForceCastID = 0; bool? IsActive = true; long? SalesForceGuid; decimal? SowStatusValue; bool? IsMapped; string OpportunityCategory = string.Empty; if (!string.IsNullOrEmpty(formcollection["OpportunityID"].ToString())) { var opportunityresult = financetoolentities.Opportunities.Where(i => i.OpportunityID == OpportunityId && i.IsUpdated == false).SingleOrDefault(); var opportunitylatestresult = financetoolentities.Opportunity_Latest .SingleOrDefault(b => b.OpportunityID == OpportunityId && b.IsUpdated == false); if (opportunityresult != null) { financetoolentities.Usp_UpdateOpportunity(opportunityresult.OpportunityID); TCV = opportunityresult.TCV; ACV = opportunityresult.acv; BillingStratDate = opportunityresult.BillingStratDate; Note = opportunityresult.Note; CreatedBy = opportunityresult.Createdby; SalesForceCastID = opportunityresult.SalesForceCastID; SalesForceGuid = opportunityresult.SalesForceGuid; SowStatusValue = opportunityresult.SowStatusValue; IsMapped = opportunityresult.IsMapped; OpportunityCategory = opportunityresult.OpportunityCategory; if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString())) { // IsActive = false; DealStageID = 4; IsMapped = true; } else { // IsActive = true; DealStageID = Convert.ToInt16(formcollection["dealstageId"]); IsMapped = false; } } else { financetoolentities.Usp_UpdateOpportunityLatest(opportunitylatestresult.OpportunityID); TCV = opportunitylatestresult.TCV; ACV = opportunitylatestresult.acv; BillingStratDate = opportunitylatestresult.BillingStratDate; Note = opportunitylatestresult.Note; CreatedBy = opportunitylatestresult.Createdby; SalesForceCastID = opportunitylatestresult.SalesForceCastID; SalesForceGuid = opportunitylatestresult.SalesForceGuid; SowStatusValue = opportunitylatestresult.SowStatusValue; IsMapped = opportunitylatestresult.IsMapped; OpportunityCategory = opportunitylatestresult.OpportunityCategory; if (projectname != "Please Select Project" && !string.IsNullOrEmpty(OpportunityId.ToString())) { //IsActive = false; DealStageID = 4; IsMapped = true; } else { // IsActive = true; DealStageID = Convert.ToInt16(formcollection["dealstageId"]); IsMapped = false; } } financetoolentities.Usp_InsertOpportunityLatest(Convert.ToInt16(formcollection["OpportunityID"]), OpportunityName, DealStageID, Convert.ToInt16(formcollection["SowStatus"]), Convert.ToInt16(formcollection["AMID"]), Convert.ToInt16(formcollection["selectedcustomerId"]), formcollection["ProgramName"], Convert.ToInt16(formcollection["ServiceLineID"]), Convert.ToInt16(formcollection["ProductGroupID"]), Convert.ToInt16(formcollection["DBBLDUID"]), TCV, ACV, Convert.ToInt16(formcollection["SowStatus"]), BillingStratDate, Note, CreatedBy, System.DateTime.Now, Session["UserName"].ToString(), System.DateTime.Now, SalesForceCastID, IsActive, SalesForceGuid, Convert.ToInt16(formcollection["DUID"]), Convert.ToInt16(formcollection["LOBID"]), SowStatusValue, Convert.ToInt16(Session["UserId"]), Convert.ToInt16(Session["RoleId"]), IsMapped, false, OpportunityCategory); financetoolentities.SaveChanges(); } var myACTQuaterList = financetoolentities.quater_Actual.Where(i => i.IsActive == true).ToList(); var myFCQuaterList = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList(); foreach (var quarters in myACTQuaterList) { var actresult = financetoolentities.ProjectActualByDUHs .Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault(); if (actresult != null) { if (quarters.QuaterID == actresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_AC"])) { //making old records as o actresult.IsNew = false; financetoolentities.SaveChanges(); //Added new records ProjectActualByDUH _projactobj = new ProjectActualByDUH(); _projactobj.Createdby = Session["UserName"].ToString(); _projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]); _projactobj.OpportunityID = OpportunityId; _projactobj.Createddate = System.DateTime.Now; _projactobj.Modifiedby = Session["UserName"].ToString(); _projactobj.ModifiedDate = System.DateTime.Now; _projactobj.QuaterID = quarters.QuaterID; _projactobj.IsNew = true; financetoolentities.ProjectActualByDUHs.Add(_projactobj); financetoolentities.SaveChanges(); } } else { ProjectActualByDUH _projactobj = new ProjectActualByDUH(); _projactobj.Createdby = Session["UserName"].ToString(); _projactobj.actualvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_AC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_AC"]); _projactobj.OpportunityID = OpportunityId; _projactobj.Createddate = System.DateTime.Now; _projactobj.Modifiedby = Session["UserName"].ToString(); _projactobj.ModifiedDate = System.DateTime.Now; _projactobj.QuaterID = quarters.QuaterID; _projactobj.IsNew = true; financetoolentities.ProjectActualByDUHs.Add(_projactobj); financetoolentities.SaveChanges(); } } foreach (var quarters in myFCQuaterList) { var fcresult = financetoolentities.ProjectForecastByDUHs .Where(i => i.OpportunityID == OpportunityId && i.QuaterID == quarters.QuaterID).Where(i => i.IsNew == true).SingleOrDefault(); if (fcresult != null) { if (quarters.QuaterID == fcresult.QuaterID && !string.IsNullOrEmpty(formcollection[quarters.QuaterName + "_FC"].ToString())) { //Old forecast values are becoming null fcresult.IsNew = false; financetoolentities.SaveChanges(); //Adding new records ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH(); _projfcobj.Createdby = Session["UserName"].ToString(); _projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]); _projfcobj.OpportunityID = OpportunityId; _projfcobj.Createddate = System.DateTime.Now; _projfcobj.Modifiedby = Session["UserName"].ToString(); _projfcobj.ModifiedDate = System.DateTime.Now; _projfcobj.QuaterID = quarters.QuaterID; _projfcobj.IsNew = true; financetoolentities.ProjectForecastByDUHs.Add(_projfcobj); financetoolentities.SaveChanges(); } } else { ProjectForecastByDUH _projfcobj = new ProjectForecastByDUH(); _projfcobj.Createdby = Session["UserName"].ToString(); _projfcobj.forecastvaluebyduh = string.IsNullOrEmpty(formcollection[quarters.QuaterName.ToString() + "_FC"]) == true ? 0 : Convert.ToDecimal(formcollection[quarters.QuaterName.ToString() + "_FC"]); _projfcobj.OpportunityID = OpportunityId; _projfcobj.Createddate = System.DateTime.Now; _projfcobj.Modifiedby = Session["UserName"].ToString(); _projfcobj.ModifiedDate = System.DateTime.Now; _projfcobj.QuaterID = quarters.QuaterID; _projfcobj.IsNew = true; financetoolentities.ProjectForecastByDUHs.Add(_projfcobj); financetoolentities.SaveChanges(); } } return(RedirectToAction("Index")); }