private void button2_Click(object sender, EventArgs e)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
int idpnhap = int.Parse(txtid.Text);
var ngaynhap = dtngaynhap.Value;
int.TryParse(lueDONGIAO.EditValue.ToString(), out int idgiaohang);
int.TryParse(lueStorekeeper.EditValue.ToString(), out int thukho);
string thukhoName = lueStorekeeper.Text;
string nguoigiao = txtNguoiGiao.Text;
string nguoinhap = txtNguoiNhan.Text;
if (ngaynhap == null)
{
XtraMessageBox.Show("Bạn chưa chọn ngày nhập!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (lstD_PNHAP_ViewModel.Count == 0)
{
XtraMessageBox.Show("Bạn chưa nhập hàng hóa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (lstD_PNHAP_ViewModel.Count() == 0)
{
XtraMessageBox.Show("Bạn chưa nhập hàng hóa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var model = new PNHAP_ViewModel();
var nameLog = Properties.Settings.Default.NameLog;
model.idpnhap = idpnhap;
model.idpgiao = idgiaohang;
model.ngaynhap = ngaynhap;
model.thukho = thukhoName;
model.nguoilapphieu = nameLog;
model.nguoigiao = nameLog;
var res = new PNHAPBll().savePNHAP(model, lstD_PNHAP_ViewModel, Properties.Settings.Default.NameLog);
if (res != "success")
{
XtraMessageBox.Show(res, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
XtraMessageBox.Show("Thêm phiếu giao hàng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
///
/// </summary>
/// <param name="obj"></param>
/// <param name="data"></param>
public void PrintPNHAP(PNHAP_ViewModel obj, List <D_PNHAP_ViewModel> data)
{
ReportPNHAP report = new ReportPNHAP();
//Hide paramater
foreach (DevExpress.XtraReports.Parameters.Parameter p in report.Parameters)
{
p.Visible = false;
}
//Init data report
report.InitData(obj, data);
documentViewer1.DocumentSource = report;
report.CreateDocument();
}
public void InitData(PNHAP_ViewModel master, List <D_PNHAP_ViewModel> detail)
{
using (var db = new RestaurantManagerDataEntities())
{
var toDay = DateTime.Now;
lblidpnhap.Text = master.idpnhap.ToString();
lblidgiaohang.Text = master.idpgiao.ToString();
lblngaynhap.Text = string.Format("{0}/{1}/{2}", master.ngaynhap.Value.Day, master.ngaynhap.Value.Month, master.ngaynhap.Value.Year);
lblnguoigiao.Text = master.nguoigiao;
lblnguoilap.Text = master.nguoilapphieu;
lblthukho.Text = master.thukho;
objectDataSource2.DataSource = detail;
lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year);
}
}
public string savePNHAP(PNHAP_ViewModel model, List <D_PNHAP_ViewModel> lstDetail, string nameLog)
{
using (var db = new RestaurantManagerDataEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
//master
var check = db.PNHAPs.FirstOrDefault(e => e.idpnhap == model.idpnhap);
if (check == null)
{
check = new PNHAP();
check.CreateBy = nameLog;
check.CreateDate = DateTime.Now;
db.PNHAPs.Add(check);
}
else
{
check.ModifyBy = nameLog;
check.ModifyDate = DateTime.Now;
db.Entry(check).State = EntityState.Modified;
}
check.thukho = model.thukho;
check.ngaynhap = model.ngaynhap;
check.idpgiao = model.idpgiao;
check.nguoigiao = model.nguoigiao;
check.nguoilapphieu = nameLog;
db.SaveChanges();
//detail
var details = db.D_PNHAP.Where(p => p.idpnhap == check.idpnhap).ToList();
if (details.Count() > 0)
{
db.D_PNHAP.RemoveRange(details);
}
db.SaveChanges();
foreach (var item in lstDetail)
{
var detail = new D_PNHAP
{
idpnhap = check.idpnhap,
idhang = item.idhang,
slgiao = item.slgiao,
slnhan = item.slnhan,
CreateBy = nameLog,
CreateDate = DateTime.Now,
};
db.D_PNHAP.Add(detail);
}
db.SaveChanges();
transaction.Commit();
return("success");
}
catch (Exception ex)
{
transaction.Rollback();
return(ex.Message);
}
}
}
}