public ActionResult Index() { List <Entity.Fuel> fuel = FuelLogic.getInstance().getAllFuel(); List <FuelModels> Data = new List <FuelModels>(); for (int i = 0; i < fuel.Count; i++) { FuelModels item = new FuelModels(); item.FuelId = fuel[i].FuilId; item.FuelName = fuel[i].Name; item.Price = fuel[i].Price; item.IsSubsidy = fuel[i].IsSubsidy == "Y"?"Subsidi":"Non Subsidi"; item.BackgroundColor = fuel[i].BackgroundColor; item.TextColor = fuel[i].TextColor; item.CreatedDate = fuel[i].CreatedDate; item.CreatedBy = fuel[i].CreatedBy; item.UpdatedDate = fuel[i].UpdatedDate; item.UpdatedBy = fuel[i].UpdatedBy; Data.Add(item); } PagedList <FuelModels> page = new PagedList <FuelModels>(); page.Content = Data; return(View(page)); }
public void Add(FuelModels model) { try { string dateTimeDayNow = DateTime.Now.ToString("ddMMyyyyHHmmss"); string dateDayNow = DateTime.Now.ToString("ddMMyyyy"); db = new BMotionDBEntities(); Fuel fuelEntity = new Fuel(); fuelEntity.FuilId = model.FuelId; fuelEntity.Name = model.FuelName; fuelEntity.Price = model.Price; fuelEntity.IsSubsidy = model.IsSubsidy; fuelEntity.BackgroundColor = model.BackgroundColor; fuelEntity.TextColor = model.TextColor; fuelEntity.CreatedDate = DateTime.Now; fuelEntity.CreatedBy = SessionManager.NIP(); db.Fuels.Add(fuelEntity); db.SaveChanges(); } catch (Exception e) { throw e; } }
public bool CheckExistingData(FuelModels model) { if (db.Fuels.Where(fuel => fuel.Name.Equals(model.FuelName)).Count() == 0) { return(true); } else { return(false); } }
public ActionResult Edit(FuelModels model) { try { FuelLogic.getInstance().Update(model); TempData["Success"] = "Success saving Data for " + model.FuelName; } catch (Exception e) { Logging.Log.getInstance().CreateLogError(e); } return(RedirectToAction("Index")); }
public void Update(FuelModels model) { try { db = new BMotionDBEntities(); Fuel fuel = (from u in db.Fuels where u.FuilId.Equals(model.FuelId) select u).First(); fuel.Name = model.FuelName; fuel.Price = model.Price; fuel.IsSubsidy = model.IsSubsidy; db.SaveChanges(); } catch (Exception e) { throw e; } }
public ActionResult Create(FuelModels model) { try { if (FuelLogic.getInstance().CheckExistingData(model)) { FuelLogic.getInstance().Add(model); TempData["Success"] = "Success saving Data for " + model.FuelName; } else { TempData["Error"] = "User " + model.FuelName + " is exist"; } } catch (Exception e) { Logging.Log.getInstance().CreateLogError(e); } return(RedirectToAction("Index")); }
public ActionResult Edit(int ID) { FuelModels model = new FuelModels(); var data = db.Fuels.Where(f => f.FuilId == ID).ToList(); if (data.Count() > 0) { model.FuelId = data.FirstOrDefault().FuilId; model.FuelName = data.FirstOrDefault().Name; model.Price = data.FirstOrDefault().Price; model.IsSubsidy = data.FirstOrDefault().IsSubsidy; model.BackgroundColor = data.FirstOrDefault().BackgroundColor; model.TextColor = data.FirstOrDefault().TextColor; model.CreatedDate = data.FirstOrDefault().CreatedDate; model.CreatedBy = data.FirstOrDefault().CreatedBy; model.UpdatedDate = data.FirstOrDefault().UpdatedDate; model.UpdatedBy = data.FirstOrDefault().UpdatedBy; } else { } return(View(model)); }
public ActionResult StrukBBM(string orderNo) { StruckModels struk = new StruckModels(); //StruckOrderDetails orderDetail = new StruckOrderDetails(); FuelModels fuelModels = new FuelModels(); List <StruckModels> listModel = new List <StruckModels>(); List <StruckOrderDetails> listOrder = new List <StruckOrderDetails>(); List <FuelModels> fuelList = new List <FuelModels>(); try { int n; bool isNumeric = int.TryParse(orderNo, out n); var list = db.sp_StrukPengambilanBBM(orderNo).ToList(); if (isNumeric) { // Confirmation Struck if (db.OrderDetails.AsEnumerable().Where(dtl => dtl.OrderDetailId == Int32.Parse(orderNo) && dtl.IsVerify == null).Count() > 0) { //OrderDetails model = new OrderDetails(); //model.OrderDetailId = Convert.ToInt32(orderNo); //OrdersLogic.getInstance().VerifyOrder(model); var verify = db.sp_OrderDetailVerify(orderNo); return(Json("OK", JsonRequestBehavior.AllowGet)); } else { return(Json("Failed", JsonRequestBehavior.AllowGet)); } } // Get Struk else if (list.Count > 0) { foreach (var item in list) { struk = new StruckModels(); struk.OrderNo = item.OrderNo; struk.OutletNo = item.OutletNo; struk.OutletName = item.OutletName; struk.Name = item.Name; struk.FuelName = item.FuelName; struk.Liter = item.Liter; struk.OrderDetailId = item.OrderDetailId; struk.CreatedDate = item.CreatedDate.Value.ToString("MM/dd/yyyy HH:mm:ss"); listModel.Add(struk); } } else { return(Json("Failed", JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Logging.Log.getInstance().CreateLogError(e); } return(Json(listModel, JsonRequestBehavior.AllowGet)); }