public ActionResult shop()
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
return(View(db.V_Products.ToList()));
}
public ActionResult Login(Login login)
{
if (String.IsNullOrEmpty(login.Email) || String.IsNullOrEmpty(login.Password))
{
ViewBag.error = "შეავსეთ ყველა ველი";
return(View());
}
MyDatabaseDataContext db = new MyDatabaseDataContext();
int count = db.V_users.Where(x => x.Email == login.Email && x.Password == MD5Hash(login.Password + authsecret)).Count();
if (count > 0)
{
string name = db.V_users.Where(x => x.Email == login.Email).Select(x => x.Name).FirstOrDefault();
int id = db.V_users.Where(x => x.Email == login.Email).Select(x => x.Id).FirstOrDefault();
Session["user"] = name;
Session["id"] = id;
return(RedirectToAction("/Loginsuccess"));
}
else
{
ViewBag.error = "ასეთი მომხამრებელი არ არსებობს";
return(View());
}
}
public ActionResult Confirmation(string id)
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
V_Unuser unuser = db.V_Unusers.Where(x => x.ConfCode == id).FirstOrDefault();
V_user user = new V_user()
{
Name = unuser.Name,
SurName = unuser.SurName,
CreateDate = DateTime.Now,
Password = unuser.Password,
Email = unuser.Email,
Secret = Random32(),
};
using (var transaction = new TransactionScope())
{
db.V_users.InsertOnSubmit(user);
db.SubmitChanges();
db.V_Unusers.DeleteAllOnSubmit(db.V_Unusers.Where(x => x.Email == unuser.Email).ToList());
db.SubmitChanges();
transaction.Complete();
}
return(RedirectToAction("Success"));
}
public ActionResult list()
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
return(View(db.V_Unusers.ToList()));
}
// Lấy danh sách Phiếu hàng
public static List <PHIEUHANG> LayBangPhieuHang()
{
List <PHIEUHANG> listPhieuHang = new List <PHIEUHANG>();
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var query = (from n in db.PHIEUHANGs
select n);
foreach (var n in query)
{
listPhieuHang.Add(new PHIEUHANG()
{
SOCHUNGTU = n.SOCHUNGTU,
MAHANG = n.MAHANG,
MAKHACHHANG = n.MAKHACHHANG,
MAKHO = n.MAKHO,
NGAY = n.NGAY,
SOLUONG = n.SOLUONG,
DIENGIAI = n.DIENGIAI,
LOAIPHIEU = n.LOAIPHIEU
});
}
}
return(listPhieuHang);
}
public ActionResult AddProduct(V_Product v, HttpPostedFileBase Product_image)
{
string path = HttpContext.Server.MapPath("/Content/Images/");
string ext = System.IO.Path.GetExtension(Product_image.FileName);
string name = Guid.NewGuid().ToString("N");
string imagesrc = "/Content/Images/" + name + ext;
Product_image.SaveAs(path + name + ext);
V_Product pr = new V_Product()
{
Product_name = v.Product_name,
Product_description = v.Product_description,
Price = v.Price,
User_Id = Convert.ToInt32(Session["id"]),
Product_image = imagesrc,
};
MyDatabaseDataContext db = new MyDatabaseDataContext();
db.V_Products.InsertOnSubmit(pr);
db.SubmitChanges();
return(View());
}
// Thêm phiếu hàng
public static void ThemPhieuHang(PHIEUHANG phieu)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.PHIEUHANGs.InsertOnSubmit(phieu);
db.SubmitChanges();
}
}
// Thêm phiếu xuất kho
public static void ThemPhieuXuatKho(PHIEUXUATKHO phieu)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.PHIEUXUATKHOs.InsertOnSubmit(phieu);
db.SubmitChanges();
}
}
// Thêm tồn đầu kỳ
public static void ThemTonDauKy(TONKY tonKy)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.TONKies.InsertOnSubmit(tonKy);
db.SubmitChanges();
}
}
// Xóa một tồn kỳ khỏi database
public static void XoaKy(tonDauKy tonKy)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
TONKY tonKyDB = (from n in db.TONKies
where n.MAKY == tonKy.MaKy
select n).FirstOrDefault();
db.TONKies.DeleteOnSubmit(tonKyDB);
db.SubmitChanges();
}
}
public ActionResult Recovery(string id)
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
int userid = db.V_users.Where(x => x.Secret == id).Select(x => x.Id).FirstOrDefault();
Session["userid"] = userid;
return(View());
}
// Sửa thông tin số lượng sản phẩm
public static void SuaSoLuongSanPham(string MaHang, int soLuong)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
HANGHOA hangDB = (from n in db.HANGHOAs
where n.MAHANG == MaHang
select n).FirstOrDefault();
hangDB.SOLUONG = hangDB.SOLUONG + soLuong;
db.SubmitChanges();
}
}
// Xóa một kho khỏi database
public static void XoaKho(Kho kho)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHO khoDB = (from n in db.KHOs
where n.MAKHO == kho.MaKho
select n).FirstOrDefault();
db.KHOs.DeleteOnSubmit(khoDB);
db.SubmitChanges();
}
}
// Thêm kho
public static void ThemKho(Kho kho)
{
KHO KhoDB = new KHO();
KhoDB.MAKHO = kho.MaKho;
KhoDB.TENKHO = kho.TenKho;
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.KHOs.InsertOnSubmit(KhoDB);
db.SubmitChanges();
}
}
// Xóa một khách hàng khỏi database
public static void XoaKhachHang(KhachHang khachHang)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHACHHANG khachHangDB = (from n in db.KHACHHANGs
where n.MAKHACHHANG == khachHang.MaKhachHang
select n).FirstOrDefault();
XoaKhachHangKhoiPHIEUHANG(khachHang.MaKhachHang);
db.KHACHHANGs.DeleteOnSubmit(khachHangDB);
db.SubmitChanges();
}
}
// Sửa thông tin kỳ
public static void CapNhatKy(tonDauKy tonKy)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
TONKY tonKyDB = (from n in db.TONKies
where n.MAKY == tonKy.MaKy
select n).FirstOrDefault();
tonKyDB.TENKY = tonKy.TenKy;
tonKyDB.NGAYBATDAU = tonKy.NgayBatDau;
tonKyDB.NGAYKETTHUC = tonKy.NgayKetThuc;
db.SubmitChanges();
}
}
// Sửa thông tin kho
public static void CapNhatKho(Kho kho)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHO khoDB = (from n in db.KHOs
where n.MAKHO == kho.MaKho
select n).FirstOrDefault();
khoDB.MAKHO = kho.MaKho;
khoDB.TENKHO = kho.TenKho;
db.SubmitChanges();
}
}
// Xóa một hàng hóa khỏi database
public static void XoaHangHoa(HangHoa hangHoa)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
HANGHOA hangHoaDB = (from n in db.HANGHOAs
where n.MAHANG == hangHoa.MaHang
select n).FirstOrDefault();
XoaMaHangKhoiPHIEUHANG(hangHoa.MaHang);
XoaMaHangKhoiPHIEUXUATKHO(hangHoa.MaHang);
db.HANGHOAs.DeleteOnSubmit(hangHoaDB);
db.SubmitChanges();
}
}
// Sửa thông tin hàng hóa
public static void CapNhatHangHoa(HangHoa hang)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
HANGHOA hangHoaDB = (from n in db.HANGHOAs
where n.MAHANG == hang.MaHang
select n).FirstOrDefault();
hangHoaDB.TENHANG = hang.TenHang;
hangHoaDB.GIA = hang.Gia;
hangHoaDB.NGAYNHAP = hang.NgayNhap;
hangHoaDB.SOLUONG = hang.SoLuong;
db.SubmitChanges();
}
}
// Xóa một phiếu nhập hoặc xuất hàng khỏi PHIEUHANG
public static void XoaPhieuHang(string SoCT)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var PhieuHang = (from n in db.PHIEUHANGs
where n.SOCHUNGTU == SoCT
select n);
foreach (var n in PhieuHang)
{
db.PHIEUHANGs.DeleteOnSubmit(n);
db.SubmitChanges();
}
}
}
// Thêm hàng hóa
public static void ThemHangHoa(HangHoa hangHoa)
{
HANGHOA hangHoaDB = new HANGHOA();
hangHoaDB.MAHANG = hangHoa.MaHang;
hangHoaDB.TENHANG = hangHoa.TenHang;
hangHoaDB.GIA = hangHoa.Gia; hangHoaDB.NGAYNHAP = hangHoa.NgayNhap;
hangHoaDB.SOLUONG = hangHoa.SoLuong;
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.HANGHOAs.InsertOnSubmit(hangHoaDB);
db.SubmitChanges();
}
}
// Xóa 1 Mã hàng khỏi danh sách PHIEUXUATKHO
public static void XoaMaHangKhoiPHIEUXUATKHO(string MaHang)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var PhieuXuatKho = (from n in db.PHIEUXUATKHOs
where n.MAHANG == MaHang
select n);
foreach (var n in PhieuXuatKho)
{
db.PHIEUXUATKHOs.DeleteOnSubmit(n);
db.SubmitChanges();
}
}
}
// Thêm khách hàng
public static void ThemKhachHang(KhachHang khachHang)
{
KHACHHANG khachHangDB = new KHACHHANG();
khachHangDB.MAKHACHHANG = khachHang.MaKhachHang;
khachHangDB.TENKHACHHANG = khachHang.TenKhachHang;
khachHangDB.SODIENTHOAI = khachHang.SDT;
khachHangDB.DIACHI = khachHang.DiaChi;
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
db.KHACHHANGs.InsertOnSubmit(khachHangDB);
db.SubmitChanges();
}
}
// Xóa một mã khách hàng khỏi danh sách PHIEUHANG
public static void XoaKhachHangKhoiPHIEUHANG(string MaKhachHang)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var PhieuHang = (from n in db.PHIEUHANGs
where n.MAKHACHHANG == MaKhachHang
select n);
foreach (var n in PhieuHang)
{
db.PHIEUHANGs.DeleteOnSubmit(n);
db.SubmitChanges();
}
}
}
// Lấy danh sách tồn đầu kỳ
public static List <TONKY> LayTonDauKy()
{
List <TONKY> listTonKy = new List <TONKY>();
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var Query = (from n in db.TONKies
select n);
foreach (var n in Query)
{
listTonKy.Add(n);
}
}
return(listTonKy);
}
// Sửa thông tin khách hàng
public static void CapNhatKhachHang(KhachHang khachHang)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
KHACHHANG khachHangDB = (from n in db.KHACHHANGs
where n.MAKHACHHANG == khachHang.MaKhachHang
select n).FirstOrDefault();
khachHangDB.MAKHACHHANG = khachHang.MaKhachHang;
khachHangDB.TENKHACHHANG = khachHang.TenKhachHang;
khachHangDB.SODIENTHOAI = khachHang.SDT;
khachHangDB.DIACHI = khachHang.DiaChi;
db.SubmitChanges();
}
}
// Sửa thông tin phiếu hàng
public static void CapNhatPhieuHang(PhieuHang phieuHang, int loaiPhieu)
{
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
PHIEUHANG phieuHangDB = (from n in db.PHIEUHANGs
where n.SOCHUNGTU == phieuHang.SoCT
select n).FirstOrDefault();
phieuHangDB.SOCHUNGTU = phieuHang.SoCT;
phieuHangDB.NGAY = phieuHang.NgayNhap;
phieuHangDB.MAHANG = phieuHang.MaHang;
phieuHangDB.MAKHACHHANG = phieuHang.MaKH;
phieuHangDB.DIENGIAI = phieuHang.DienGiai;
phieuHangDB.LOAIPHIEU = (byte)loaiPhieu;
phieuHangDB.SOLUONG = phieuHang.SoLuong;
db.SubmitChanges();
}
}
public ActionResult forgot(Forgot f)
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
V_user us = db.V_users.Where(x => x.Email == f.Email).FirstOrDefault();
if (us == null)
{
ViewBag.error = "ასეთი მომხმარებელი არ არსებობს";
return(View());
}
string body = "http://localhost:51328/Account/Recovery/" + us.Secret;
SendMail(us.Email, "Recovery", body, false);
ViewBag.error = "მეილი წარმატებით გაიგზავნა";
return(View());
}
// Lấy danh sách kho chứa
public static List <KHO> LayBangKho()
{
List <KHO> listKho = new List <KHO>();
using (MyDatabaseDataContext db = new MyDatabaseDataContext())
{
var query = (from n in db.KHOs
select n);
foreach (var n in query)
{
listKho.Add(new KHO()
{
MAKHO = n.MAKHO,
TENKHO = n.TENKHO
});
}
}
return(listKho);
}
public ActionResult Register(Register users)
{
MyDatabaseDataContext db = new MyDatabaseDataContext();
int count = db.V_users.Where(x => x.Email == users.Email).Count();
if (String.IsNullOrEmpty(users.Name) || String.IsNullOrEmpty(users.Surname) || String.IsNullOrEmpty(users.Email) || String.IsNullOrEmpty(users.Password) || String.IsNullOrEmpty(users.ConfirmPassword))
{
ViewBag.error = "შეავსეთ ყველა ველი!";
return(View());
}
else if (users.ConfirmPassword != users.Password)
{
ViewBag.error = "პაროლები არ მთხვევა ერთმანეთს";
return(View());
}
else if (count > 0)
{
ViewBag.error = "მომხამრებელი ასეთი ელ.ფოსტით უკვე დარეგისტრირებულია";
return(View());
}
else
{
string confirmationcode = Random32();
V_Unuser unuser = new V_Unuser()
{
Name = users.Name,
SurName = users.Surname,
Email = users.Email,
Password = MD5Hash(users.Password + authsecret),
CreateDate = DateTime.Now,
ConfCode = confirmationcode,
};
db.V_Unusers.InsertOnSubmit(unuser);
db.SubmitChanges();
string body = "http://localhost:51328/Account/Confirmation/" + confirmationcode;
SendMail(users.Email, "Confirmation", body, false);
return(RedirectToAction("conf"));
}
}
