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 ActionResult Create(KhachHang khachHang)
{
if (ModelState.IsValid)
{
db.KhachHangs.Add(khachHang);
TestObject test = new TestObject();
string exeption = test.TestKhachHangs(khachHang.ID, khachHang.HoTen, khachHang.SDT, khachHang.DiaChi);
if (exeption.Equals("OK"))
{
for (int i = 1; i <= 5; i++)
{
MayLanh ml = new MayLanh();
ml.Ma = "ML" + i;
ml.Status = 1;
khachHang.MayLanhs.Add(ml);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", exeption);
}
}
return(View(khachHang));
}
public ActionResult Create(MayLanh mayPhucVu, int idkh)
{
if (ModelState.IsValid)
{
if (checkMa(mayPhucVu.Ma, idkh) == false)
{
ModelState.AddModelError("Ma", "Mã đã tồn tại");
}
else
{
mayPhucVu.IDKhachHang = idkh;
mayPhucVu.Ma = mayPhucVu.Ma.ToUpper();
mayPhucVu.Status = 1;
db.MayLanhs.Add(mayPhucVu);
TestObject test = new TestObject();
string exception = test.TestMayPhucVus(mayPhucVu.TenMay, mayPhucVu.ViTri);
if (exception == "OK")
{
db.SaveChanges();
return(RedirectToAction("Index", "MayPhucVu", new { idkh = idkh }));
}
else
{
ModelState.AddModelError("", exception);
}
}
}
ViewBag.KH = db.KhachHangs.Find(idkh);
return(View(mayPhucVu));
}
public ActionResult Create(NhanVien nhanVien, LoginModel model)
{
if (ModelState.IsValid)
{
string reg = @"^[a-zA-Z]{1}[a-zA-Z0-9]{0,23}$";
if (Regex.IsMatch(nhanVien.Username, reg) && nhanVien.Username.Length > 5)
{
nhanVien.Password = model.CreateMD5(model.Base64Encode("Aa123456"));
db.NhanViens.Add(nhanVien);
TestObject test = new TestObject();
string exception = test.TestNhanViens(nhanVien.Username, nhanVien.TenKTV, nhanVien.SDT, true);
if (exception.Equals("OK"))
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", exception);
}
}
else
{
ModelState.AddModelError("", "Username không hợp lệphải có từ 6 kí tự và không dấu");
}
}
return(View(nhanVien));
}
public int ChangeStatus(int id)
{
var ycpv = db.YeuCauPhucVus.Find(id);
if (ycpv.Status == 2)
{
ycpv.Status = 1;
}
db.SaveChanges();
return(ycpv.Status.Value);
}
public JsonResult LapPhieu(List <int> listDC)
{
if (listDC == null)
{
return(Json(new
{
status = false,
mess = "Bạn chưa chọn dụng cụ"
}));
}
else
{
string name = HttpContext.User.Identity.Name;
var ktv = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
if (ktv == null)
{
return(Json(new
{
status = false,
mess = "Có lỗi xảy ra"
}));
}
PhieuXuatKho px = new PhieuXuatKho();
px.IDKTV = ktv.ID;
px.KiemDuyet = false;
px.NgayXuat = DateTime.Now;
px.Status = 0;
foreach (int value in listDC)
{
var vd = db.KhoVatDungs.Find(value);
if (vd == null || vd.Status == 2)
{
return(Json(new
{
status = false,
mess = "Có lỗi xảy ra"
}));
}
else
{
vd.Status = 2;
}
CTPhieuXuatKho ct = new CTPhieuXuatKho();
ct.IDVatDung = value;
px.CTPhieuXuatKhoes.Add(ct);
}
db.PhieuXuatKhoes.Add(px);
db.SaveChanges();
return(Json(new
{
status = true
}));
}
}
public int ThemBBNT(int idyc)
{
BienBanNghiemThu bbnt = new BienBanNghiemThu();
bbnt.IDYC = idyc;
bbnt.NgayLap = DateTime.Now.Date;
bbnt.Status = true;
bbnt.DoanhThu = 0;
bbnt.Diem = 0;
db.BienBanNghiemThus.Add(bbnt);
db.SaveChanges();
return(bbnt.ID);
}
public ActionResult Create(MayLanh mayLanh)
{
if (ModelState.IsValid)
{
if (checkMa(mayLanh.Ma) == false)
{
ModelState.AddModelError("Ma", "Mã đã tồn tại");
}
else
{
mayLanh.IDKhachHang = 1;
TestObject test = new TestObject();
string ngaymua;
if (mayLanh.NgayMua.HasValue)
{
ngaymua = mayLanh.NgayMua.Value.ToString("dd/mm/yyyy");
}
else
{
ngaymua = null;
}
string exception = test.TestMayChoThues(mayLanh.TenMay);
if (exception == "OK")
{
mayLanh.Ma = mayLanh.Ma.ToUpper();
db.MayLanhs.Add(mayLanh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", exception);
}
}
}
return(View(mayLanh));
}
public JsonResult LapPhieuXuat(int idycpv, string ghichu, List <CTPhieuXuatVatTu_KTV> listCT)
{
string name = HttpContext.User.Identity.Name;
var ktv = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
if (ktv == null)
{
return(Json(new
{
status = false,
mess = "Có lỗi xảy ra"
}));
}
PhieuXuatVatTu_KTV px = new PhieuXuatVatTu_KTV();
px.GhiChu = ghichu;
px.IDKTV = ktv.ID;
px.IDYeuCauPV = idycpv;
px.KiemDuyet = false;
px.Status = 1;
px.NgayXuat = DateTime.Now;
foreach (CTPhieuXuatVatTu_KTV value in listCT)
{
VatTu vt = db.VatTus.SingleOrDefault(x => x.ID == value.IDVatTu);
if (vt.SoLuong >= value.SLLay)
{
vt.SoLuong = vt.SoLuong - value.SLLay;
}
else
{
return(Json(new
{
status = false,
mess = "Số lượng tồn kho chỉ còn: " + vt.SoLuong
}));
}
value.DonGia = Double.Parse(value.DonGiaJSON.ToString(), CultureInfo.InvariantCulture);
px.CTPhieuXuatVatTu_KTV.Add(value);
}
db.PhieuXuatVatTu_KTV.Add(px);
db.SaveChanges();
return(Json(new {
status = true,
}));
}
public ActionResult ChangePass(string oldPass, string NewPass1, string NewPass2)
{
if (!String.IsNullOrEmpty(oldPass) && !String.IsNullOrEmpty(NewPass1) && !String.IsNullOrEmpty(NewPass2))
{
string name = HttpContext.User.Identity.Name;
var rs = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
if (NewPass1.Length < 5)
{
ViewBag.Error = "Mật khẩu có độ dài từ 5 kí tự";
}
else if (rs != null)
{
LoginModel model = new LoginModel();
if (rs.Password.Equals(model.CreateMD5(model.Base64Encode(oldPass))))
{
if (NewPass1.Equals(NewPass2))
{
rs.Password = model.CreateMD5(model.Base64Encode(NewPass1));
db.SaveChanges();
TempData["msg"] = "<script>alert('Thành công');</script>";
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Error = "Mật khẩu mới không khớp!";
}
}
else
{
ViewBag.Error = "Mật khẩu cũ không đúng";
}
}
else
{
ViewBag.Error = "Có lỗi xảy ra";
}
}
else
{
ViewBag.Error = "Vui lòng nhập đủ thông tin";
}
return(RedirectToAction("ChangePassWord", "Home", new { ViewBag.Error }));
}
public ActionResult Create(KhoVatDung khoVatDung)
{
if (ModelState.IsValid)
{
khoVatDung.Status = 1;
db.KhoVatDungs.Add(khoVatDung);
string ngaymua;
if (khoVatDung.NgayMua.HasValue)
{
ngaymua = khoVatDung.NgayMua.Value.ToString("dd/mm/yyyy");
}
else
{
ngaymua = null;
}
TestObject test = new TestObject();
string exception = test.TestKho(khoVatDung.TenVatDung, ngaymua);
if (exception == "OK")
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", exception);
}
}
return(View(khoVatDung));
}
// Loai 1: Sua chua/ vsml Loai 3: Lap may Loai 2: Thue
public ActionResult Index()
{
string name = HttpContext.User.Identity.Name;
var ktv = db.NhanViens.SingleOrDefault(x => x.Username.Equals(name) && x.Status == 1);
if (ktv.Loai != 0)
{
setViewBagQL();
}
IQueryable <YeuCauPhucVu> p = db.YeuCauPhucVus;
List <YeuCauPhucVu> listPV = new List <YeuCauPhucVu>();
//if (!string.IsNullOrEmpty(searchStringPV))
//{
// ViewBag.searchPV = searchStringPV;
// p = p.Where(x => (x.KhachHang.HoTen.Contains(searchStringPV) || x.KhachHang.SDT.Contains(searchStringPV)) && (x.Loai == 1 || x.Loai == 3) && x.Status != 3 && x.Status != 4);
// listPV = p.ToList();
//}
listPV = db.YeuCauPhucVus.Where(x => (x.Loai == 1 || x.Loai == 3) && x.Status != 3 && x.Status != 4).ToList();
for (int i = 0; i < listPV.Count; i++)
{
if (listPV[i].NgayLamTiep.HasValue)
{
if (listPV[i].NgayLamTiep <= DateTime.Now.Date && listPV[i].Status != 1)
{
listPV[i].Status = 2;
var rs = db.YeuCauPhucVus.Find(listPV[i].ID);
rs.Status = 2;
db.SaveChanges();
}
else if (listPV[i].NgayLamTiep > DateTime.Now.Date)
{
listPV[i].Status = 0;
var rs = db.YeuCauPhucVus.Find(listPV[i].ID);
rs.Status = 0;
db.SaveChanges();
}
}
else
{
if (listPV[i].NgayBatDau <= DateTime.Now.Date && listPV[i].Status == 0)
{
listPV[i].Status = 2;
var rs = db.YeuCauPhucVus.Find(listPV[i].ID);
rs.Status = 2;
db.SaveChanges();
}
else if (listPV[i].NgayBatDau > DateTime.Now.Date)
{
listPV[i].Status = 0;
var rs = db.YeuCauPhucVus.Find(listPV[i].ID);
rs.Status = 0;
db.SaveChanges();
}
}
}
List <YeuCauPhucVu> listCT = new List <YeuCauPhucVu>();
//if (!string.IsNullOrEmpty(searchStringCT))
//{
// ViewBag.searchCT = searchStringCT;
// p = p.Where(x => (x.KhachHang.HoTen.Contains(searchStringCT) || x.KhachHang.SDT.Contains(searchStringCT)) && x.Loai == 2 && x.Status != 3 && x.Status != 4);
// listCT = p.ToList();
//}
//else
listCT = db.YeuCauPhucVus.Where(x => x.Loai == 2 && x.Status != 3 && x.Status != 4).ToList();
for (int i = 0; i < listCT.Count; i++)
{
if (listCT[i].NgayDuKienTra.HasValue)
{
if (listCT[i].NgayDuKienTra <= DateTime.Now.Date && listCT[i].Status != 1)
{
listCT[i].Status = 2;
var rs = db.YeuCauPhucVus.Find(listCT[i].ID);
rs.Status = 2;
db.SaveChanges();
}
else if (listCT[i].NgayDuKienTra > DateTime.Now.Date)
{
listCT[i].Status = 0;
var rs = db.YeuCauPhucVus.Find(listCT[i].ID);
rs.Status = 0;
db.SaveChanges();
}
}
else
{
if (listCT[i].NgayBatDau <= DateTime.Now.Date && listCT[i].Status == 0)
{
listCT[i].Status = 2;
var rs = db.YeuCauPhucVus.Find(listCT[i].ID);
rs.Status = 2;
db.SaveChanges();
}
else if (listCT[i].NgayBatDau > DateTime.Now.Date)
{
listCT[i].Status = 0;
var rs = db.YeuCauPhucVus.Find(listCT[i].ID);
rs.Status = 0;
db.SaveChanges();
}
}
}
ViewBag.YCCT = listCT.OrderByDescending(x => x.Status);
var model = listPV.OrderByDescending(x => x.Status);
return(View(model));
}
