private void dgvLst_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0)
{
DataRow row = ((senderGrid.DataSource) as DataTable).Rows[e.RowIndex];
ResortManagerDTO.DTO.DatChoRecord datcho = new ResortManagerDTO.DTO.DatChoRecord();
datcho.MaDoan = row["MADOAN"].ToString();
datcho.HoTen = row["HOTEN"].ToString();
datcho.CMND = row["CMND"].ToString();
datcho.MaPhong = row["MAPHONG"].ToString();
datcho.MaCT = Int32.Parse(row["MACHITIET"].ToString());
datcho.NgayBatDau = DateTime.Parse(row["NGAYBATDAU"].ToString());
datcho.NgayKetThuc = DateTime.Parse(row["NGAYKETTHUC"].ToString());
datcho.Gia = Int32.Parse(row["GIA"].ToString());
datcho.ThanhTien = Int32.Parse(row["THANHTIEN"].ToString());
ResortManagerDTO.DTO.DbAck ck = ResortManagerBUS.BUS.DatChoRecord.DeleleteDatCho(datcho);
if (ck == ResortManagerDTO.DTO.DbAck.Ok)
{
MessageBox.Show("Xóa thành công");
LoadGrid();
}
else if (ck == ResortManagerDTO.DTO.DbAck.NetworkError)
{
MessageBox.Show("Lỗi kết nối", "Thông báo");
}
else
{
MessageBox.Show("Lỗi không xác định", "Thông báo");
}
}
}
public static List <ResortManagerDTO.DTO.DatChoRecord> SelectDatCho(out ResortManagerDTO.DTO.DbAck ack, String MaDoan)
{
Provider provider = new Provider();
ack = provider.Connect();
if (ack == ResortManagerDTO.DTO.DbAck.NetworkError)
{
return(null);
}
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MADOAN", MaDoan)
};
DataTable dt = new DataTable();
dt = provider.Select(CommandType.StoredProcedure, "SelectDatCho", out ack, para);
List <ResortManagerDTO.DTO.DatChoRecord> lstDatCho = new List <ResortManagerDTO.DTO.DatChoRecord>();
if (dt == null)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
ResortManagerDTO.DTO.DatChoRecord datcho = new ResortManagerDTO.DTO.DatChoRecord
{
MaCT = Int32.Parse(row["MACHITIET"].ToString()),
MaDoan = row["MADOAN"].ToString(),
HoTen = row["HOTEN"].ToString(),
CMND = row["CMND"].ToString(),
MaPhong = row["MAPHONG"].ToString(),
NgayBatDau = DateTime.Parse(row["NGAYBATDAU"].ToString()),
NgayKetThuc = DateTime.Parse(row["NGAYKETTHUC"].ToString()),
Gia = Int32.Parse(row["GIA"].ToString()),
ThanhTien = Int32.Parse(row["THANHTIEN"].ToString())
};
lstDatCho.Add(datcho);
}
provider.Disconnect();
return(lstDatCho);
}
public static ResortManagerDTO.DTO.DbAck DeleteDatCho(ResortManagerDTO.DTO.DatChoRecord a)
{
Provider provider = new Provider();
ResortManagerDTO.DTO.DbAck result = provider.Connect();
if (result == ResortManagerDTO.DTO.DbAck.NetworkError)
{
goto Network;
}
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MACHITIET", a.MaCT),
new SqlParameter("@MADOAN", a.MaDoan)
};
result = provider.ExcuteNonQuery(CommandType.StoredProcedure, "DeleteDatCho", para);
provider.Disconnect();
Network:
return(result);
}
public static ResortManagerDTO.DTO.DbAck DeleleteDatCho(ResortManagerDTO.DTO.DatChoRecord a)
{
return(ResortManagerDAO.DAO.DatChoRecord.DeleteDatCho(a));
}
