public static Employer CreateEmployer(SqlDataReader dr)
{
Employer employer = new Employer();
if (!dr.IsClosed && dr.HasRows)
{
// getting id that uniquely identifies the object
int id = Convert.ToInt32(dr["employerid"]);
string updatedby = dr["updatedby"].ToString();
DateTime?updateddate = (DateTime)dr["updateddate"];
employer = new Employer(id, updatedby, updateddate);
employer.RaiseChangedEvents = false;
employer.EmployerName = dr["employername"].ToString();
employer.Street1 = dr["street1"].ToString();
employer.Street2 = dr["street2"].ToString();
employer.City = dr["city"].ToString();
employer.StateID = (dr.IsDBNull(dr.GetOrdinal("stateid"))) ? -1 : Convert.ToInt32(dr["stateid"].ToString());
employer.Zip = dr["zip"].ToString();
employer.Phone = dr["phone"].ToString();
employer.Save(false);
employer.RaiseChangedEvents = true;
}
return(employer);
}
private bool CanChangeCurrentEmployer()
{
bool rtnValue = true;
if (bindingEmployers.Current != null)
{
Employer employer = (Employer)bindingEmployers.Current;
switch (employer.MyState)
{
case MyObjectState.New:
case MyObjectState.Modified:
switch (MyMessageBox.Show(this, "Employer", MyDisplayMessage.SaveConfirm))
{
case DialogResult.Yes:
try
{
employer.Save(true);
bindingEmployers.ResetCurrentItem();
rtnValue = true;
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Employer", MyDisplayMessage.SaveError, ex);
rtnValue = false;
}
break;
case DialogResult.No:
if (employer.MyState == MyObjectState.New)
{
bindingEmployers.RemoveCurrent();
bindingEmployers.ResetBindings(false);
this.txtEmployerName.Focus();
}
else
{
employer.Reset();
}
rtnValue = true;
break;
case DialogResult.Cancel:
rtnValue = false;
break;
}
break;
}
}
return(rtnValue);
}
public virtual Employer Clone()
{
Employer emp = new Employer(this.ID, this.UpdatedBy, this.UpdatedDate);
emp.RaiseChangedEvents = false;
emp.EmployerName = this.EmployerName;
emp.Street1 = this.Street1;
emp.Street2 = this.Street2;
emp.City = this.City;
emp.StateID = this.StateID;
emp.Zip = this.Zip;
emp.Phone = this.Phone;
emp.Save(false);
emp.RaiseChangedEvents = true;
return(emp);
}
private void mnuEmployer_Click(object sender, EventArgs e)
{
Employer employer = (Employer)bindingEmployers.Current;
if (sender.Equals(mnuEmployerNew))
{
/********************************************************************************
* New
********************************************************************************/
if (CanChangeCurrentEmployer())
{
_GridViewState = GridViewState.Adding;
bindingEmployers.AddNew();
_GridViewState = GridViewState.None;
this.txtEmployerName.Focus();
}
}
else if (sender.Equals(mnuEmployerRemove))
{
/********************************************************************************
* Remove
********************************************************************************/
if (DialogResult.OK == MyMessageBox.Show(this, "Employer", MyDisplayMessage.RemoveConfirm))
{
try
{
bindingEmployers.RemoveCurrent();
bindingEmployers.ResetBindings(false);
this.ucFilter.Focus();
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Employer", MyDisplayMessage.RemoveError, ex);
}
}
}
else if (sender.Equals(mnuEmployerRefresh))
{
/********************************************************************************
* Refresh
********************************************************************************/
if (!employer.MyState.Equals(MyObjectState.Current))
{
if (DialogResult.Cancel == MyMessageBox.Show(this, "Employer", MyDisplayMessage.RefreshConfirm))
{
return;
}
}
try
{
employer.Refresh();
bindingEmployers.ResetBindings(false);
this.txtEmployerName.Focus();
this.txtEmployerName.Select(0, 0);
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Employer", MyDisplayMessage.RefreshError, ex);
}
}
else if (sender.Equals(mnuEmployerSave))
{
/********************************************************************************
* Save
********************************************************************************/
bindingEmployers.EndEdit();
try
{
employer.Save(true);
bindingEmployers.ResetBindings(false);
bindingEmployers.Sort = "";
if (dgvEmployers.SortOrder == SortOrder.Descending)
{
bindingEmployers.Sort = dgvEmployers.SortedColumn.DataPropertyName + " DESC";
}
else
{
bindingEmployers.Sort = dgvEmployers.SortedColumn.DataPropertyName + " ASC";
}
ResetDataGridViewEmployer(employer);
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Employer", MyDisplayMessage.SaveError, ex);
}
}
else if (sender.Equals(mnuEmployerCancel))
{
/********************************************************************************
* Cancel
********************************************************************************/
if (employer.MyState == MyObjectState.New)
{
bindingEmployers.RemoveCurrent();
if (bindingEmployers.Count > 0)
{
bindingEmployers.Position = 0;
this.txtEmployerName.Focus();
this.txtEmployerName.Select(0, 0);
}
else
{
this.ucFilter.Focus();
}
}
else
{
employer.Reset();
bindingEmployers.ResetCurrentItem();
}
}
}
