public ActionResult Insert(FormCollection form, HttpPostedFileBase txtSimage) { string name = "txtSimage"; if (txtSimage != null) { int size = (int)txtSimage.ContentLength / 1024; var extention = System.IO.Path.GetExtension(txtSimage.FileName); if (size <= 1024 && (extention.ToLower().Equals(".jpg") || extention.ToLower().Equals(".jpeg") || extention.ToLower().Equals(".png"))) { name = Code() + "" + extention; string path = Server.MapPath("~/Images/"); txtSimage.SaveAs(path + "" + name); } } tblService service = new tblService(); service.ServiceName = form["txtSname"]; service.ServiceDesc = form["txtDesc"]; service.ServiceImage = name.ToString(); service.IsActive = false; service.CreatedOn = DateTime.Now; dc.tblServices.Add(service); dc.SaveChanges(); return(RedirectToAction("Index", "Service")); }
public ActionResult Edit(int id) { TempData["id"] = id; tblService service = dc.tblServices.SingleOrDefault(ob => ob.ServiceId == id); return(View(service)); }
public ActionResult Edit(tblService tblservice, int id, FormCollection collection) { if (ModelState.IsValid) { tblservice.DateCreate = DateTime.Now; tblservice.Tag = StringClass.NameToTag(tblservice.Name); db.Entry(tblservice).State = EntityState.Modified; db.SaveChanges(); #region [Updatehistory] Updatehistoty.UpdateHistory("Edit tblservice", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString()); #endregion if (collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/servicead/Index")); } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/servicead/Create")); } } return(View(tblservice)); }
public ActionResult Delete(int id) { tblService service = dc.tblServices.SingleOrDefault(ob => ob.ServiceId == id); dc.tblServices.Remove(service); dc.SaveChanges(); return(RedirectToAction("Index", "Service")); }
public ActionResult Detail(int id) { tblService service = dc.tblServices.SingleOrDefault(ob => ob.ServiceId == id); ViewBag.Company = (from ob in dc.tblTransportCompanies where ob.CompanyId == service.CompanyId select ob).Take(1).SingleOrDefault().CompanyName; string Name = ViewBag.Company; return(View(service)); }
public ActionResult Edit(FormCollection form) { int id = Convert.ToInt32(TempData["id"]); tblService service = dc.tblServices.SingleOrDefault(ob => ob.ServiceId == id); service.ServiceName = form["txtSname"]; service.ServiceDesc = form["txtDesc"]; service.ServiceImage = form["txtSimage"]; dc.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult Save_Service(tblService[] service) { var value = 0; var Id = 0; try { if (service[0].Id > 0) { var update = db.tblServices.Find(service[0].Id); update.S_Name = service[0].S_Name; update.S_Money = service[0].S_Money; update.S_Note = service[0].S_Note; db.SaveChanges(); value = service[0].Id; } else { var servicenew = new tblService(); var layid = (from S in db.tblServices where S.Id > 0 orderby S.Id descending select new { Id_service = S.Id }).Take(1).ToArray(); if (layid.Any()) { servicenew.Id = layid[0].Id_service + 1; } else { servicenew.Id = 1; } Id = servicenew.Id; servicenew.S_Name = service[0].S_Name; servicenew.S_Money = service[0].S_Money; servicenew.S_Note = service[0].S_Note; servicenew.S_Active = true; db.tblServices.Add(servicenew); db.SaveChanges(); value = servicenew.Id; } } catch (Exception) { value = 0; } var data = new { sussecc = value, Id = Id }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult Active(int id) { tblService service = dc.tblServices.SingleOrDefault(ob => ob.ServiceId == id); if (service.IsActive == true) { service.IsActive = false; } else { service.IsActive = true; } dc.SaveChanges(); return(Json(service.IsActive, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteService(int id) { if (ClsCheckRole.CheckQuyen(14, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { tblService tblservice = db.tblServices.Find(id); var result = string.Empty; db.tblServices.Remove(tblservice); db.SaveChanges(); result = "Bạn đã xóa thành công."; return(Json(new { result = result })); } else { var result = string.Empty; result = "Bạn không có quyền thay đổi tính năng này"; return(Json(new { result = result })); } }
public Service CreateService(IService service) { var newservice = new tblService() { ServiceID = service.ServiceID, SiteID = service.SiteID, StartDate = service.StartDate, ContractNumber = service.ContractNumber, ContainerID = service.ContainerID, EWC = service.EWC, ScheduleFrequencyID = service.ScheduleFrequencyID, ScheduleDay = service.ScheduleDay, InPrice = service.InPrice, OutPrice = service.OutPrice, CarrierID = service.CarrierID, DisposalLocationID = service.DisposalLocationID, IsRecurring = service.IsRecurring }; using (var dbContextTransaction = _context.Database.BeginTransaction()) { try { _context.tblServices.Add(newservice); _context.SaveChanges(); var newcontractnumber = new tblContractNumber() { ServiceID = newservice.ServiceID }; _context.tblContractNumbers.Add(newcontractnumber); _context.SaveChanges(); newservice.ContractNumber = newcontractnumber.ContractNumber; _context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception e) { dbContextTransaction.Rollback(); } } return(new Service(newservice)); }
public ActionResult Edit(int id = 0) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(14, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { tblService tblservice = db.tblServices.Find(id); if (tblservice == null) { return(HttpNotFound()); } return(View(tblservice)); } else { return(Redirect("/Users/Erro")); } }
public ActionResult Create(tblService tblservice, FormCollection collection) { tblservice.DateCreate = DateTime.Now; tblservice.Tag = StringClass.NameToTag(tblservice.Name); db.tblServices.Add(tblservice); db.SaveChanges(); #region [Updatehistory] Updatehistoty.UpdateHistory("Add tblservice", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString()); #endregion if (collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/servicead/Index")); } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm danh mục mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/servicead/Create")); } return(Redirect("Index")); }
public ActionResult Index(int?page, string id, FormCollection collection) { if ((Request.Cookies["Username"] == null)) { return(RedirectToAction("LoginIndex", "Login")); } if (ClsCheckRole.CheckQuyen(14, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { var listService = db.tblServices.ToList(); const int pageSize = 20; var pageNumber = (page ?? 1); // Thiết lập phân trang var ship = new PagedListRenderOptions { DisplayLinkToFirstPage = PagedListDisplayMode.Always, DisplayLinkToLastPage = PagedListDisplayMode.Always, DisplayLinkToPreviousPage = PagedListDisplayMode.Always, DisplayLinkToNextPage = PagedListDisplayMode.Always, DisplayLinkToIndividualPages = true, DisplayPageCountAndCurrentLocation = false, MaximumPageNumbersToDisplay = 5, DisplayEllipsesWhenNotShowingAllPageNumbers = true, EllipsesFormat = "…", LinkToFirstPageFormat = "Trang đầu", LinkToPreviousPageFormat = "«", LinkToIndividualPageFormat = "{0}", LinkToNextPageFormat = "»", LinkToLastPageFormat = "Trang cuối", PageCountAndCurrentLocationFormat = "Page {0} of {1}.", ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.", FunctionToDisplayEachPageNumber = null, ClassToApplyToFirstListItemInPager = null, ClassToApplyToLastListItemInPager = null, ContainerDivClasses = new[] { "pagination-container" }, UlElementClasses = new[] { "pagination" }, LiElementClasses = Enumerable.Empty <string>() }; ViewBag.ship = ship; if (Session["Thongbao"] != null && Session["Thongbao"] != "") { ViewBag.thongbao = Session["Thongbao"].ToString(); Session["Thongbao"] = ""; } if (collection["btnDelete"] != null) { foreach (string key in Request.Form.Keys) { var checkbox = ""; if (key.StartsWith("chk_")) { checkbox = Request.Form["" + key]; if (checkbox != "false") { if (ClsCheckRole.CheckQuyen(14, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true) { int ids = Convert.ToInt32(key.Remove(0, 4)); tblService tblservice = db.tblServices.Find(ids); db.tblServices.Remove(tblservice); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(Redirect("/Users/Erro")); } } } } } return(View(listService.ToPagedList(pageNumber, pageSize))); } else { return(Redirect("/Users/Erro")); } }