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