public ActionResult InsertPhieuNhap(List <Phieu_Nhap_Json> json)
{
ManagerLogin managerLogin = new ManagerLogin();
//them moi phieu nhap
decimal tong_tien = 0;
Phieu_Nhap pn = new Phieu_Nhap();
pn.Ngay_Nhap = DateTime.Now;
pn.Tong_Tien = 0;
pn.UserId = ManagerLogin.GetId(User.Identity.Name);
db.Phieu_Nhap.Add(pn);
db.SaveChanges();
//int maPhieu = db.sp_Ma_Phieu_Gan_Nhat().FirstOrDefault().Phieu_Nhap_Id;
//int maPhieu = Convert.ToInt32(db.sp_Ma_Phieu_Gan_Nhat().FirstOrDefault().Value);
ManagerPhieuNhap manager = new ManagerPhieuNhap();
foreach (var item in json)
{
manager.ThemPhieuNhapHH(pn.Phieu_Nhap_Id, item);
tong_tien += item.Don_gia * item.So_Luong;
}
//db.sp_UpdateTongTien(pn.Phieu_Nhap_Id, tong_tien);
pn.Tong_Tien = tong_tien;
db.Entry(pn).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { Ok = true, newurl = Url.Action("InPhieuNhap", new { id = pn.Phieu_Nhap_Id }) }));
}
public ActionResult InsertPhieuXuat(List <Phieu_Nhap_Json> json)
{
ManagerLogin managerLogin = new ManagerLogin();
decimal tongTien = 0;
var phieuXuat = new Phieu_Xuat();
phieuXuat.Ngay_Xuat = DateTime.Now;
phieuXuat.Tong_Tien = 0;
phieuXuat.UserId = ManagerLogin.GetId(User.Identity.Name);
db.Phieu_Xuat.Add(phieuXuat);
db.SaveChanges();
var manager = new ManagerPhieuXuat();
foreach (var item in json)
{
tongTien += item.So_Luong * item.Don_gia;
manager.ThemPhieuXuatHH(phieuXuat.Phieu_Xuat_Id, item);
}
//cap nhat tong tien
phieuXuat.Tong_Tien = tongTien;
db.Entry(phieuXuat).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { ok = true, newurl = Url.Action("InPhieuXuat", "Phieu_Xuat_Kho_Chua", new { id = phieuXuat.Phieu_Xuat_Id }) }));
}
public ActionResult LoginUser(Table_User _userName)
{
if (ModelState.IsValid)
{
if (manager.IsUserName(_userName.UserName))
{
var pass = manager.GetPassword(_userName.UserName);
if (_userName.UserPassword == pass)
{
FormsAuthentication.SetAuthCookie(_userName.UserName, false);
int idUser = ManagerLogin.GetId(_userName.UserName);
using (var db = new QuanLyKhoEntities())
{
Session["name"] = db.UserProfiles.Find(idUser).Name;
}
return(RedirectToAction("Index", "Kho_Chua"));
}
else
{
ModelState.AddModelError("ErrDN", "Mật khẩu chưa đúng");
}
}
else
{
ModelState.AddModelError("ErrDN", "Không tồn tại tài khoản này");
}
}
return(View("LoginUser", _userName));
}
public ActionResult ProfileUser()
{
int id = ManagerLogin.GetId(User.Identity.Name);
UserProfile profile = manager.GetUserProfile(id);
if (profile == null)
{
return(HttpNotFound());
}
return(View(profile));
}
public ActionResult ChanUser(string UserName, int Role)
{
int id = ManagerLogin.GetId(UserName);
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
var tk = db.Table_User.Find(id);
if (tk.IsActive == true)
{
tk.IsActive = false;
}
else if (tk.IsActive == false)
{
tk.IsActive = true;
}
db.Entry(tk).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ListUser"));
}
}
