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)); }