public ActionResult GetSDU() { FinanceToolEntities entities = new FinanceToolEntities(); ViewBag.Organisations = new SelectList(entities.LOBs.ToList(), "LOBID", "LOBName"); return(View()); }
public ActionResult About() { FinanceToolEntities financetoolentities = new FinanceToolEntities(); var data = financetoolentities.Usp_GetForecastValues().ToList(); List <string> lstforecastvalues = new List <string>(); List <string> QuaterName = new List <string>(); //ViewBag.Message = "Your application description page."; foreach (var item in data) { //var value = item.GetType().GetProperty(item.QuaterName); //var Quartervalue = value.GetValue(item, null).ToString(); var qvalue = MyCustomFormat(Convert.ToDouble(item.ForecastValues)); lstforecastvalues.Add(qvalue); QuaterName.Add(item.QuaterName); } string names = QuaterName[0] + "," + QuaterName[1] + "," + QuaterName[2] + "," + QuaterName[3]; var quarternames = names; Session["QuarterNames"] = quarternames; string forecastvalues = lstforecastvalues[0] + "," + lstforecastvalues[1] + "," + lstforecastvalues[2] + "," + lstforecastvalues[3]; //var forecastvaluesarr = forecastvalues.Split(','); Session["forecastvalues"] = forecastvalues; return(View()); }
public ActionResult Index() { QuaterGenerator.UpdateActiveQuaters(); FinanceToolEntities financetoolentities = new FinanceToolEntities(); var PMOGriddetails = financetoolentities.Usp_GetPMOOpportunityDetails().ToList(); return(View(PMOGriddetails)); }
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 ActionResult GetInsertRecord() { int roleid = 10; ProjectDetails ProjectDetails = new ProjectDetails(); FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); ProjectDetails.CustomerNames = FinanceToolEntities2.customers.Select(x => x.CustomerName).ToList(); ProjectDetails.AMNames = FinanceToolEntities2.Roles.Where(x => x.RoleID == roleid).Select(x => x.RoleName).ToList(); ProjectDetails.LOBs = FinanceToolEntities2.LOBs.Select(x => x.LOBName).ToList(); ProjectDetails.OppurtunityIDs = FinanceToolEntities2.Opportunities.Select(x => x.OpportunityID).ToList(); ProjectDetails.OpportunityNames = FinanceToolEntities2.Opportunities.Select(x => x.OpportunityName).ToList(); ProjectDetails.ProjectIDs = FinanceToolEntities2.Projects.Select(x => x.ProjectID).ToList(); ProjectDetails.ProgramNames = FinanceToolEntities2.Opportunities.Select(x => x.ProgramName).ToList(); ProjectDetails.ServiceLines = FinanceToolEntities2.ServiceLines.Select(x => x.ServiceLineName).ToList(); ProjectDetails.DUNames = FinanceToolEntities2.DUs.Select(x => x.DUName).ToList(); ProjectDetails.ProductGroups = FinanceToolEntities2.ProductGroups.Select(x => x.ProductGroupName).ToList(); return(PartialView("_InsertRecord", ProjectDetails)); }
public ActionResult GetProjectDetails() { List <ProjectDetails> Projectdetails = new List <ProjectDetails>(); FinanceToolEntities FinanceToolEntities2 = new FinanceToolEntities(); var datacontent = FinanceToolEntities2.AMTable().ToList(); foreach (var item in datacontent) { ProjectDetails ProjectDetailitem = new ProjectDetails(); ProjectDetailitem.SNo = item.S_No; ProjectDetailitem.CustomerName = item.CustomerName; ProjectDetailitem.AMName = item.AMName; ProjectDetailitem.LOB = item.LOBName; ProjectDetailitem.DUName = item.DUName; ProjectDetailitem.DBBLDU = item.DBBLDU; ProjectDetailitem.OpportunityID = item.OpportunityID; ProjectDetailitem.OpportunityName = item.OpportunityName; ProjectDetailitem.ProjectID = item.ProjectID; ProjectDetailitem.ProgramName = item.ProgramName; ProjectDetailitem.ServiceLine = item.ServiceLine; ProjectDetailitem.ProductGroup = item.ProductGroup; ProjectDetailitem.TCV = item.TCV; ProjectDetailitem.ACV = item.acv; ProjectDetailitem.SOWValue = item.sowvalue; ProjectDetailitem.DealStage = item.DealStage; ProjectDetailitem.BillingStartDate = item.BillingStratDate; ProjectDetailitem.Note = item.Note; Projectdetails.Add(ProjectDetailitem); } return(View(Projectdetails)); //return View(ProjectDetails); }