public ActionResult Create([Bind(Include = "ID,InstrumentID,Year,Annual,Q1,Q2,Q3,Q4,Currency,InstrumentCode,CreatedOn,CreatedBy")] CompanyEarning companyEarning) { GetViewDropDownData(); var companyEarnings = db.usp_GetCompanyEarnings().Where(ce => ce.InstrumentCode == companyEarning.InstrumentCode && ce.Year == companyEarning.Year).ToList(); if (companyEarnings.Count() > 0) { ModelState.AddModelError("Company Earnings", "Company Earnings Information has already been updated for the selected Symbol."); } else { if (ModelState.IsValid) { try { db.CompanyEarnings.Add(companyEarning); db.SaveChanges(); TempData["Message"] = "Company Earning Successfully Added"; return(RedirectToAction("Index", new { Symbols = companyEarning.InstrumentCode })); } catch (Exception exp) { ViewData["Message"] = "Error Adding Company Earnings."; ModelState.AddModelError("Error", "An error has occured please contact Administrator"); log.Error(exp); return(View(companyEarning)); } } } //ViewBag.InstrumentCode = new SelectList(db.Instruments, "InstrumentCode", "ISIN", companyEarning.InstrumentCode); return(View(companyEarning)); }
// GET: CompanyEarnings/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyEarning companyEarning = db.CompanyEarnings.Find(id); if (companyEarning == null) { return(HttpNotFound()); } return(View(companyEarning)); }
// GET: CompanyEarnings/Edit/5 public ActionResult Edit(int?id) { GetViewDropDownData(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CompanyEarning companyEarning = db.CompanyEarnings.Find(id); if (companyEarning == null) { return(HttpNotFound()); } // ViewBag.InstrumentCode = new SelectList(db.Instruments, "InstrumentCode", "ISIN", companyEarning.InstrumentCode); return(View(companyEarning)); }
public ActionResult DeleteConfirmed(int id) { try { CompanyEarning companyEarning = db.CompanyEarnings.Find(id); db.CompanyEarnings.Remove(companyEarning); db.SaveChanges(); TempData["Message"] = "Company Earning was successfully deleted."; return(RedirectToAction("Index")); } catch (Exception exp) { TempData["Message"] = "Error Editing Company Earnings."; ModelState.AddModelError("Error", "An error has occured please contact Administrator"); return(RedirectToAction("Index")); } }
public ActionResult Edit([Bind(Include = "ID,InstrumentID,Year,Annual,Q1,Q2,Q3,Q4,Currency,InstrumentCode,ModifiedOn,ModifiedBy")] CompanyEarning companyEarning) { GetViewDropDownData(); // if(companyEarning.Currency1.CurrencyID) if (ModelState.IsValid) { try { db.Entry(companyEarning).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["Message"] = "Company Earning was Successfully Edited."; return(RedirectToAction("Index", new { Symbols = companyEarning.InstrumentCode })); } catch (Exception exp) { ViewData["Message"] = "Error Editing Company Earnings."; ModelState.AddModelError("Error", "An error has occured please contact Administrator"); return(View(companyEarning)); } } //ViewBag.InstrumentCode = new SelectList(db.Instruments, "InstrumentCode", "ISIN", companyEarning.InstrumentCode); return(View(companyEarning)); }