private void btnAddDetails_Click(object sender, EventArgs e)
{
var s_idyc = txtid.Text;
int.TryParse(s_idyc, out int idyc);
int.TryParse(lueNLieu.EditValue.ToString(), out int idhang);
int.TryParse(txtsldukien.EditValue.ToString(), out int sldukien);
int.TryParse(txtslton.EditValue.ToString(), out int slton);
int.TryParse(txtnguong.EditValue.ToString(), out int nguong);
if (lueNLieu.Text == null || idhang <= 0)
{
XtraMessageBox.Show("Bạn chưa chọn mã hàng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (sldukien <= 0)
{
XtraMessageBox.Show("Số lương dự kiến phải lớn hơn 0!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var result = XtraMessageBox.Show("Bạn có chắc chắn muốn thêm ?", "Xác nhận", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
var ngayyc = dtpnyc.Value;
var d_pyc = new D_PYC
{
idyc = idyc,
idhang = idhang,
sldukien = sldukien,
slton = slton,
nguong = nguong,
CreateBy = Properties.Settings.Default.NameLog,
ModifyBy = Properties.Settings.Default.NameLog,
CreateDate = DateTime.Now,
ModifyDate = DateTime.Now
};
var resultObj = new PYCBll().AddD_PYC(d_pyc);
if (resultObj == "success")
{
XtraMessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadGridDetails(d_pyc.idyc);
return;
}
else
{
XtraMessageBox.Show("Thêm không thành công !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
}
public string AddD_PYC(D_PYC model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.D_PYC.FirstOrDefault(x => x.idyc == model.idyc && x.idhang == model.idhang);
if (check == null)
{
var D_PYC = new D_PYC
{
idyc = model.idyc,
idhang = model.idhang,
sldukien = model.sldukien,
slton = model.slton,
nguong = model.nguong,
CreateDate = DateTime.Now,
CreateBy = model.ModifyBy
};
check = db.D_PYC.Add(D_PYC);
db.SaveChanges();
return("success");
}
else
{
check.sldukien = model.sldukien;
check.slton = model.slton;
check.nguong = model.nguong;
check.ModifyDate = DateTime.Now;
check.ModifyBy = model.ModifyBy;
db.SaveChanges();
return("success");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string SavePYC(PYC obj, List <D_PYC_ViewModel> details, string loginUser)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.PYCs.FirstOrDefault(x => x.idyc == obj.idyc);
if (check == null)
{
var PYC = new PYC
{
ngayyc = obj.ngayyc,
CreateDate = DateTime.Now,
CreateBy = loginUser
};
check = db.PYCs.Add(PYC);
db.SaveChanges();
foreach (D_PYC_ViewModel item in details)
{
var d_pyc = new D_PYC
{
idyc = check.idyc,
idhang = item.idhang,
sldukien = item.sldukien,
slton = item.slton,
nguong = item.nguong,
CreateBy = loginUser,
CreateDate = DateTime.Now,
};
db.D_PYC.Add(d_pyc);
}
db.SaveChanges();
return("success");
}
else
{
check.ngayyc = obj.ngayyc;
check.ModifyDate = DateTime.Now;
check.ModifyBy = loginUser;
db.SaveChanges();
db.D_PYC.RemoveRange(db.D_PYC.Where(x => x.idyc == obj.idyc));
db.SaveChanges();
foreach (D_PYC_ViewModel item in details)
{
var d_pyc = new D_PYC
{
idyc = check.idyc,
idhang = item.idhang,
sldukien = item.sldukien,
slton = item.slton,
nguong = item.nguong,
CreateBy = loginUser,
CreateDate = DateTime.Now,
};
db.D_PYC.Add(d_pyc);
}
db.SaveChanges();
return("success");
}
}
}
catch (Exception ex)
{
return(null);
}
}
