void Reset()
{
dateNgayNhap.EditValue = DateTime.Now;
txtHangNhap.Text = "";
spinSoTien.EditValue = 0;
objNK = new NHAPKHO();
objNK.UserID = Properties.Settings.Default.MaNV;
}
public ActionResult DeleteConfirmed(int id)
{
NHAPKHO nHAPKHO = db.NHAPKHOes.Find(id);
db.NHAPKHOes.Remove(nHAPKHO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public BOChiTietNhapKho()
{
ChiTietNhapKho = new CHITIETNHAPKHO();
ChiTietNhapKho.NgaySanXuat = ChiTietNhapKho.NgayHetHan = DateTime.Now;
ChiTietNhapKho.SoLuongNhap = 1;
MenuMon = new MENUMON();
LoaiBan = new LOAIBAN();
NhapKho = new NHAPKHO();
}
public ActionResult Edit([Bind(Include = "MANHAPKHO,NGAYNHAPKHO,ID_MAHANGHOA,ID_MANHACUNGCAP,SOLUONG,DONGIA,THANHTIEN")] NHAPKHO nHAPKHO)
{
if (ModelState.IsValid)
{
db.Entry(nHAPKHO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_MAHANGHOA = new SelectList(db.HANGHOAs, "MAHANGHOA", "TENHANGHOA", nHAPKHO.ID_MAHANGHOA);
ViewBag.ID_MANHACUNGCAP = new SelectList(db.NHACUNGCAPs, "MANHACUNGCAP", "TENNHACUNGCAP", nHAPKHO.ID_MANHACUNGCAP);
return(View(nHAPKHO));
}
// GET: NHAPKHOes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NHAPKHO nHAPKHO = db.NHAPKHOes.Find(id);
if (nHAPKHO == null)
{
return(HttpNotFound());
}
return(View(nHAPKHO));
}
// GET: NHAPKHOes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NHAPKHO nHAPKHO = db.NHAPKHOes.Find(id);
if (nHAPKHO == null)
{
return(HttpNotFound());
}
ViewBag.ID_MAHANGHOA = new SelectList(db.HANGHOAs, "MAHANGHOA", "TENHANGHOA", nHAPKHO.ID_MAHANGHOA);
ViewBag.ID_MANHACUNGCAP = new SelectList(db.NHACUNGCAPs, "MANHACUNGCAP", "TENNHACUNGCAP", nHAPKHO.ID_MANHACUNGCAP);
return(View(nHAPKHO));
}
public static List <NHAPKHO> getDSNK()
{
List <NHAPKHO> ds = new List <NHAPKHO>();
ConnectionDB cn = new ConnectionDB();
SqlDataAdapter da = cn.getDa("select * from phieunhap_kho");
DataTable dt = new DataTable();
da.Fill(dt);
cn.close();
foreach (DataRow dr in dt.Rows)
{
NHAPKHO nk = new NHAPKHO(dr["mapn"].ToString().Trim(), dr["mancc"].ToString().Trim(), DateTime.Parse(dr["ngaylap"].ToString().Trim()).ToString("dd/MM/yyyy"), dr["manv"].ToString().Trim(), dr["ghichu"].ToString().Trim());
ds.Add(nk);
}
return(ds);
}
public bool Insert(NHAPKHO nk)
{
try
{
_cn.Open();
string SQL = "INSERT INTO NHAPKHO VALUES ('" + nk.MASP + "',N'" + nk.TENSP + "',N'" + nk.SOLUONGNHAP + "', '" + nk.TIENNHAP + "','" + nk.TONGTIEN + "')";
SqlCommand cmd = new SqlCommand(SQL, _cn);
cmd.ExecuteNonQuery();
_cn.Close();
return(true);
}
catch
{
return(false);
}
}
private void frmLogin_Load(object sender, EventArgs e)
{
try
{
if (ID == null)
{
dateNgayNhap.EditValue = DateTime.Now;
objNK = new NHAPKHO();
objNK.UserID = Properties.Settings.Default.MaNV;
}
else
{
objNK = db.NHAPKHOs.SingleOrDefault(p => p.ID == ID);
dateNgayNhap.EditValue = objNK.NgayNhap.GetValueOrDefault();
txtHangNhap.Text = objNK.Name;
spinSoTien.EditValue = objNK.TienNhap.GetValueOrDefault();
}
}
catch { }
}
public bool Update(NHAPKHO nk)
{
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from NHAPKHO", _cn);
DataRow r = dt.Rows.Find(nk.MASP.ToString());
if (r != null)
{
r["TENSP"] = nk.TENSP;
r["SOLUONGNHAP"] = nk.SOLUONGNHAP;
r["TIENNHAP"] = nk.TIENNHAP;
r["TONGTIEN"] = nk.TONGTIEN;
}
SqlCommandBuilder cm = new SqlCommandBuilder(da);
da.Update(dt);
return(true);
}
catch
{
return(false);
}
}
public bool Update(NHAPKHO nk)
{
return(NK.Update(nk));
}
public bool Insert(NHAPKHO nk)
{
return(NK.Insert(nk));
}
public static void ThemNK(List <NHAPKHO> dsNK, String mapn, String mancc, String ngaylap, String manv, String ghichu)
{
NHAPKHO nk = new NHAPKHO(mapn, mancc, ngaylap, manv, ghichu);
dsNK.Add(nk);
}
