public DataCheckOut(string MT62ID)
{
GetData4Rep();
string sql = "select getdate()";
ngayht = _dbData.GetValue(sql);
sql = "select * from mt62 where mt62id='" + MT62ID + "' ; select * from dt62 where mt62id='" + MT62ID + "' and isCheckIn=1";
ds = _dbData.GetDataSet(sql);
if (ds.Tables[0].Rows.Count == 0)
{
return;
}
ds.Tables[0].ColumnChanged += new DataColumnChangeEventHandler(DataCheckOut_ColumnChanged);
mt = ds.Tables[0].Rows[0];
NgayDiOld = mt["NgayDi"];
// mt["NgayDi"] = DateTime.Now;
dt = ds.Tables[1];
dt.TableNewRow += new DataTableNewRowEventHandler(dt_TableNewRow);
dt.PrimaryKey = new DataColumn[] { dt.Columns["DT62ID"] };
foreach (DataRow dr in dt.Rows)
{
DataCheckOut1Room dtChkOut = new DataCheckOut1Room(dr, _dbData);
dtChkOut.ThueSuat = double.Parse(mt["Thuesuat"].ToString());
dtChkOut.setMinibarData();
// dtChkOut.dt["NgayDi"] = DateTime.Now;
dr["NgayDi"] = dtChkOut.dt["NgayDi"];
dr["SoNgay"] = dtChkOut.dt["SoNgay"];
dr["MaGia"] = dtChkOut.dt["MaGia"];
dr["GiaPhong"] = dtChkOut.dt["GiaPhong"];
dr["SoNT"] = dtChkOut.dt["SoNT"];
dr["Ps"] = dtChkOut.dt["Ps"];
lChkOut.Add(dtChkOut);
dtChkOut.TTienChanged += new EventHandler(dtChkOut_TTienChanged);
}
TinhTongTien();
}
public bool ChuyenPhong(DataCheckOut1Room crRoom, string MaPhongDen)
{
DataRow rdt = dt.NewRow();
rdt["DT62ID"] = Guid.NewGuid();
rdt["MaPhong"] = MaPhongDen;
rdt["MaGia"] = crRoom.dt["MaGia"];
rdt["DaChuyen"] = 0;
rdt["MaLoaiPhong"] = crRoom.dt["MaLoaiPhong"];
rdt["GiaPhong"] = crRoom.dt["GiaPhong"];
rdt["GiaPhong1"] = crRoom.dt["GiaPhong1"];
rdt["NgayTT"] = crRoom.dt["NgayTT"];
rdt["NgayDen"] = DateTime.Parse(ngayht.ToString());
rdt["SoNT"] = crRoom.dt["SoNT"];
//rdt["NgayDi"] = mt["NgayDi"];
DataCheckOut1Room dtChkOut = new DataCheckOut1Room(rdt, _dbData);
dtChkOut.ThueSuat = double.Parse(mt["Thuesuat"].ToString());
dtChkOut.setMinibarData();
// dtChkOut.dt["NgayDi"] = DateTime.Now;
rdt["NgayDi"] = mt["NgayDi"];
rdt["isCheckOut"] = false;
rdt["isCheckIn"] = true;
rdt["SoNgay"] = mt["SoNgay"];
_dbData.BeginMultiTrans();
try
{
string sql = "insert into dt62 (MT62ID, DT62ID,MaPhong, GiaPhong,GiaPhong1,Ps,SoNT,isCheckIn,isCheckOut, NgayDen, NgayDi,MaLoaiPhong, MaGia,NgayTT,DaChuyen,SoNgay) values('" +
mt["MT62ID"].ToString() + "','" + rdt["DT62ID"].ToString() + "','" + rdt["MaPhong"].ToString() + "'," + rdt["GiaPhong"].ToString() + "," + rdt["GiaPhong1"].ToString() + "," +
rdt["Ps"].ToString() + "," + rdt["SoNT"].ToString() + ",1,0,'" + rdt["NgayDen"].ToString() + "','" + rdt["NgayDi"].ToString() + "','" +
rdt["MaLoaiPhong"].ToString() + "'," + rdt["MaGia"].ToString() + ",'" + rdt["NgayTT"].ToString() + "',0," + rdt["SoNgay"].ToString() + ")";
_dbData.UpdateByNonQuery(sql);
sql = " update dmPhong set MaTT='IN' where MaPhong='" + rdt["MaPhong"].ToString() + "'";
_dbData.UpdateByNonQuery(sql);
crRoom.dt["DaChuyen"] = true;
// crRoom.dt["isCheckOut"] = false;
if (crRoom != null && crRoom.dt["isCheckOut"].ToString() == "False")
{
crRoom.dt["NgayDi"] = DateTime.Parse(ngayht.ToString());
if (this.CheckOut1RoomWithoutTrans(crRoom))
{
crRoom.dt["isCheckOut"] = true;
}
}
if (!_dbData.HasErrors)
{
lChkOut.Add(dtChkOut);
dtChkOut.TTienChanged += new EventHandler(dtChkOut_TTienChanged);
dt.Rows.Add(rdt);
rdt["NgayDi"] = mt["NgayDi"];
dt.AcceptChanges();
_dbData.EndMultiTrans();
return(true);
}
else
{
dt.RejectChanges();
_dbData.RollbackMultiTrans();
return(false);
}
}
catch
{
dt.RejectChanges();
_dbData.RollbackMultiTrans();
return(false);
}
}
