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