private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView view = sender as GridView;
int[] selectedRowHandles = view.GetSelectedRows();
string maHD = view.GetRowCellValue(selectedRowHandles[0], "MAHOADON").ToString();
for (int i = 0; i < editedHD.Count; i++)
{
if (editedHD[i].MaHD == maHD)
{
editedHD[i].NgayThu = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTHU").ToString()).ToString("yyyy-MM-dd");
editedHD[i].NguoiGH = view.GetRowCellValue(selectedRowHandles[0], "NGUOIGH").ToString();
editedHD[i].DiaChi = view.GetRowCellValue(selectedRowHandles[0], "DIACHI").ToString();
editedHD[i].Sdt = view.GetRowCellValue(selectedRowHandles[0], "SDT").ToString();
return;
}
}
string ngayThu = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTHU").ToString()).ToString("yyyy-MM-dd");
string nguoiGH = view.GetRowCellValue(selectedRowHandles[0], "NGUOIGH").ToString();
string diaCHi = view.GetRowCellValue(selectedRowHandles[0], "DIACHI").ToString();
string sdt = view.GetRowCellValue(selectedRowHandles[0], "SDT").ToString();
DTO_HoaDonInfo hdif = new DTO_HoaDonInfo(maHD, ngayThu, nguoiGH, diaCHi, sdt);
editedHD.Add(hdif);
EnableResetAndSaveButton();
}
public bool UpdateHoaDonInfo(DTO_HoaDonInfo hdif)
{
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand("sp_UpdateHoaDonInfo", _conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MAHOADON", hdif.MaHD);
cmd.Parameters.AddWithValue("@NGAYTHU", hdif.NgayThu);
cmd.Parameters.AddWithValue("@NGUOIGH", hdif.NguoiGH);
cmd.Parameters.AddWithValue("@DIACHI", hdif.DiaChi);
cmd.Parameters.AddWithValue("@SDT", hdif.Sdt);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
_conn.Close();
}
return(false);
}
public bool UpdateHoaDonInfo(DTO_HoaDonInfo hdif)
{
return(dao.UpdateHoaDonInfo(hdif));
}
