private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView view = sender as GridView;
int[] selectedRowHandles = view.GetSelectedRows();
string maPT = view.GetRowCellValue(selectedRowHandles[0], "MAPHIEUTIEM").ToString();
for (int i = 0; i < editedPT.Count; i++)
{
if (editedPT[i].MaPT == maPT)
{
editedPT[i].NgayTiem = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTIEM").ToString()).ToString("yyyy-MM-dd");
editedPT[i].TenKH = view.GetRowCellValue(selectedRowHandles[0], "TENKH").ToString();
editedPT[i].NgaySinh = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYSINH").ToString()).ToString("yyyy-MM-dd");
editedPT[i].GioiTinh = view.GetRowCellValue(selectedRowHandles[0], "GIOITINH").ToString();
editedPT[i].TieuSu = view.GetRowCellValue(selectedRowHandles[0], "TIEUSU").ToString();
return;
}
}
string ngayTiem = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTIEM").ToString()).ToString("yyyy-MM-dd");
string tenKH = view.GetRowCellValue(selectedRowHandles[0], "TENKH").ToString();
string ngaySinh = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYSINH").ToString()).ToString("yyyy-MM-dd");
string gioiTinh = view.GetRowCellValue(selectedRowHandles[0], "GIOITINH").ToString();
string tieuSu = view.GetRowCellValue(selectedRowHandles[0], "TIEUSU").ToString();
DTO_PhieuTiemInfo ptif = new DTO_PhieuTiemInfo(maPT, ngayTiem, tenKH, ngaySinh, gioiTinh, tieuSu);
editedPT.Add(ptif);
EnableResetAndSaveButton();
}
public bool UpdatePhieuTiemInfo(DTO_PhieuTiemInfo ptif)
{
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand("sp_UpdatePhieuTiemInfo", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MAPHIEUTIEM", ptif.MaPT);
cmd.Parameters.AddWithValue("@NGAYTIEM", ptif.NgayTiem);
cmd.Parameters.AddWithValue("@TENKH", ptif.TenKH);
cmd.Parameters.AddWithValue("@NGAYSINH", ptif.NgaySinh);
cmd.Parameters.AddWithValue("@GIOITINH", ptif.GioiTinh);
cmd.Parameters.AddWithValue("@TIEUSU", ptif.TieuSu);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
_conn.Close();
}
return(false);
}
public bool UpdatePhieuTiemInfo(DTO_PhieuTiemInfo ptif)
{
return(dao.UpdatePhieuTiemInfo(ptif));
}
