public ActionResult DeleteProduct(int id) { tbl_Product tb = _db.tbl_Product.Where(u => u.ProductId == id).FirstOrDefault(); ProductViewModel pvm = new ProductViewModel(); pvm.ProductId = tb.ProductId; pvm.ProductName = tb.ProductName; pvm.ProductDescription = tb.ProductDescription; pvm.ProductPackingDate = tb.ProductPackingDate; pvm.ProductExpireDate = tb.ProductExpireDate; tbl_Deals td = _db.tbl_Deals.Where(u => u.DealsId == id).FirstOrDefault(); pvm.DealsName = td.DealsName; tbl_ProductCategory tpc = _db.tbl_ProductCategory.Where(u => u.CategoryId == tb.CategoryId).FirstOrDefault(); pvm.CategoryName = tpc.CategoryName; tbl_ProductStatus tpss = _db.tbl_ProductStatus.Where(u => u.StatusId == tb.StatusId).FirstOrDefault(); pvm.StatusName = tpss.StatusName; tbl_ProductStore tps = _db.tbl_ProductStore.Where(u => u.ProductId == tb.ProductId).FirstOrDefault(); tbl_Store ts = _db.tbl_Store.Where(u => u.StoreId == tps.StoreId).FirstOrDefault(); pvm.StoreName = ts.StoreName; return(View(pvm)); }
/// <summary> /// them moi khach san /// </summary> /// <returns></returns> //[HttpPost] //[ValidateAntiForgeryToken] public JsonResult CreateHotels(HotelDefaultModel hotel) { object[] message = new object[2]; DataSet ds = new DataSet(); string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); try { if (hotel != null & ModelState.IsValid) { ds = db.InsertHotel(hotel); message[0] = ds.Tables[0].Rows[0].ItemArray; if (ds.Tables.Count > 1) { message[1] = db.getObjectHotel(ds.Tables[1]); tbl_Store tbl = new tbl_Store(); tbl.title = "Kho chính"; tbl.SysHotelID = (new HotelService()).GetHotelByCode(ds.Tables[1].Rows[0]["code"].ToString()).Id; tbl.typeStore = 1; tbl.datecreated = DateTime.Now; tbl.creatorid = comm.GetUserId(); new StoreManagerService().InsertOrUpdateStoreGeneral(tbl); } } } catch (Exception ex) { throw ex; } //ViewData["hotelList"] = result; return(Json(new { mess = message }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteStores(int id) { tbl_Store tb = _db.tbl_Store.Where(u => u.StoreId == id).FirstOrDefault(); _db.tbl_Store.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Store")); }
public ActionResult EditStore(int id) { tbl_Store tb = _db.tbl_Store.Where(p => p.StoreId == id).FirstOrDefault(); StoreViewModel svm = new StoreViewModel(); svm.StoreId = tb.StoreId; svm.StoreName = tb.StoreName; svm.StoreLocation = tb.StoreLocation; svm.StoreCapacity = tb.StoreCapacity; return(View(svm)); }
public ActionResult ThemKho(FormCollection collection, tbl_Store kho) { var maSP = Request.Form["masp"]; var slTon = collection["soluongton"]; kho.ProductId = Convert.ToInt32(maSP); kho.Number = Convert.ToInt32(slTon); ddd.tbl_Stores.InsertOnSubmit(kho); ddd.SubmitChanges(); return(RedirectToAction("Kho", "Kho")); }
public int InsertOrUpdateStoreGeneral(tbl_Store store) { try { using (var db = _connectionData.OpenDbConnection()) { return((int)db.Insert(store, selectIdentity: true)); } } catch (Exception) { return(-1); } }
/// Save Store public bool SaveStores(StoreViewModel storeViewModel) { bool status = false; tbl_Store stores = new tbl_Store(); Mapper.Map(storeViewModel, stores); stores.IsActive = true; stores.CreatedDate = DateTime.Now; stores.ModifiedDate = DateTime.Now; stores.CreatedBy = "101"; stores.ModifiedBy = "101"; _Context.tbl_Store.Add(stores); _Context.Configuration.ValidateOnSaveEnabled = true; _Context.SaveChanges(); status = true; return(status); // for new users }
public ActionResult EditStores(StoreViewModel svm) { if (ModelState.IsValid) { try { tbl_Store store = _db.tbl_Store.Where(p => p.StoreId == svm.StoreId).FirstOrDefault(); store.StoreId = svm.StoreId; store.StoreName = svm.StoreName; store.StoreLocation = svm.StoreLocation; store.StoreCapacity = svm.StoreCapacity; _db.SaveChanges(); ViewBag.Message = "Store Updated Successfully."; return(RedirectToAction("Store")); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Admin", "EditStore"))); } } return(RedirectToAction("Store")); }
public ActionResult InsertStore(StoreViewModel svm) { if (ModelState.IsValid) { try { tbl_Store store = new tbl_Store(); store.StoreId = svm.StoreId; store.StoreName = svm.StoreName; store.StoreLocation = svm.StoreLocation; store.StoreCapacity = svm.StoreCapacity; _db.tbl_Store.Add(store); _db.SaveChanges(); ViewBag.Message = "Store Created Successfully."; return(RedirectToAction("Store")); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Admin", "InsertStore"))); } } return(View()); }
public int InsertOrUpdateStore(MinibarModel model) { try { using (var db = _connectionData.OpenDbConnection()) { using (var tran = db.OpenTransaction()) { try { if (model.Id > 0) { var query = db.From <tbl_Store>().Where(e => e.Id == model.Id); var up = db.Select(query).SingleOrDefault(); if (up != null)//update store { up.title = model.Name; up.roomid = model.RoomId; db.Update(up); } var strDel = db.From <tbl_StoreProduct_Config>().Where(e => e.storeid == model.Id); var del = db.Select(strDel); if (del.Any()) { db.DeleteAll(del); } if (model.Item.Any())//update store product config { var list = model.Item.Select(item => new tbl_StoreProduct_Config { productid = item.ProductId, minimize = item.Limit, SysHotelID = comm.GetHotelId(), datecreated = DateTime.Now, storeid = model.Id }); db.InsertAll(list); } tran.Commit(); return(1); } //Insert------------------------- var check = db.From <tbl_Store>().Where(e => e.roomid == model.RoomId); var isExit = db.Select(check).FirstOrDefault(); if (isExit == null) //Nếu roomID tồn tại rồi thì k cho insert nữa { var store = new tbl_Store { title = model.Name, roomid = model.RoomId, creatorid = comm.GetUserId(), SysHotelID = comm.GetHotelId(), datecreated = DateTime.Now, typeStore = 2 }; var idStore = db.Insert(store, true); //insert product if (model.Item.Any()) //insert store product { var list = model.Item.Select(item => new tbl_StoreProduct_Config { productid = item.ProductId, minimize = item.Limit, SysHotelID = comm.GetHotelId(), datecreated = DateTime.Now, storeid = int.Parse(idStore.ToString()) }); db.InsertAll(list); /* * var list = model.Item.Select(item => new tbl_StoreProduct * { * productid = item.ProductId, * quantity = item.Limit, * SysHotelID = comm.GetHotelId(), * datecreated = DateTime.Now, * storeid = int.Parse(idStore.ToString()) * }); * db.InsertAll(list); */ } tran.Commit(); return(1); } return(-100); } catch (Exception) { tran.Rollback(); return(-1); } } } } catch (Exception) { return(-1); } }