public ActionResult SuaSP(ThongTinSP sp, SanPham a)
{
test2Entities data = new test2Entities();
var result1 = data.SanPhams.Where(x => x.ID.Equals(sp.ID)).FirstOrDefault();
var Result2 = data.infoProducts.Where(x => x.idProduct == sp.ID);
foreach (var item in Result2)
{
data.infoProducts.Remove(item);
}
string[] TenQuocGia = sp.NationalName.Trim().Split(' ');
var ListNational = data.NATIONALs;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = sp.ID;
data.infoProducts.Add(info);
break;
}
}
}
result1.Ten = a.Ten;
result1.SoLuong = a.SoLuong;
data.SaveChanges();
return(RedirectToAction("SanPham"));
}
//[HttpPost]
//public ActionResult XoaSP(SanPham1 sp)
//{
// test2Entities data = new test2Entities();
// var result1 = data.SanPhams.Where(p => p.ID == sp.ID).FirstOrDefault();
// var result2 = data.infoProducts.Where(x => x.idProduct == sp.ID);
// if (result1 != null)
// {
// foreach(var item in result2)
// {
// data.infoProducts.Remove(item);
// }
// data.SanPhams.Remove(result1);
// data.SaveChanges();
// return RedirectToAction("SanPham");
// }
// else
// {
// ViewBag.a = "Sản Phẩm Này Không Tồn Tại";
// return View();
// }
//}
public ActionResult SuaSP(int id)
{
test2Entities data = new test2Entities();
var listInfoProduct = data.infoProducts;
int[] listIDNational = new int[100];
string nameOfNational = "";
int i = 0;
foreach (var item in listInfoProduct)
{
if (item.idProduct == id)
{
listIDNational[i] = (int)item.NationalID;
i++;
}
}
var listNational = data.NATIONALs;
for (i = 0; i < listIDNational.Length; i++)
{
foreach (var item in listNational)
{
if (listIDNational[i] == item.NationalID)
{
nameOfNational = nameOfNational + item.NationalName.Trim() + " ";
}
}
}
ViewBag.a = nameOfNational;
return(View(data.SanPhams.FirstOrDefault(m => m.ID.Equals(id))));
}
public ActionResult XoaSP(int id, SanPham1 sp)
{
test2Entities data = new test2Entities();
var result1 = data.SanPhams.Where(p => p.ID == sp.ID).FirstOrDefault();
var result2 = data.infoProducts.Where(x => x.idProduct == sp.ID);
var result3 = data.IMGs.Where(c => c.IDProduct == sp.ID);
if (result1 != null)
{
foreach (var item1 in result3)
{
data.IMGs.Remove(item1);
}
foreach (var item in result2)
{
data.infoProducts.Remove(item);
}
data.SanPhams.Remove(result1);
data.SaveChanges();
return(RedirectToAction("SanPham"));
}
return(View(data.SanPhams.FirstOrDefault(m => m.ID.Equals(id))));
}
public ActionResult ThemSanPham(ThongTinSP sp, SanPham b)
{
test2Entities data = new test2Entities();
SanPham a = new SanPham();
a.Ten = b.Ten;
a.SoLuong = sp.SoLuong;
data.SanPhams.Add(a);
string[] TenQuocGia = sp.NationalName.Trim().Split(' ');
var ListNational = from x in data.NATIONALs select x;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = a.ID;
data.infoProducts.Add(info);
break;
}
}
}
data.SaveChanges();
return(RedirectToAction("SanPham"));
}
public ActionResult SanPham()
{
test2Entities data = new test2Entities();
var d = from x in data.SanPhams select x;
return(View(d));
}
public JsonResult ThemHinhAnhJson(HttpPostedFileBase fileImg, int id, string name)
{
try
{
test2Entities data = new test2Entities();
string path = System.IO.Path.Combine(Server.MapPath("~/img/"), fileImg.FileName);
fileImg.SaveAs(path);
IMG img = new IMG();
img.IMGPath = "/Img/" + fileImg.FileName;
img.IDProduct = id;
img.title = name;
data.IMGs.Add(img);
data.SaveChanges();
return(Json(1));
}
catch (Exception ex)
{
return(Json(0));
}
}
public JsonResult ThemSPJson(string ten, int soluong, string nationalname, HttpPostedFileBase fileImg)
{
try
{
test2Entities data = new test2Entities();
SanPham a = new SanPham();
a.Ten = ten;
a.SoLuong = soluong;
data.SanPhams.Add(a);
string[] TenQuocGia = nationalname.Trim().Split(' ');
var ListNational = from x in data.NATIONALs select x;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = a.ID;
data.infoProducts.Add(info);
break;
}
}
}
string path = System.IO.Path.Combine(Server.MapPath("~/img/"), fileImg.FileName);
fileImg.SaveAs(path);
IMG img = new IMG();
img.IMGPath = "/Img/" + fileImg.FileName;
img.IDProduct = a.ID;
img.title = ten;
data.IMGs.Add(img);
data.SaveChanges();
return(Json(1));
}
catch (Exception ex)
{ return(Json(0)); }
}
public ActionResult Login(dangnhap login)
{
test2Entities data = new test2Entities();
// vinhpham
// Vinhpham
// VINHPHAM
//bool a = "vinh" == "Vinh";
// .equals so sanh tuong doi chi cho string dc su dung
var kq = data.logins.Where(x => x.userName.Equals(login.userName) && x.passWord == login.passWord).FirstOrDefault();
if (kq != null)
{
if (kq.chucnang == "admin" && kq.chucnang == "admin")
{
Session["login"] = kq;
return(RedirectToAction("Index"));
}
else if (kq.chucnang == "admin" && kq.chucnang == "member")
{
Session["login"] = kq;
return(RedirectToAction("About"));
}
else if (kq.chucnang == "admin" && kq.chucnang == "member")
{
Session["login"] = kq;
return(RedirectToAction("Contact"));
}
else if (kq.chucnang == "admin" && kq.chucnang == "member")
{
Session["login"] = kq;
return(RedirectToAction("SanPham"));
}
}
else
{
ViewBag.a = "sai ten tai khoan mat khau";
}
return(View());
}
public JsonResult SuaSanpham(int id, string Ten, int SoLuong, string NationalName, HttpPostedFileBase IMGSua)
{
try
{
test2Entities data = new test2Entities();
var result1 = data.SanPhams.Where(x => x.ID.Equals(id)).FirstOrDefault();
var Result2 = data.infoProducts.Where(x => x.idProduct == id);
foreach (var item in Result2)
{
data.infoProducts.Remove(item);
}
string[] TenQuocGia = NationalName.Trim().Split(' ');
var ListNational = data.NATIONALs;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = id;
data.infoProducts.Add(info);
break;
}
}
}
result1.Ten = Ten;
result1.SoLuong = SoLuong;
if (IMGSua != null)
{
var result = data.IMGs.Where(x => x.IDProduct == id).FirstOrDefault();
string imgPath = result.IMGPath.Trim();
imgPath = imgPath.Substring(5);
string path = System.IO.Path.Combine(Server.MapPath("~/Img/"), imgPath);
System.IO.File.Delete(path);
data.IMGs.Remove(result);
string path1 = System.IO.Path.Combine(Server.MapPath("~/Img/"), IMGSua.FileName);
IMGSua.SaveAs(path1);
IMG img = new IMG();
img.IMGPath = "/Img/" + IMGSua.FileName;
img.IDProduct = id;
img.title = Ten;
data.IMGs.Add(img);
}
data.SaveChanges();
return(Json("sửa thành công"));
}
catch (Exception ex)
{
return(Json(0));
}
}
