public ActionResult Create([Bind(Include = "Pal_Id,Company_Id,Portfolio_Id,Current_Usage,Future_Scope,IsMarketLead")] PortfolioAgileLabTO portfolio_Agile_Lab) { if (ModelState.IsValid) { if (!pfRepo.CheckIfPortfolio_CompanyExist(portfolio_Agile_Lab.Portfolio_Id, portfolio_Agile_Lab.Company_Id)) { pfRepo.savePALData(portfolio_Agile_Lab); } else { //db.Entry(portfolio_Agile_Lab).State = EntityState.Modified; PortfolioAgileLabTO UpdateData = new PortfolioAgileLabTO(); UpdateData = pfRepo.GetAllPAL().Where(x => x.Portfolio_Id == portfolio_Agile_Lab.Portfolio_Id && x.Company_Id == portfolio_Agile_Lab.Company_Id).FirstOrDefault(); UpdateData.Current_Usage = portfolio_Agile_Lab.Current_Usage; UpdateData.IsMarketLead = portfolio_Agile_Lab.IsMarketLead; UpdateData.Future_Scope = portfolio_Agile_Lab.Future_Scope; //db.SaveChanges(); pfRepo.Update_Portfolio_Agile_LabData(UpdateData.Portfolio_Id, Convert.ToString(UpdateData.Current_Usage), UpdateData.Future_Scope, UpdateData.IsMarketLead, UpdateData.Company_Id); } return(RedirectToAction("Index")); } ViewBag.Company_Id = new SelectList(pfRepo.GetAllCompanies(), "Company_Id", "Company_Name", portfolio_Agile_Lab.Company_Id); ViewBag.Portfolio_Id = new SelectList(pfRepo.GetAllPortfolio(), "Portfolio_Id", "Portfolio_Name", portfolio_Agile_Lab.Portfolio_Id); return(View(portfolio_Agile_Lab)); }
//Save the models data //public void Update_Portfolio_Agile_LabData(int PortfolioId, string Curr_Usg, bool FutrFcsd, bool IsMrktLd) //{ // Portfolio_Agile_Lab portfolio_Agile_Lab = db.Portfolio_Agile_Lab.Where(x => x.Company_Id == CompanyId && x.Portfolio_Id == PortfolioId).FirstOrDefault(); // portfolio_Agile_Lab.Current_Usage = Convert.ToInt16(Curr_Usg); // portfolio_Agile_Lab.Future_Scope = FutrFcsd; // portfolio_Agile_Lab.IsMarketLead = IsMrktLd; // db.SaveChanges(); //} // GET: Portfolio_Agile_Lab/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PortfolioAgileLabTO portfolio_Agile_Lab = pfRepo.getPalbyId(id); if (portfolio_Agile_Lab == null) { return(HttpNotFound()); } return(View(portfolio_Agile_Lab)); }
public void savePALData(PortfolioAgileLabTO dataTOsave) { Portfolio_Agile_Lab dataTosave = new Portfolio_Agile_Lab() { Company_Id = dataTOsave.Company_Id, Current_Usage = dataTOsave.Current_Usage, Future_Scope = dataTOsave.Future_Scope, IsMarketLead = dataTOsave.IsMarketLead, Pal_Id = dataTOsave.Pal_Id, Portfolio_Id = dataTOsave.Portfolio_Id }; try { db.Portfolio_Agile_Lab.Add(dataTosave); db.SaveChanges(); } catch (Exception ex) { } }