public ActionResult CreateAdmin() { FinaceTool.Models.AMModel _AmDetails = new FinaceTool.Models.AMModel(); _AmDetails.CustomerList = BindDropdownAMDetails(); _AmDetails.duList = BindDropdownDUDetails(); _AmDetails.lobList = BindDropdownLobDetails(); _AmDetails.ProjectList = BindDropdownProjectDetails(); _AmDetails.serviceList = BindServiceLineDetails(); _AmDetails.ProductGroupList = BindDdlProductGroupDetails(); _AmDetails.DealStageList = BindDealStageDetails(); _AmDetails.SowStatusList = BindSowStatusDetails(); _AmDetails.AmUserList = BindAmUserDetails(); _AmDetails.OpportunityCategoryList = BindOpportunityCategoryDetails(); List <Quater> QuaterList = new List <Quater>(); var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList(); foreach (var quater in dbQuaterlist) { quater.QuaterName = quater.QuaterName + "_FC" + " ($K)"; QuaterList.Add(quater); } _AmDetails.Quaterlist = QuaterList; var AmDetailsModel = financetoolentities.Usp_GetAmMainDetails().OrderByDescending(item => item.S_No).ToList(); if (AmDetailsModel.Count == 0) { _AmDetails.S_No = 1; } else { _AmDetails.S_No = AmDetailsModel[0].S_No + 1; } return(View(_AmDetails)); }
public ActionResult DeleteAMGridById(FinaceTool.Models.AMModel amobj) { var result = financetoolentities.Opportunities.SingleOrDefault(b => b.OpportunityID.ToString() == amobj.OpportunityID); result.IsActive = false; financetoolentities.SaveChanges(); ViewBag.ddlAM = BindDropdownAMDetails(); return(View("DisplayAmDetails", Display())); }
public ActionResult Edit(Usp_GetAdminMainDetails_Result _amSelctedObj) { FinaceTool.Models.AMModel _AmDetails = new FinaceTool.Models.AMModel(); bool result = QuaterGenerator.EditRestrictionByRole(Session["RoleId"].ToString()); if (result == false) { TempData["Message"] = "You do not have permissions to Edit in this Time Slab."; return(View("DisplayAmDetails", Display())); } else { List <Usp_GetAdminMainDetails_V2_Result> myresult = financetoolentities.Usp_GetAdminMainDetails_V2() .Where(i => i.OpportunityID == _amSelctedObj.OpportunityID && i.CustomerID == _amSelctedObj.CustomerID && i.AMID == _amSelctedObj.AMID && i.OpportunityLobId == _amSelctedObj.LOBID && i.DUID == _amSelctedObj.DUID && i.ServiceLineID == _amSelctedObj.ServiceLineID && i.IsUpdated == false) .ToList(); _AmDetails.CustomerList = BindDropdownAMDetails(); _AmDetails.duList = BindDropdownDUDetails(); _AmDetails.lobList = BindDropdownLobDetails(); _AmDetails.ProjectList = BindDropdownProjectDetails(); _AmDetails.serviceList = BindServiceLineDetails(); _AmDetails.ProductGroupList = BindDdlProductGroupDetails(); _AmDetails.DealStageList = BindDealStageDetails(); _AmDetails.OpportunityCategoryList = BindOpportunityCategoryDetails(); _AmDetails.SowStatusList = BindSowStatusDetails(); _AmDetails.AmUserList = BindAmUserDetails(); //drop down binding ended _AmDetails.OpportunityName = myresult[0].OpportunityName; _AmDetails.S_No = myresult[0].S_No; //_AmDetails.acv = myresult[0].acv; _AmDetails.AMId = myresult[0].AMID.ToString(); _AmDetails.AMName = myresult[0].AMName; _AmDetails.BillingStratDate = myresult[0].BillingStratDate; _AmDetails.CustomerId = myresult[0].CustomerID.ToString(); _AmDetails.Customername = myresult[0].Customername; _AmDetails.DBBLDU = myresult[0].DBBLDU; _AmDetails.DBBLDuId = myresult[0].DBBLDUID.ToString(); _AmDetails.DuId = myresult[0].DUID.ToString(); _AmDetails.DUName = myresult[0].DUName; _AmDetails.LOBName = myresult[0].OpportunityLobName; _AmDetails.LobId = myresult[0].OpportunityLobId.ToString(); _AmDetails.OpportunityID = myresult[0].OpportunityID.ToString(); _AmDetails.OpportunityKeyID = Convert.ToInt16(myresult[0].OpportunityKeyID); if (string.IsNullOrEmpty(myresult[0].ProjectID.ToString())) { _AmDetails.ProjectId = "0"; } else { _AmDetails.ProjectIdForEdit = myresult[0].ProjectID.ToString(); } _AmDetails.ServiceLine = myresult[0].ServiceLine; _AmDetails.ProgramName = myresult[0].ProgramName; _AmDetails.ServiceLineId = myresult[0].ServiceLineID.ToString(); _AmDetails.ProductGroup = myresult[0].ProductGroup; _AmDetails.ProductGroupId = myresult[0].ProductGroupID.ToString(); _AmDetails.sowvalue = myresult[0].sowvalue; _AmDetails.DealStageId = myresult[0].DealStage.ToString(); _AmDetails.acv = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].acv))); _AmDetails.TCV = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].TCV))); _AmDetails.BillingStratDate = myresult[0].BillingStratDate; _AmDetails.Note_Comment = myresult[0].note; _AmDetails.IsUpdated = Convert.ToBoolean(myresult[0].IsUpdated); _AmDetails.OpportunityCategory = myresult[0].opportunitycategory; List <Quater> QuaterList = new List <Quater>(); var dbQuaterlist = financetoolentities.Quaters.Where(i => i.IsActive == true).ToList(); foreach (var quater in dbQuaterlist) { var value = myresult[0].GetType().GetProperty(quater.QuaterName); var Quartervalue = value.GetValue(myresult[0], null).ToString(); var qvalue = MyCustomFormat(Convert.ToDouble(Quartervalue)); quater.QuaterName = quater.QuaterName + "_FC($K):" + qvalue; QuaterList.Add(quater); } _AmDetails.Quaterlist = QuaterList; _AmDetails.SowStatusValue = Convert.ToDecimal(MyCustomFormat(Convert.ToDouble(myresult[0].SowStatusValue))); return(View(_AmDetails)); } }