public JsonResult CreateOrUpDate(HoaDonEntities Option) { var result = new HttpResponseMessage { StatusCode = HttpStatusCode.OK }; try { if (Option.ID_HoaDon > 0) { Option.Date_Edited = DateTime.Now; _hoadonService.Update(Option); } else { Option.Date_Created = DateTime.Now; _hoadonService.Create(Option); } } catch (Exception ex) { result.StatusCode = HttpStatusCode.InternalServerError; result.ReasonPhrase = ex.Message; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public bool Update(HoaDonEntities Option) { var success = false; if (Option != null) { using (var scope = new TransactionScope()) { var o = _unitOfWork.HoaDonRepository.Get(x => x.ID_HoaDon == Option.ID_HoaDon); if (o != null) { //o.ID_Thuoc = Option.ID_Thuoc; //o.tenThuoc = Option.tenThuoc; //o.loaiThuoc = Option.loaiThuoc; //o.soLuongTon = Option.soLuongTon; //o.GhiChu = Option.GhiChu; //o.Date_Edited = DateTime.Now; ; //o.IsDelete = Option.IsDelete; Mapper.CreateMap <HoaDonEntities, HoaDon>(); o = Mapper.Map <HoaDonEntities, HoaDon>(Option); } _unitOfWork.HoaDonRepository.Update(o); _unitOfWork.Save(); scope.Complete(); } } return(success); }
public DataTable HDmBUS(HoaDonEntities h) { DataTable dt = null; dt = HdDAO.GetHDmDAO(h); return(dt); }
public DataTable ThemHDBUS(HoaDonEntities h) { DataTable dt = null; dt = HdDAO.LuuHoaDon(h); return(dt); }
public int Create(HoaDonEntities Option) { using (var scope = new TransactionScope()) { Mapper.CreateMap <HoaDonEntities, HoaDon>(); var o = Mapper.Map <HoaDonEntities, HoaDon>(Option); o.IsDelete = false; o.Date_Created = DateTime.Now; _unitOfWork.HoaDonRepository.Insert(o); _unitOfWork.Save(); scope.Complete(); return(o.ID_HoaDon); } }
public void btn_TraPhong_Click(object sender, EventArgs e) { //string q, w, p; HoaDonEntities hd = new HoaDonEntities(); hd.Phong = ID; hd.Ten = lb_contentNguoiThue.Text; hd.Sdt = lb_contentSDT.Text; hd.NgayVao = lb_contentNgayVao.Text; hd.NgayTra = Convert.ToString(System.DateTime.Today.ToString()); hd.SoDien = txt_contentDien.Text; hd.SoNuoc = txt_contentNuoc.Text; hd.SoInternet = txt_contentInternet.Text; hd.TongCong = lb_TongCong.Text; HoaDonBUS hdbus = new HoaDonBUS(); DataTable dtt = hdbus.ThemHDBUS(hd); PhongEntities ee = new PhongEntities(); ThongTinKhachThueEntities c = new ThongTinKhachThueEntities(); c.ID = Convert.ToInt32(ID); c.Ten = null; c.NgaySinh = null; //w = ""; c.GioiTinh = Convert.ToBoolean(null); //q = ""; c.CMND = Convert.ToInt32(null); //c.CMND = Convert.ToInt32(lb_contentCMND.Text); c.NgayCap = ""; c.NoiCap = ""; c.NgayVao = ""; //p = ""; c.Sdt = Convert.ToInt32(null); //c.PhongId = Convert.ToInt32(""); ee.HienTrang = mm; ee.Id = Convert.ToInt32(ID); ThongTinKhachThueBUS cbus = new ThongTinKhachThueBUS(); DataTable dt = cbus.GetTKBUS(c); PhongBUS t = new PhongBUS(); DataTable tt = t.GetUpdate(ee); MessageBox.Show("Trả " + label3.Text + " thành công."); homee.doimauu(b1); Close(); }
public DataTable GetHDmDAO(HoaDonEntities h) { string sql = "select * from HoaDon where ID='" + h.Id + "'"; return(getDataTable(sql)); }
public DataTable LuuHoaDon(HoaDonEntities h) { string sql = "insert into HoaDon ('Phong','Ten','Sdt','NgayVao','NgayTra','SoDien','SoNuoc','SoInternet','TongCong') values ('" + h.Phong + "','" + h.Ten + "','" + h.Sdt + "','" + h.NgayVao + "','" + h.NgayTra + "','" + h.SoDien + "','" + h.SoNuoc + "','" + h.SoInternet + "','" + h.TongCong + "')"; return(getDataTable(sql)); }