public static bool UpdateManualDeals(SBP_BlotterManualDeals ManualDealsItem) { bool status; try { SBP_BlotterManualDeals prodItem = DbContextB.SBP_BlotterManualDeals.Where(p => p.SNo == ManualDealsItem.SNo).FirstOrDefault(); if (prodItem != null) { prodItem.Description = ManualDealsItem.Description; prodItem.DealDate = ManualDealsItem.DealDate; prodItem.InFlow = ManualDealsItem.InFlow; prodItem.OutFlow = ManualDealsItem.OutFlow; prodItem.CurrentDate = ManualDealsItem.CurrentDate; prodItem.DealStatus = ManualDealsItem.DealStatus; DbContextB.SaveChanges(); } status = true; } catch (Exception) { status = false; } return(status); }
//[HttpGet] public ActionResult Create() { SBP_BlotterManualDeals model = new SBP_BlotterManualDeals(); model.DescriptionDD = GetDropDownList(); var dt= GetCurrentDT(); ViewData["SysCurrentDt"] = dt.ToString("dd-MMM-yyyy"); model.DealDate = dt; ViewData["BrCode"] = BrCode; return View(model); }
public static bool InsertManualDeals(SBP_BlotterManualDeals ManualDealsItem) { bool status; try { DbContextB.SBP_BlotterManualDeals.Add(ManualDealsItem); DbContextB.SaveChanges(); status = true; } catch (Exception ex) { System.Console.WriteLine(ex.Message.ToString()); status = false; } return(status); }
public static bool DeleteManualDeals(int id) { bool status; try { SBP_BlotterManualDeals prodItem = DbContextB.SBP_BlotterManualDeals.Where(p => p.SNo == id).FirstOrDefault(); if (prodItem != null) { DbContextB.SBP_BlotterManualDeals.Remove(prodItem); DbContextB.SaveChanges(); } status = true; } catch (Exception) { status = false; } return(status); }