private void btnJoinRoom_Click(object sender, EventArgs e)
{
ResortManagerDTO.DTO.DbAck ack = new ResortManagerDTO.DTO.DbAck();
String strIdRoom = cmbRoom.SelectedItem.ToString().Split('-')[0];
ResortManagerDTO.DTO.CTGiaoDich ctgd = new ResortManagerDTO.DTO.CTGiaoDich();
for (int i = 0; i < dgvLst.Rows.Count; i++)
{
ctgd.CMND = dgvLst.Rows[i].Cells[0].Value.ToString().Trim();
ctgd.MADOAN = this.MaDoan;
ctgd.MAPHONG = strIdRoom;
ack = ResortManagerBUS.BUS.CTGiaoDich.ThemCTGD(ctgd);
if (ack != ResortManagerDTO.DTO.DbAck.Ok)
{
MessageBox.Show("Thêm CTGD thất bại");
return;
}
String MaCTGD = ResortManagerBUS.BUS.CTGiaoDich.LayMaCTDG(out ack, ctgd.CMND);
ack = ResortManagerBUS.BUS.PhieuTra.ThemPhieuTra(MaCTGD);
if (ack != ResortManagerDTO.DTO.DbAck.Ok)
{
MessageBox.Show("Thêm PHIEUTRA thất bại");
return;
}
}
txtCMND_TV1.Text = "";
dgvLst.Rows.Clear();
cmbRoom.Items.Remove(cmbRoom.SelectedItem);
cmbRoom.SelectedIndex = -1;
}
public static ResortManagerDTO.DTO.DbAck ErrThemChiTietGiaoDich(ResortManagerDTO.DTO.CTGiaoDich ctgd)
{
Provider provider = new Provider();
ResortManagerDTO.DTO.DbAck result = provider.Connect();
if (result == ResortManagerDTO.DTO.DbAck.NetworkError)
{
goto Network; // net nhu la networkerror thi nhay den lable network
}
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@cmnd", ctgd.CMND),
new SqlParameter("@maDoan", ctgd.MADOAN),
new SqlParameter("@maPhong", ctgd.MAPHONG)
};
result = provider.ExcuteNonQuery(CommandType.StoredProcedure, "usp_ErrThemChiTietGiaoDich", para);
provider.Disconnect();
//lable network
Network:
return(result);
}
public static List <ResortManagerDTO.DTO.CTGiaoDich> SelectByIdRoom(out ResortManagerDTO.DTO.DbAck ack, String IdRoom)
{
Provider provider = new Provider();
ack = provider.Connect();
if (ack == ResortManagerDTO.DTO.DbAck.NetworkError)
{
return(null);
}
DataTable dt = new DataTable();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@maphong", IdRoom)
};
dt = provider.Select(CommandType.StoredProcedure, "usp_LayCTGDtheoMaPhong", out ack, para);
List <ResortManagerDTO.DTO.CTGiaoDich> lstItem = new List <ResortManagerDTO.DTO.CTGiaoDich>();
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
ResortManagerDTO.DTO.CTGiaoDich item = new ResortManagerDTO.DTO.CTGiaoDich();
item.MACHITIET = int.Parse(row["MACHITIET"].ToString());
item.HOTEN = (row["HOTEN"].ToString());
item.CMND = (row["CMND"].ToString());
item.GIA = int.Parse(row["GIA"].ToString());
item.MADOAN = (row["MADOAN"].ToString());
item.MAPHONG = (row["MAPHONG"].ToString());
lstItem.Add(item);
}
provider.Disconnect();
return(lstItem);
}
public static ResortManagerDTO.DTO.DbAck ErrThemChiTietGiaoDich(ResortManagerDTO.DTO.CTGiaoDich ctgd)
{
return(ResortManagerDAO.DAO.CTGiaoDich.ErrThemChiTietGiaoDich(ctgd));
}
public static ResortManagerDTO.DTO.DbAck ThemCTGD(ResortManagerDTO.DTO.CTGiaoDich ctgd)
{
return(ResortManagerDAO.DAO.CTGiaoDich.ThemCTGD(ctgd));
}
