public JsonResult Update(string dvsp, string diem) { JavaScriptSerializer serializer = new JavaScriptSerializer(); DichVu_SanPham dvsp_edit = serializer.Deserialize <DichVu_SanPham>(dvsp); if (!dvsp_edit.TenDichVu_SanPham.Equals("")) { DichVu_SanPham dv = db.DichVu_SanPham.SingleOrDefault(x => x.ID == dvsp_edit.ID); dv.TenDichVu_SanPham = dvsp_edit.TenDichVu_SanPham; dv.Loai = dvsp_edit.Loai; dv.DonGia = dvsp_edit.DonGia; dv.Diem = Double.Parse(diem.ToString(), CultureInfo.InvariantCulture); db.SaveChanges(); return(Json(new { status = true })); } else { return(Json(new { status = false })); } }
public ActionResult Create(DichVu_SanPham dvsp) { if (ModelState.IsValid) { dvsp.Status = true; TestObject test = new TestObject(); string exception = test.TestDichVu(dvsp.MaDV_SP, dvsp.TenDichVu_SanPham, dvsp.NgayApDung.Value); if (exception.Equals("OK")) { if (!dvsp.DonGia.HasValue || !dvsp.Diem.HasValue) { ModelState.AddModelError("", "Bạn chưa điền đơn giá hoặc điểm"); } else { db.DichVu_SanPham.Add(dvsp); db.SaveChanges(); return(RedirectToAction("Index")); } } else { ModelState.AddModelError("", exception); } } return(View(dvsp)); }
public JsonResult DropDownDV(string s) { //long idkh = long.Parse(Request.QueryString["kh"].ToString()); List <DichVu_SanPham> list = new List <DichVu_SanPham>(); var rs = db.DichVu_SanPham.Where(x => (x.MaDV_SP.Contains(s) || x.TenDichVu_SanPham.Contains(s)) && x.Status == true).ToList(); foreach (var item in rs) { DichVu_SanPham kh = new DichVu_SanPham(); kh.ID = item.ID; kh.TenDichVu_SanPham = item.TenDichVu_SanPham; list.Add(kh); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult Import(FormCollection formCollection) { var orderbyList = db.DichVu_SanPham.ToList().OrderBy(x => x.ID); if (Request != null) { DataTable dt = new DataTable(); HttpPostedFileBase file = Request.Files["UploadedFile"]; if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { if (file.FileName.EndsWith("xls") || file.FileName.EndsWith("xlsx")) { string fileName = file.FileName; string path = Server.MapPath("~/ExcelFiles/" + fileName); file.SaveAs(path); if (System.IO.File.Exists(Server.MapPath("~/ExcelFiles/" + fileName))) { System.IO.File.Delete(Server.MapPath("~/ExcelFiles/" + fileName)); } file.SaveAs(path); var excelData = new ExcelData(path); var sData = excelData.getData("DichVu_SanPham"); List <DichVu_SanPham> list = new List <DichVu_SanPham>(); dt = sData.CopyToDataTable(); foreach (DataRow item in dt.Rows) { DichVu_SanPham dvsp = new DichVu_SanPham(); dvsp.MaDV_SP = item["SKU"].ToString(); dvsp.TenDichVu_SanPham = item["Product/Service Name"].ToString(); if (item["Type"].ToString().ToUpper().Equals("SERVICE")) { dvsp.Loai = true; } else { dvsp.Loai = false; } if (item["Sales Price"].ToString() == null || item["Sales Price"].ToString() == "") { dvsp.DonGia = 0; } else { dvsp.DonGia = float.Parse(item["Sales Price"].ToString()); } dvsp.NgayApDung = DateTime.Now.Date; if (item["Scores"].ToString() == null || item["Scores"].ToString() == "") { dvsp.Diem = 0; } else { dvsp.Diem = float.Parse(item["Scores"].ToString()); } dvsp.Status = true; if (db.DichVu_SanPham.FirstOrDefault(x => x.MaDV_SP.Contains(dvsp.MaDV_SP)) == null) { db.DichVu_SanPham.Add(dvsp); db.SaveChanges(); } else { var rs = db.DichVu_SanPham.SingleOrDefault(x => x.MaDV_SP.Contains(dvsp.MaDV_SP) && x.Status == true); rs.Status = false; db.DichVu_SanPham.Add(dvsp); db.SaveChanges(); } //list.Add(dvsp); } string status = "Thành công"; TempData["msg"] = "<script>alert('Thành công');</script>"; return(RedirectToAction("Index", "DichVu", new { status })); //TempData["DichVu_SanPham"] = list; //if (ModelState.IsValid) //{ // if (list != null) // { // for (int i = 0; i < list.Count; i++) // { // List<DichVu_SanPham> dichVu_SanPham = db.DichVu_SanPham.Where(x => x.MaDV_SP.Contains(list[i].MaDV_SP.ToString())).ToList(); // if (dichVu_SanPham == null) // { // db.DichVu_SanPham.Add(list[i]); // db.SaveChanges(); // } // else // { // } // } // return RedirectToAction("Index", "DichVu"); // } //} } else { ViewBag.Error = "Vui lòng chọn file excel"; return(View("Index", orderbyList)); } } } ViewBag.Error = "Vui lòng chọn file excel"; return(View("Index", orderbyList)); }