public bool Update(DonhangModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "suadonhang",
"@MADH", model.MADH,
"@TENDANGNHAP", model.TENDANGNHAP,
"@NGAYDATHANG", model.NGAYDATHANG,
"@NGAYYEUCAU", model.NGAYYEUCAU,
"@DIACHINGUOINHAN", model.DIACHINGUOINHAN,
"@TINHTRANG", model.TINHTRANG
);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public void MuaHang(Khachhang kh, int thanhtien, List <CTDHang> ds, string diachigh, string sdtgh, int trangthai)
{
KhachhangdathangModel kdb = new KhachhangdathangModel();
kdb.ThemKhach(kh);
string ngay = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString();
DonhangModel ddb = new DonhangModel();
string MHMax = ddb.LayDonHangCungNgay(ngay);
//xu ly sinh ma hoa don theo quy tac
string ma = SinhMa(MHMax, ngay);
//end
Donhang dh = new Donhang();
dh.madonhang = ma;
dh.makh = sdtgh;
dh.diachigh = diachigh;
dh.sdtgh = sdtgh;
dh.ngaytao = DateTime.Now.ToString();
dh.thanhtien = thanhtien;
ddb.ThemDonHang(dh);
ChiTietDonHangModel cdb = new ChiTietDonHangModel();
foreach (CTDHang ct in ds)
{
ct.MaDHang = ma;
}
cdb.LuuDanhSachCTDH(ds);
}
public DonhangModel Create(DonhangModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError, "themdonhang",
"@TENDANGNHAP", model.TENDANGNHAP,
"@DIACHINGUOINHAN", model.DIACHINGUOINHAN,
"@TENKH", model.TENKH, "@EMAIL", model.EMAIL, " @SDT", model.SDT
);
if (!string.IsNullOrEmpty(msgError))
{
throw new Exception(msgError);
}
return(result.ConvertTo <DonhangModel>().FirstOrDefault());
}
catch (Exception ex)
{
throw ex;
}
}
public DonhangModel UpdateDH([FromBody] DonhangModel model)
{
abc.Create(model);
return(model);
}
public DonhangModel CreateDH([FromBody] DonhangModel model)
{
return(abc.Create(model));
}
public DonhangModel Create(DonhangModel model)
{
return(_res.Create(model));
}
public bool Update(DonhangModel model)
{
return(_res.Update(model));
}
