public string saveDONMH(DONMH_ViewModel donmh, List <D_DONMH_ViewModel> lstDdonmh, string nameLog)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
//master
var check = db.DONMHs.FirstOrDefault(e => e.iddonmh == donmh.iddonmh);
if (check == null)
{
check = new DONMH();
check.CreateBy = nameLog;
check.CreateDate = DateTime.Now;
db.Entry(check).State = EntityState.Added;
db.DONMHs.Add(check);
}
else
{
check.ModifyBy = nameLog;
check.ModifyDate = DateTime.Now;
db.Entry(check).State = EntityState.Modified;
}
check.iddonmh = donmh.iddonmh;
check.ngaydonmh = donmh.ngaydonmh;
check.idncc = donmh.idncc;
db.SaveChanges();
//detail
var checkD = db.D_DONMH.Where(e => e.iddonmh == check.iddonmh).ToList();
if (checkD.Count() > 0)
{
db.D_DONMH.RemoveRange(checkD);
}
foreach (var item in lstDdonmh)
{
var detail = new D_DONMH
{
iddonmh = check.iddonmh,
idhang = item.idhang,
slmh = item.slmh,
dongiamh = int.Parse(item.dongiamh.ToString()), //đổi sang double
CreateBy = nameLog,
CreateDate = DateTime.Now,
};
db.D_DONMH.Add(detail);
}
db.SaveChanges();
return("success");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void InitData(DONMH_ViewModel obj, List <D_DONMH_ViewModel> lstDetail)
{
using (var db = new RestaurantManagerDataEntities())
{
var toDay = DateTime.Now;
lbliddonmua.Text = obj.iddonmh.ToString();
lbldiachi.Text = obj.diachi;
lbltenncc.Text = obj.tenncc;
lblsdt.Text = obj.sdt;
lblFooterDate.Text = string.Format("Ngày {0} tháng {1} năm {2}", toDay.Day, toDay.Month, toDay.Year);
objectDataSource3.DataSource = lstDetail;
}
}
/// <summary>
///
/// </summary>
/// <param name="obj"></param>
/// <param name="data"></param>
public void PrintDONMH(DONMH_ViewModel obj, List <D_DONMH_ViewModel> data)
{
ReportDONMH report = new ReportDONMH();
//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();
}
private void button2_Click(object sender, EventArgs e)
{
//validate
int iddonmh = int.Parse(txtid.Text);
var ngaydonmh = dtngaydonmh.Value;
int.TryParse(luencc.EditValue.ToString(), out int idncc);
if (ngaydonmh == null)
{
XtraMessageBox.Show("Bạn chưa chọn ngày mua hàng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (lstD_DONMH_ViewModel.Count == 0)
{
XtraMessageBox.Show("Bạn chưa nhập hàng hóa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var obj = new DONMH_ViewModel()
{
iddonmh = iddonmh,
idncc = idncc,
ngaydonmh = ngaydonmh
};
var res = new DONMHBll().saveDONMH(obj, lstD_DONMH_ViewModel, Properties.Settings.Default.NameLog);
if (res != "success")
{
XtraMessageBox.Show(res, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
XtraMessageBox.Show("Thêm mới đơn hàng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
//uctDONMH uctDONMH = new uctDONMH();
//uctDONMH.LoadGrid();
}
