private void btnLuu_Click(object sender, EventArgs e)
{
mayta = gridPhancong.GetRowCellValue(gridPhancong.FocusedRowHandle, gridPhancong.Columns[1]).ToString();
string maca = gridPhancong.GetRowCellValue(gridPhancong.FocusedRowHandle, gridPhancong.Columns[3]).ToString();
if (flag_Insert == true)
{
try
{
dtoYTATRUC = new DTO_YTaTruc(gridLUMaYta.EditValue.ToString(), gridLUMaCa.EditValue.ToString(), dtpNgay.Value, gridLUMaPhong.EditValue.ToString());
busYTATRUC.Add(dtoYTATRUC);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
XtraMessageBox.Show("Thêm thông tin thành công!", "Thông báo", MessageBoxButtons.OK);
HIENTHI();
}
else
{
try
{
dtoYTATRUC = new DTO_YTaTruc(mayta, maca, dtpNgay.Value, gridLUMaPhong.EditValue.ToString());
busYTATRUC.Update(dtoYTATRUC);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
XtraMessageBox.Show("Sửa thông tin thành công!", "Thông báo", MessageBoxButtons.OK);
HIENTHI();
}
resetAll();
}
public bool Add(DTO_YTaTruc dto)
{
try
{
string sql = string.Format("INSERT INTO [dbo].[YTA_TRUC]([MASOYTA],[MACA],[NGAY],[MAPHONG])" +
"VALUES('{0}', '{1}', '{2}', '{3}')", dto.MASOYTA1, dto.MACA1, dto.NGAY1, dto.MAPHONG1);
db.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(DTO_YTaTruc dto)
{
try
{
string sql = string.Format("UPDATE [dbo].[YTA_TRUC]" +
"SET [NGAY] = '{0}'" +
",[MAPHONG] = '{1}'" +
"WHERE [MASOYTA] = '{2}' AND [MACA]='{3}'", dto.NGAY1, dto.MAPHONG1, dto.MASOYTA1, dto.MACA1);
db.ExecuteNonQuery(sql);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool Update(DTO_YTaTruc dto)
{
return(dal.Update(dto));
}
public bool Add(DTO_YTaTruc dto)
{
return(dal.Add(dto));
}
