private void btnDelete_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
if (string.IsNullOrWhiteSpace(txtID.Text))
{
clsMessages.ShowInformation("Vui lòng chọn dòng dữ liệu muốn xóa!");
return;
}
long lID = Convert.ToInt64(txtID.Text);
ds = HouseholderDAO.Householder_Del(lID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1)
{
clsMessages.ShowInformation("Xóa thành công!");
LoadDataToForm();
}
else
{
clsMessages.ShowWarning(ds.Tables[0].Rows[0]["ErrorDesc"].ToString());
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
HouseholderDTO obj = new HouseholderDTO();
obj.ID = -1;
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Phone = txtPhone.Text;
ds = HouseholderDAO.Householder_Search(obj);
if (ds != null && ds.Tables.Count > 0)
{
dgvHouseholder.DataSource = ds.Tables[0].Copy();
}
else
{
clsMessages.ShowWarning("Không tìm thấy");
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
HouseholderDTO obj = new HouseholderDTO();
obj.ID = -1;
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Phone = txtPhone.Text;
ds = HouseholderDAO.Householder_InsUpd(obj);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1)
{
clsMessages.ShowInformation("Thêm thành công!");
frmParent.LoadDataToForm();
this.Close();
}
else
{
clsMessages.ShowWarning("Thêm thất bại!");
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
public void LoadDataToForm()
{
try
{
DataTable dt = new DataTable();
dt = HouseholderDAO.Householder_GetAll().Tables[0].Copy();
dgvHouseholder.DataSource = dt;
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
HouseholderDTO obj = new HouseholderDTO();
if (string.IsNullOrWhiteSpace(txtID.Text))
{
clsMessages.ShowInformation("Vui lòng chọn dòng dữ liệu muốn sửa!");
return;
}
obj.ID = Convert.ToInt64(txtID.Text);
obj.Name = txtName.Text;
obj.Address = txtAddress.Text;
obj.Phone = txtPhone.Text;
ds = HouseholderDAO.Householder_InsUpd(obj);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1)
{
clsMessages.ShowInformation("Cập nhật thành công!");
LoadDataToForm();
}
else
{
clsMessages.ShowWarning("Cập nhật thất bại!");
}
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
}
}
private void LoadDataToCombobox()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
ds = LocationDAO.LoadDataCombobox();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0].Copy();
cboLocation.Items.Add(new clsComboItem(-1, ""));
foreach (DataRow item in dt.Rows)
{
clsComboItem itemCbo = new clsComboItem();
itemCbo.Value = item["Value"];
itemCbo.Display = item["Display"].ToString();
cboLocation.Items.Add(itemCbo);
}
cboLocation.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1;
dt.Clear();
}
ds.Clear();
ds = EmployeeDAO.LoadDataCombobox().Copy();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0].Copy();
cboEmployee.Items.Add(new clsComboItem(-1, ""));
foreach (DataRow item in dt.Rows)
{
clsComboItem itemCbo = new clsComboItem();
itemCbo.Value = item["Value"];
itemCbo.Display = item["Display"].ToString();
cboEmployee.Items.Add(itemCbo);
}
cboEmployee.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1;
dt.Clear();
}
ds.Clear();
ds = HouseholderDAO.LoadDataCombobox().Copy();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0].Copy();
cboHouseholder.Items.Add(new clsComboItem(-1, ""));
foreach (DataRow item in dt.Rows)
{
clsComboItem itemCbo = new clsComboItem();
itemCbo.Value = item["Value"];
itemCbo.Display = item["Display"].ToString();
cboHouseholder.Items.Add(itemCbo);
}
cboHouseholder.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1;
dt.Clear();
}
ds.Clear();
ds = HouseTypeDAO.LoadDataCombobox().Copy();
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0].Copy();
cboHouseType.Items.Add(new clsComboItem(-1, ""));
foreach (DataRow item in dt.Rows)
{
clsComboItem itemCbo = new clsComboItem();
itemCbo.Value = item["Value"];
itemCbo.Display = item["Display"].ToString();
cboHouseType.Items.Add(itemCbo);
}
cboHouseType.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1;
dt.Clear();
}
ds.Clear();
}
catch (Exception ex)
{
clsMessages.ShowErrorException(ex);
}
finally
{
ds.Dispose();
dt.Dispose();
}
}
