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