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