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