//Add CTPDX
public bool addCTPDX(string masp, string soluong, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
int dem = int.Parse(ctdx.SOLUONG.ToString()) + int.Parse(soluong);
ctdx.SOLUONG = dem;
db.SaveChanges();
return(true);
}
catch
{
CTPHIEUDEXUAT ctdx = new CTPHIEUDEXUAT();
ctdx.SOPHIEU = pdx.SOPHIEUDX;
ctdx.MASP = masp;
ctdx.SOLUONG = int.Parse(soluong);
db.CTPHIEUDEXUATs.Add(ctdx);
db.SaveChanges();
return(true);
}
}
catch {
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
PHIEUDEXUAT PDX = db.PHIEUDEXUATs.Find(lstDX.SelectedRows[0].Cells[0].Value);
GUI_CTDX ctdx = new GUI_CTDX(TK, PDX, "Edit");
this.Hide();
ctdx.ShowDialog();
this.Close();
}
private bool checkexitCTPDX(PHIEUDEXUAT pdx, string masp)
{
db = new CMART8Entities();
List <CTPHIEUDEXUAT> tmp = db.CTPHIEUDEXUATs.Where(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
//tao mới phiếu đề xuất
public PHIEUDEXUAT createPDX(string maTK)
{
db = new CMART8Entities();
PHIEUDEXUAT pdx = new PHIEUDEXUAT();
pdx.SOPHIEUDX = autoID();
pdx.NGAYDEXUAT = DateTime.Now;
pdx.MATK = maTK;
db.PHIEUDEXUATs.Add(pdx);
db.SaveChanges();
return(pdx);
}
public GUI_CTDX(TAIKHOAN tk, PHIEUDEXUAT pdx, string tmp)
{
TK = tk;
PDX = pdx;
tt = tmp;
ctl = new BUS_DX();
db = new CMART8Entities();
InitializeComponent();
controlFunction(tt);
TAIKHOAN tk2 = db.TAIKHOANs.Find(PDX.MATK);
txtNg.Text = tk2.HOTEN;
txtNgay.Text = PDX.NGAYDEXUAT.ToString();
loadlistCTDX();
}
//Delete CTPDX
public bool deleteCTPDX(string masp, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
db.CTPHIEUDEXUATs.Remove(ctdx);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//Update PDX
public bool updatePDX(PHIEUDEXUAT pdx, string mancc)
{
try
{
db = new CMART8Entities();
PHIEUDEXUAT dx = db.PHIEUDEXUATs.Find(pdx.SOPHIEUDX);
dx.MANCC = mancc;
db.Entry(dx).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//Hủy phiếu đề xuất
public bool deletePDX(PHIEUDEXUAT pdx)
{
try
{
db = new CMART8Entities();
List <CTPHIEUDEXUAT> lst = db.CTPHIEUDEXUATs.Where(x => x.SOPHIEU.Equals(pdx.SOPHIEUDX)).ToList();
foreach (CTPHIEUDEXUAT item in lst)
{
db.CTPHIEUDEXUATs.Remove(item);
}
db.SaveChanges();
db = new CMART8Entities();
PHIEUDEXUAT PDX = db.PHIEUDEXUATs.Find(pdx.SOPHIEUDX);
db.PHIEUDEXUATs.Remove(PDX);
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
public List <CTPHIEUDEXUAT> loadlistCTPDX(PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
return(db.CTPHIEUDEXUATs.Where(x => x.SOPHIEU.Equals(pdx.SOPHIEUDX)).ToList());
}
