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"));
}
}
