// xóa nhân viên
public void xoaPhieuNhap(string mapx)
{
PHIEUXUAT px = qlch.PHIEUXUATs.Where(d => d.MAPHIEUXUAT == mapx).FirstOrDefault();
qlch.PHIEUXUATs.DeleteOnSubmit(px);
qlch.SubmitChanges();
}
public static int add(PhieuXuat phieuxuat)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
var phieu = new PHIEUXUAT
{
masodaily = phieuxuat.MaSoDaiLy,
ngaylap = phieuxuat.NgayLap,
nguoinhasach = phieuxuat.NguoiNhan,
tongtien = phieuxuat.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia),
trangthai = 0
};
db.PHIEUXUATs.InsertOnSubmit(phieu);
db.SubmitChanges();
foreach (ChiTietPhieuXuat ct in phieuxuat.ChiTiet)
{
Chitiet.add(ct, phieu.masophieuxuat);
}
return(phieu.masophieuxuat);
}
}catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
private void gridPXuat_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
phieuxuat = phieuxuat_bll.getPX(int.Parse(gridPXuat.CurrentRow.Cells[0].Value.ToString()));
Load_CTPD(ctpx.get_CTPX(phieuxuat.ID_PX));
lblmapx.Text = phieuxuat.ID_PX.ToString();
lblngaylap.Text = phieuxuat.NGAYLAP.Value.Date.ToShortDateString();
lblnv.Text = phieuxuat.NGUOIDUNG.TEN;
}
public ActionResult DeleteConfirmed(string id)
{
PHIEUXUAT pHIEUXUAT = db.PHIEUXUATs.Find(id);
db.PHIEUXUATs.Remove(pHIEUXUAT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(string id)
{
PHIEUXUAT group_role = db.PHIEUXUATs.Find(id);
db.PHIEUXUATs.Remove(group_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Add(PHIEUXUAT model)
{
var PhieuXuat = db.PHIEUXUATs.Find(model.MaPhieuXuat);
db.PHIEUXUATs.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void set(PHIEUXUAT px)
{
label1.Text += " " + px.ID;
label2.Text += " " + px.NGAY.ToString("dd/MM/yyyy");
label3.Text += " " + px.CUAHANG.TENCH;
label4.Text += " " + px.PHANTRAMLOI;
label5.Text += " " + px.KHUYENMAI;
gridControl2.DataSource = BUS.QLXUAT_BUS.loadpx(px.ID);
}
public void suaPhieuXuat(string mapx, string makh, DateTime ngaylap)
{
PHIEUXUAT px = qlch.PHIEUXUATs.Where(d => d.MAPHIEUXUAT == mapx).FirstOrDefault();
px.MAPHIEUXUAT = mapx;
px.MAKHACHHANG = makh;
px.NGAYLAPPHIEU = ngaylap;
qlch.SubmitChanges();
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PHIEUXUAT phieuxuat = await db.PHIEUXUATs.FindAsync(id);
db.PHIEUXUATs.Remove(phieuxuat);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public PhieuXuat(PHIEUXUAT phieu)
{
MaSoPhieuXuat = phieu.masophieuxuat;
MaSoDaiLy = phieu.masodaily;
NgayLap = phieu.ngaylap;
NguoiNhan = phieu.nguoinhasach;
TongTien = phieu.tongtien;
TrangThai = phieu.trangthai;
}
public ActionResult Edit([Bind(Include = "MaPX,MaMH,Ngayxuat,Nhanvien")] PHIEUXUAT pHIEUXUAT)
{
if (ModelState.IsValid)
{
db.Entry(pHIEUXUAT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pHIEUXUAT));
}
public ActionResult Edit([Bind(Include = "ID,NGAYXUAT,IDTTPHIEUXUAT")] PHIEUXUAT group_role)
{
if (ModelState.IsValid)
{
db.Entry(group_role).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(group_role));
}
public void ThemPhieuXuat(string mapx, string makh, string manv, DateTime ngaylap)
{
PHIEUXUAT px = new PHIEUXUAT();
px.MAPHIEUXUAT = mapx;
px.MAKHACHHANG = makh;
px.MANV = manv;
px.NGAYLAPPHIEU = ngaylap;
qlch.PHIEUXUATs.InsertOnSubmit(px);
qlch.SubmitChanges();
}
public ActionResult Create([Bind(Include = "MaPX,MaMH,Ngayxuat,Nhanvien")] PHIEUXUAT pHIEUXUAT)
{
if (ModelState.IsValid)
{
db.PHIEUXUATs.Add(pHIEUXUAT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pHIEUXUAT));
}
public ActionResult Create([Bind(Include = "ID,NGAYXUAT,IDTTPHIEUXUAT")] PHIEUXUAT group_role)
{
if (ModelState.IsValid)
{
db.PHIEUXUATs.Add(group_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(group_role));
}
public void ThemPhieuXuat(string MaPX, string ngaylap, string MaNV, string MaKH, double tongtien)
{
PHIEUXUAT px = new PHIEUXUAT();
px.MAPX = MaPX;
px.NGAYXUAT = DateTime.Parse(ngaylap);
px.MANV = MaNV;
px.MAKH = MaKH;
px.TONGTIENPX = tongtien;
xm.PHIEUXUATs.InsertOnSubmit(px);
xm.SubmitChanges();
}
public ActionResult Delete(string ID)
{
var temp = new PHIEUXUAT {
MAPX = ID
};
db.PHIEUXUATs.Attach(temp);
db.PHIEUXUATs.Remove(temp);
db.SaveChanges();
Session.Remove("tab1");
return(RedirectToAction("Index1"));
}
public static int them(PHIEUXUAT px)
{
try
{
DAO.QLXUAT.them(px);
return(1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
// GET: PHIEUXUATs/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUXUAT pHIEUXUAT = db.PHIEUXUATs.Find(id);
if (pHIEUXUAT == null)
{
return(HttpNotFound());
}
return(View(pHIEUXUAT));
}
// GET: TTNhom_QLNS/group_role/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHIEUXUAT group_role = db.PHIEUXUATs.Find(id);
if (group_role == null)
{
return(HttpNotFound());
}
return(View(group_role));
}
public ActionResult Checkout()
{
string objmanv = "1211997";
string objtenpn = "Phiếu xuất hàng " + (string)(Session["ClientUserID"]);
DateTime objngaynhap = DateTime.Today;
string objmakh = (string)(Session["ClientUserID"]);
PHIEUXUAT temp = new PHIEUXUAT {
MAPX = FuncClass.genNextCode(), TENPX = objtenpn, MANV = objmanv, NGAYXUAT = objngaynhap, MAKH = objmakh
};
db.PHIEUXUATs.Add(temp);
db.SaveChanges();
return(View());
}
private void btnXoaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
PHIEUXUAT px = db.PHIEUXUATs.Where(n => n.id_phieuxuat == idPX).SingleOrDefault();
var delete = db.CT_PHIEUXUATs.Where(n => n.id_phieuxuat == idPX);
db.CT_PHIEUXUATs.DeleteAllOnSubmit(delete);
db.SubmitChanges();
db.PHIEUXUATs.DeleteOnSubmit(px);
db.SubmitChanges();
}
LoadXuatHang();
}
private void btnSuaHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
int idPX = (int)grvXuatHang.SelectedCells[0].OwningRow.Cells["IDDONHANG"].Value;
PHIEUXUAT px = db.PHIEUXUATs.Where(n => n.id_phieuxuat == idPX).SingleOrDefault();
px.TenKH = txtTenKH.Text;
px.SoDT = txtSoDT.Text;
px.DiaChiKH = txtDiaChi.Text;
px.ngayxuat = dtpNgayXuat.Value;
px.id_nhanvien = (int)cbbPX_NHANVIEN.SelectedValue;
db.SubmitChanges();
}
LoadXuatHang();
}
public ActionResult Insert()
{
string objmanv = Request.Form["manv"];
string objtenpn = Request.Form["tenpx"];
DateTime objngaynhap = DateTime.ParseExact(Request.Form["date"], "dd/MM/yyyy", CultureInfo.InvariantCulture);
string objmakh = Request.Form["makh"];
PHIEUXUAT temp = new PHIEUXUAT {
MAPX = FuncClass.genNextCode(), TENPX = objtenpn, MANV = objmanv, NGAYXUAT = objngaynhap, MAKH = objmakh
};
db.PHIEUXUATs.Add(temp);
db.SaveChanges();
Session.Remove("tab1");
return(RedirectToAction("Index1"));
}
//Phiếu Xuất Hàng
private void btnThemHD_Click(object sender, EventArgs e)
{
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
PHIEUXUAT px = new PHIEUXUAT();
px.ngayxuat = dtpNgayXuat.Value;
px.TenKH = txtTenKH.Text;
px.DiaChiKH = txtDiaChi.Text;
px.SoDT = txtSoDT.Text;
px.id_nhanvien = (int)cbbPX_NHANVIEN.SelectedValue;
db.PHIEUXUATs.InsertOnSubmit(px);
db.SubmitChanges();
MessageBox.Show("Thêm Thành Công ");
}
LoadXuatHang();
}
public bool insert_PhieuXuat(string idnv, string loaixuat, DateTime ngaynhap, int tongtien)
{
try
{
PHIEUXUAT insert = new PHIEUXUAT();
insert.ID_DN = idnv;
insert.NGAYLAP = ngaynhap;
insert.TONGTIEN = tongtien;
insert.LOAIXUAT = loaixuat;
quanLyKho.PHIEUXUATs.InsertOnSubmit(insert);
quanLyKho.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public ActionResult XuatSach(DAILY dl, FormCollection f)
{
PHIEUXUAT px = new PHIEUXUAT();
px.MaDL = int.Parse(f["MaDL"].ToString());
String[] temp = f["NgayXuat"].ToString().Split('-');
DateTime date = new DateTime(int.Parse(temp[2]), int.Parse(temp[1]), int.Parse(temp[0]));
px.NgayXuat = date;
px.TrangThai = false;
db.PHIEUXUATs.Add(px);
db.SaveChanges();
int?TongTien = 0;
foreach (CT_PhieuXuatViewModel ct in Session["DS_Sach"] as List <CT_PhieuXuatViewModel> )
{
CT_PHIEUXUAT ctpx = new CT_PHIEUXUAT();
ctpx.MaPX = px.MaPX;
ctpx.MaSach = ct.MaSach;
ctpx.SLXuat = ct.SLXuat;
ctpx.DonGia = ct.DonGia;
ctpx.ThanhTien = ctpx.SLXuat * ctpx.DonGia;
TongTien += ctpx.ThanhTien;
db.CT_PHIEUXUAT.Add(ctpx);
}
px.TongTien = TongTien;
db.SaveChanges();
CONGNO_DL congno = new CONGNO_DL();
congno.MaDL = dl.MaDL;
congno.ThoiGian = new DateTime(int.Parse(temp[2]), int.Parse(temp[1]), int.Parse(temp[0]));
congno.TienDaTra = 0;
congno.TienNo = px.TongTien;
db.CONGNO_DL.Add(congno);
db.SaveChanges();
Session.Clear();
return(RedirectToAction("Index"));
}
public static void them(PHIEUXUAT px)
{
db.PHIEUXUATs.Add(px);
db.SaveChanges();
}
public PhieuXuat(PHIEUXUAT phieu, DAILY daily)
: this(phieu)
{
Daily = new DaiLy(daily);
}
