public IActionResult Register(tb_WMS_KhachHang khachHang) { bool Status = false; string message = ""; // Model validation if (ModelState.IsValid) { #region Email is already exist var isexist = IsEmailExist(khachHang.Email); if (isexist) { ModelState.AddModelError("EmailExist", "Email đã được đăng kí."); return(View()); } #endregion #region Generate Activation code khachHang.ActivationCode = Guid.NewGuid(); #endregion #region Password hashing khachHang.IsEmailVerified = false; #endregion #region Save data to database var idend = (from u in _context.tb_WMS_KhachHang orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); khachHang.ID = idend + 1; khachHang.MaKhachHang = "CC" + (idend + 1); _context.tb_WMS_KhachHang.Add(khachHang); _context.SaveChanges(); // send email to user SendVerificationLinkEmail(khachHang.Email, khachHang.ActivationCode.ToString()); message = "Đăng ký tài khoản thành công. Liên kết kích hoạt tài khoản " + " đã được gửi đến email: " + khachHang.Email; Status = true; #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View("Views/KhachHang/Message.cshtml")); }
public JsonResult Add_imei(int idphieu, int idkho, int idimei, int dg, tb_WMS_ChiTietPhieuXuat chitiet) { if (dg != 0 && idphieu != 0 && idkho != 0 && idimei != 0) { var phieu = (from N in _context.tb_WMS_PhieuXuat where N.ID == idphieu select N).FirstOrDefault(); phieu.SoLuong += 1; phieu.TongTien += dg; var idend = (from u in _context.tb_WMS_ChiTietPhieuXuat orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var imei = (from N in _context.tb_WMS_IMEI where N.ID == idimei select N).FirstOrDefault(); imei.IDXuat = idphieu; imei.GiaXuat = dg; imei.TrangThai = 1; chitiet.ID = idend + 1; chitiet.IDPBSP = imei.IDSPPB; chitiet.GiaBan = dg; chitiet.IDPhieuXuat = idphieu; chitiet.Imei = idimei; chitiet.TraHang = false; _context.tb_WMS_ChiTietPhieuXuat.Add(chitiet); _context.SaveChanges(); return(Json("hello")); } return(Json("")); }
public JsonResult Edit(string c, tb_WMS_PhieuNhap PhieuNhap, tb_WMS_ChiTietPhieuNhap ChiTiet, tb_WMS_IMEI Imeis) { if (c != "[]") { JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var idphieu = int.Parse(jsonObjects[0]["idphieu"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); var phieunhap = (from N in _context.tb_WMS_PhieuNhap where N.ID == idphieu select N).FirstOrDefault(); phieunhap.TongTien = tongtien; phieunhap.SoLuong = tongsoluong; phieunhap.GhiChu = ghichu; _context.Update(phieunhap); _context.SaveChanges(); var chitiet = (from N in _context.tb_WMS_ChiTietPhieuNhap where N.IDPN == idphieu select N).ToArray(); foreach (var item in chitiet) { _context.Remove(item); _context.SaveChanges(); } var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var idend_chitiet = (from u in _context.tb_WMS_ChiTietPhieuNhap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var dg = int.Parse(jsonObjects[h]["dongia"].ToString().Replace(",", "")); var ma = int.Parse(jsonObjects[h]["ma"].ToString()); var soluong = int.Parse(jsonObjects[h]["soluong"].ToString()); var thanhtien = int.Parse(jsonObjects[h]["thanhtien"].ToString().Replace(",", "")); var idpn = idphieu; var imeis = jsonObjects[h]["imei"].ToString(); ChiTiet.Imei = imeis; ChiTiet.IDPN = idpn; ChiTiet.IDPBSP = ma; ChiTiet.SoLuong = soluong; ChiTiet.ThanhTien = thanhtien; ChiTiet.DonGia = dg; ChiTiet.ID = idend_chitiet + 1; _context.tb_WMS_ChiTietPhieuNhap.Add(ChiTiet); _context.SaveChanges(); } return(Json(idphieu)); } else { return(Json("")); } }
public async Task <IActionResult> ThanhToan(string makh) { var dh = await _context.tb_WMS_DonHang.Where(s => s.MaKH == makh && s.ThanhToan == false).ToListAsync(); foreach (var i in dh) { i.ThanhToan = true; _context.SaveChanges(); } return(RedirectToAction("TongDonHang")); }
public JsonResult DoiDangNhap(string username, string pass, int user) { var dangnhap = (from N in _context.tb_WMS_DangNhap where N.IDNV == user select N).FirstOrDefault(); dangnhap.username = username; dangnhap.password = ConvertStringtoMD5(pass); _context.Update(dangnhap); _context.SaveChanges(); return(Json("ok")); }
public JsonResult DoiMatKhau(int idnv, string old_pass, string new_pass) { var pass_old = WareHouseSystem.Controllers.NhanVienController.ConvertStringtoMD5(old_pass); var check = (from N in _context.tb_WMS_DangNhap where N.IDNV == idnv && N.password == pass_old select N).Count(); if (check > 0) { var dn = (from N in _context.tb_WMS_DangNhap where N.IDNV == idnv select N).FirstOrDefault(); var pass = WareHouseSystem.Controllers.NhanVienController.ConvertStringtoMD5(new_pass); dn.password = pass; _context.Update(dn); _context.SaveChanges(); return(Json("OK")); } else { return(Json("")); } }
public JsonResult save(string c, tb_WMS_ChiTietKhachTraHang ChiTiet) { if (c != "[]") { JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var idtra = int.Parse(jsonObjects[0]["idphieutra"].ToString()); var idxuat = int.Parse(jsonObjects[0]["idphieuxuat"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); var phieutra = (from N in _context.tb_WMS_KhachTraHang where N.ID == idtra select N).FirstOrDefault(); phieutra.SoLuong = tongsoluong; phieutra.Tien = tongtien; phieutra.GhiChu = ghichu; _context.tb_WMS_KhachTraHang.Update(phieutra); _context.SaveChanges(); var chitiet = (from N in _context.tb_WMS_ChiTietKhachTraHang where N.IDTraHang == idtra select N).ToList(); foreach (var a in chitiet) { var imei = a.Imei; var ctiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat where N.Imei == imei && N.IDPhieuXuat == idxuat select N).FirstOrDefault(); ctiet_xuat.TraHang = false; _context.tb_WMS_ChiTietPhieuXuat.Update(ctiet_xuat); _context.SaveChanges(); } foreach (var i in chitiet) { _context.tb_WMS_ChiTietKhachTraHang.Remove(i); _context.SaveChanges(); } var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var idchitiet = int.Parse(jsonObjects[h]["idchitiet"].ToString()); var idend_chitiet = (from u in _context.tb_WMS_ChiTietKhachTraHang orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); if (idchitiet != 0) { var chitiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat where N.ID == idchitiet select N).FirstOrDefault(); chitiet_xuat.TraHang = true; _context.Update(chitiet_xuat); var imei = chitiet_xuat.Imei; var gia = chitiet_xuat.GiaBan; var idpbsp = chitiet_xuat.IDPBSP; ChiTiet.IDPBSP = idpbsp; ChiTiet.Imei = imei; ChiTiet.DonGia = gia; ChiTiet.IDTraHang = idtra; ChiTiet.ID = idend_chitiet + 1; _context.tb_WMS_ChiTietKhachTraHang.Add(ChiTiet); _context.SaveChanges(); } } return(Json("hello")); } else { return(Json("")); } }
public JsonResult Save(string c, tb_WMS_PhieuNhap phieuNhap, tb_WMS_ChiTietPhieuNhap ChiTiet) { if (c != "[]") { var idend = (from u in _context.tb_WMS_PhieuNhap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var nhanvien = int.Parse(@User.FindFirst("IdNV").Value); JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var kho = int.Parse(jsonObjects[0]["kho"].ToString()); var nhacungcap = int.Parse(jsonObjects[0]["nhacungcap"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); phieuNhap.IDKho = kho; phieuNhap.IDNCC = nhacungcap; phieuNhap.SoLuong = tongsoluong; phieuNhap.TongTien = tongtien; DateTime date = DateTime.Now; phieuNhap.NgayLap = date; phieuNhap.MaPhieuNhap = "CE" + (idend + 1); phieuNhap.ID = idend + 1; phieuNhap.TrangThai = 0; phieuNhap.IDNV = nhanvien; phieuNhap.GhiChu = ghichu; _context.tb_WMS_PhieuNhap.Add(phieuNhap); _context.SaveChanges(); var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var idend_chitiet = (from u in _context.tb_WMS_ChiTietPhieuNhap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var dg = int.Parse(jsonObjects[h]["dongia"].ToString().Replace(",", "")); var ma = int.Parse(jsonObjects[h]["ma"].ToString()); var soluong = int.Parse(jsonObjects[h]["soluong"].ToString()); var thanhtien = int.Parse(jsonObjects[h]["thanhtien"].ToString().Replace(",", "")); var idpn = idend + 1; var imeis = jsonObjects[h]["imei"].ToString(); ChiTiet.Imei = imeis; ChiTiet.IDPN = idpn; ChiTiet.IDPBSP = ma; ChiTiet.SoLuong = soluong; ChiTiet.ThanhTien = thanhtien; ChiTiet.DonGia = dg; ChiTiet.ID = idend_chitiet + 1; _context.tb_WMS_ChiTietPhieuNhap.Add(ChiTiet); _context.SaveChanges(); } return(Json(idend + 1)); } else { return(Json("")); } }
public JsonResult Save(string c, tb_WMS_PhieuXuat phieuXuat, tb_WMS_ChiTietPhieuXuat ChiTiet, tb_WMS_IMEI Imeis) { if (c != "[]") { var idend = (from u in _context.tb_WMS_PhieuXuat orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var idnv = int.Parse(@User.FindFirst("IdNV").Value); JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var kho = int.Parse(jsonObjects[0]["kho"].ToString()); var khach = int.Parse(jsonObjects[0]["khach"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); phieuXuat.IDKho = kho; phieuXuat.IDKhach = khach; phieuXuat.SoLuong = tongsoluong; phieuXuat.TongTien = tongtien; DateTime date = DateTime.Now; phieuXuat.NgayLap = date; phieuXuat.MaPhieuXuat = "EC" + (idend + 1); phieuXuat.ID = idend + 1; phieuXuat.TrangThai = 0; phieuXuat.IDNV = idnv; phieuXuat.GhiChu = ghichu; phieuXuat.TraHang = false; _context.tb_WMS_PhieuXuat.Add(phieuXuat); _context.SaveChanges(); var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var dg = int.Parse(jsonObjects[h]["dongia"].ToString().Replace(",", "")); var idpbsp = int.Parse(jsonObjects[h]["idpbsp"].ToString()); var idimei = int.Parse(jsonObjects[h]["idimei"].ToString()); var idpx = idend + 1; var idend_chitiet = (from u in _context.tb_WMS_ChiTietPhieuXuat orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); if (idimei != 0) { ChiTiet.Imei = idimei; ChiTiet.IDPhieuXuat = idpx; ChiTiet.IDPBSP = idpbsp; ChiTiet.GiaBan = dg; ChiTiet.ID = idend_chitiet + 1; ChiTiet.TraHang = false; _context.tb_WMS_ChiTietPhieuXuat.Add(ChiTiet); var imeiX = (from N in _context.tb_WMS_IMEI where N.ID == idimei select N).FirstOrDefault(); imeiX.IDXuat = idpx; imeiX.TrangThai = 1; imeiX.GiaXuat = dg; _context.Update(imeiX); _context.SaveChanges(); } } return(Json(idend + 1)); } else { return(Json("")); } }
public JsonResult Save(string c, tb_WMS_TraNhaCungCap TraNhaCungCap, tb_WMS_ChiTietTraNhaCungCap ChiTiet) { if (c != "[]") { var idend = (from u in _context.tb_WMS_TraNhaCungCap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var nhanvien = int.Parse(@User.FindFirst("IdNV").Value); JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var idnhap = int.Parse(jsonObjects[0]["idphieu"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); TraNhaCungCap.IDNhap = idnhap; TraNhaCungCap.SoLuong = tongsoluong; TraNhaCungCap.Tien = tongtien; DateTime date = DateTime.Now; TraNhaCungCap.NgayLap = date; TraNhaCungCap.MaTraHang = "SR" + (idend + 1); TraNhaCungCap.ID = idend + 1; TraNhaCungCap.TrangThai = 0; TraNhaCungCap.IDNhanVien = nhanvien; TraNhaCungCap.GhiChu = ghichu; _context.tb_WMS_TraNhaCungCap.Add(TraNhaCungCap); _context.SaveChanges(); var phieunhap = (from N in _context.tb_WMS_PhieuNhap where N.ID == idnhap select N).FirstOrDefault(); phieunhap.TraHang = true; _context.Update(phieunhap); var idtra = idend + 1; var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var idchitiet = int.Parse(jsonObjects[h]["chitiet"].ToString()); var imei = jsonObjects[h]["imei"].ToString(); var data_imei = (from N in _context.tb_WMS_IMEI where N.Imei == imei select N).FirstOrDefault(); var idpbsp = data_imei.IDSPPB; var gia = data_imei.GiaNhap; var idend_chitiet = (from u in _context.tb_WMS_ChiTietTraNhaCungCap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); ChiTiet.ID = idend_chitiet + 1; ChiTiet.IDTraHang = idtra; ChiTiet.IDPBSP = idpbsp; ChiTiet.Imei = imei; ChiTiet.DonGia = gia; _context.tb_WMS_ChiTietTraNhaCungCap.Add(ChiTiet); data_imei.TrangThai = 7; _context.tb_WMS_IMEI.Update(data_imei); _context.SaveChanges(); } return(Json(idend + 1)); } else { return(Json("")); } }
public JsonResult save(string c, tb_WMS_ChiTietTraNhaCungCap ChiTiet) { if (c != "[]") { JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var idtra = int.Parse(jsonObjects[0]["idphieutra"].ToString()); //var idnhap = int.Parse(jsonObjects[0]["idphieunhap"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); var phieutra = (from N in _context.tb_WMS_TraNhaCungCap where N.ID == idtra select N).FirstOrDefault(); phieutra.SoLuong = tongsoluong; phieutra.Tien = tongtien; phieutra.GhiChu = ghichu; _context.tb_WMS_TraNhaCungCap.Update(phieutra); _context.SaveChanges(); var chitiet_remove = (from N in _context.tb_WMS_ChiTietTraNhaCungCap where N.IDTraHang == idtra select N).ToList(); foreach (var item in chitiet_remove) { _context.tb_WMS_ChiTietTraNhaCungCap.Remove(item); _context.SaveChanges(); } var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var imei_tra = jsonObjects[h]["imei"].ToString(); var idend_chitiet = (from u in _context.tb_WMS_ChiTietTraNhaCungCap orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); if (imei_tra != "") { var tt_imei_tra = (from N in _context.tb_WMS_IMEI where N.Imei == imei_tra select N).FirstOrDefault(); var idpb = tt_imei_tra.IDSPPB; var dongia = tt_imei_tra.GiaNhap; ChiTiet.IDPBSP = idpb; ChiTiet.Imei = imei_tra; ChiTiet.DonGia = dongia; ChiTiet.IDTraHang = idtra; ChiTiet.ID = idend_chitiet + 1; _context.tb_WMS_ChiTietTraNhaCungCap.Add(ChiTiet); _context.SaveChanges(); } } return(Json("hello")); } else { return(Json("")); } }
public JsonResult Save(string c, tb_WMS_KhachTraHang KhachTraHang, tb_WMS_ChiTietKhachTraHang ChiTiet) { if (c != "[]") { var idend = (from u in _context.tb_WMS_KhachTraHang orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); var nhanvien = int.Parse(@User.FindFirst("IdNV").Value); JArray jsonArray = JArray.Parse(c); var jsonObjects = jsonArray.OfType <JObject>().ToList(); var idxuat = int.Parse(jsonObjects[0]["idphieu"].ToString()); var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", "")); var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString()); var ghichu = jsonObjects[0]["ghichu"].ToString(); KhachTraHang.IDXuat = idxuat; KhachTraHang.SoLuong = tongsoluong; KhachTraHang.Tien = tongtien; DateTime date = DateTime.Now; KhachTraHang.NgayLap = date; KhachTraHang.MaTraHang = "CR" + (idend + 1); KhachTraHang.ID = idend + 1; KhachTraHang.TrangThai = 0; KhachTraHang.IDNhanVien = nhanvien; KhachTraHang.GhiChu = ghichu; _context.tb_WMS_KhachTraHang.Add(KhachTraHang); _context.SaveChanges(); var phieuxuat = (from N in _context.tb_WMS_PhieuXuat where N.ID == idxuat select N).FirstOrDefault(); phieuxuat.TraHang = true; _context.Update(phieuxuat); var q = jsonObjects.Count(); for (var h = 0; h < q; h++) { var idchitiet = int.Parse(jsonObjects[h]["idchitiet"].ToString()); var idtrahang = idend + 1; var idend_chitiet = (from u in _context.tb_WMS_ChiTietKhachTraHang orderby u.ID descending select u.ID).Take(1).FirstOrDefault(); if (idchitiet != 0) { var chitiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat where N.ID == idchitiet select N).FirstOrDefault(); chitiet_xuat.TraHang = true; _context.Update(chitiet_xuat); var imei = chitiet_xuat.Imei; var gia = chitiet_xuat.GiaBan; var idpbsp = chitiet_xuat.IDPBSP; ChiTiet.IDPBSP = idpbsp; ChiTiet.Imei = imei; ChiTiet.DonGia = gia; ChiTiet.IDTraHang = idtrahang; ChiTiet.ID = idend_chitiet + 1; _context.tb_WMS_ChiTietKhachTraHang.Add(ChiTiet); _context.SaveChanges(); } } //var soluong_phieuxuat = phieuxuat.SoLuong; //if () { } return(Json(idend + 1)); } else { return(Json("")); } }