public ActionResult CreatePN(string id, string id2, string id3 /*,string id4*/)
{
//string testid = db.Database.SqlQuery<string>("select PN_ID from PhieuNhapsp where PN_ID = '"+id4+"'").SingleOrDefault();
//if (testid != null)
//{
// ModelState.AddModelError("TrungPN", "Mã phiếu nhập bị trùng");
//}
//else
{
PHIEUNHAPSP pHIEUNHAPSP = new PHIEUNHAPSP();
if (ModelState.IsValid)
{
pHIEUNHAPSP.PN_ID = db.autottang("PHIEUNHAPSP", "PN_ID", db.PHIEUNHAPSPs.Count()).ToString();
//pHIEUNHAPSP.PN_ID = id4;
pHIEUNHAPSP.NCC_ID = id;
pHIEUNHAPSP.NV_ID = Session["NV_ID"].ToString();
pHIEUNHAPSP.PN_NGAY = DateTime.Now;
pHIEUNHAPSP.PN_GHICHU = id3;
//pHIEUNHAPSP.NV_ID = Session["NV_ID"].ToString();
db.PHIEUNHAPSPs.Add(pHIEUNHAPSP);
db.SaveChanges();
Session["PNSP"] = pHIEUNHAPSP.PN_ID;
ModelState.AddModelError("", "Phiếu nhập " + pHIEUNHAPSP.PN_ID + " Đã được tạo");
}
else
{
ModelState.AddModelError("", "Lỗi !");
}
}
return(View());
}
public ActionResult DeleteConfirmed(string id)
{
PHIEUNHAPSP pHIEUNHAPSP = db.PHIEUNHAPSPs.Find(id);
db.PHIEUNHAPSPs.Remove(pHIEUNHAPSP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PN_ID,NV_ID,NCC_ID,PN_NGAY,PN_GHICHU")] PHIEUNHAPSP pHIEUNHAPSP)
{
if (ModelState.IsValid)
{
pHIEUNHAPSP.NV_ID = Session["NV_ID"].ToString();
db.Entry(pHIEUNHAPSP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NCC_ID = new SelectList(db.NHACUNGCAPs, "NCC_ID", "NCC_TEN", pHIEUNHAPSP.NCC_ID);
ViewBag.NV_ID = new SelectList(db.NHANVIENs, "NV_ID", "NV_TEN", pHIEUNHAPSP.NV_ID);
return(View(pHIEUNHAPSP));
}
// GET: PHIEUNHAPSPs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUNHAPSP pHIEUNHAPSP = db.PHIEUNHAPSPs.Find(id);
if (pHIEUNHAPSP == null)
{
return(HttpNotFound());
}
return(View(pHIEUNHAPSP));
}
// GET: PHIEUNHAPSPs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUNHAPSP pHIEUNHAPSP = db.PHIEUNHAPSPs.Find(id);
if (pHIEUNHAPSP == null)
{
return(HttpNotFound());
}
ViewBag.NCC_ID = new SelectList(db.NHACUNGCAPs, "NCC_ID", "NCC_TEN", pHIEUNHAPSP.NCC_ID);
ViewBag.NV_ID = new SelectList(db.NHANVIENs, "NV_ID", "NV_TEN", pHIEUNHAPSP.NV_ID);
return(View(pHIEUNHAPSP));
}
public ActionResult Create([Bind(Include = "PN_ID,NV_ID,NCC_ID,PN_NGAY,PN_GHICHU")] PHIEUNHAPSP pHIEUNHAPSP)
{
string NCC_ID = Request["NCC_ID"];
string PN_NGAY = Request["PN_NGAY"];
string PN_GHICHU = Request["PN_GHICHU"];
if (ModelState.IsValid)
{
pHIEUNHAPSP.NV_ID = Session["NV_ID"].ToString();
pHIEUNHAPSP.PN_ID = db.autottang("PHIEUNHAPSP", "PN_ID", db.PHIEUNHAPSPs.Count()).ToString();
db.PHIEUNHAPSPs.Add(pHIEUNHAPSP);
db.SaveChanges();
Session["PNSP"] = pHIEUNHAPSP.PN_ID;
return(RedirectToAction("Index"));
}
ViewBag.NCC_ID = new SelectList(db.NHACUNGCAPs, "NCC_ID", "NCC_TEN", pHIEUNHAPSP.NCC_ID);
ViewBag.NV_ID = new SelectList(db.NHANVIENs, "NV_ID", "NV_TEN", pHIEUNHAPSP.NV_ID);
return(View(pHIEUNHAPSP));
}
