void CheckTT(string phong, int vitri)
{
dulieu = xl.LoadDSSV(lb_Phong.Text);
if (Session["TT"] == null)
{
DataTable dt = new DataTable();
dt.Rows.Clear();
dt.Columns.Clear();
dt.Columns.Add("MaTT", typeof(int));
dt.Columns.Add("MaSV", typeof(string));
dt.Columns.Add("HoTen", typeof(string));
dt.Columns.Add("SoThang", typeof(int));
dt.Columns.Add("GiaPhong", typeof(int));
dt.Columns.Add("TT", typeof(int), "SoThang * GiaPhong");
int matt = int.Parse(dulieu.Rows[vitri]["MaTinhTrang"].ToString());
string sv = dulieu.Rows[vitri]["TenTaiKhoan"].ToString();
string ht = dulieu.Rows[vitri]["HoTen"].ToString();
int st = 1;
int gp = int.Parse(dulieu.Rows[vitri]["GiaPhong"].ToString());
int tt = st * gp;
dt.Rows.Add(matt, sv, ht, st, gp, tt);
Session["TT"] = dt;
}
else
{
DataTable dt = (DataTable)Session["TT"];
int vt = xl.CheckVTSP(dt, dulieu.Rows[vitri]["MaTinhTrang"].ToString());
if (vt == 0) //chua ton tại
{
int matt = int.Parse(dulieu.Rows[vitri]["MaTinhTrang"].ToString());
string sv = dulieu.Rows[vitri]["TenTaiKhoan"].ToString();
string ht = dulieu.Rows[vitri]["HoTen"].ToString();
int st = 1;
int gp = int.Parse(dulieu.Rows[vitri]["GiaPhong"].ToString());
int tt = st * gp;
dt.Rows.Add(matt, sv, ht, st, gp, tt);
Session["TT"] = dt;
}
else
{
Session["TT"] = xl.UpdateSoluong(dt, dulieu.Rows[vitri]["MaTinhTrang"].ToString());
}
}
}
