public static FeeType CreateFeeType(SqlDataReader dr)
{
FeeType fee = new FeeType();
if (!dr.IsClosed && dr.HasRows)
{
// getting id that uniquely identifies the object
int id = Convert.ToInt32(dr["feetypeid"]);
string updatedby = dr["updatedby"].ToString();
DateTime?updateddate = Convert.ToDateTime(dr["updateddate"]);
fee = new FeeType(id, updatedby, updateddate);
fee.RaiseChangedEvents = false;
fee.FeeTypeName = dr["feetype"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("paymentorder")))
{
fee.PaymentOrder = Convert.ToInt32(dr["paymentorder"].ToString());
}
fee.Billable = Convert.ToBoolean(dr["billable"].ToString());
fee.Save(false);
fee.RaiseChangedEvents = true;
}
return(fee);
}
private bool CanChangeCurrentFeeType()
{
bool rtnValue = true;
if (bindingFeeTypes.Current != null)
{
FeeType feetype = (FeeType)bindingFeeTypes.Current;
switch (feetype.MyState)
{
case MyObjectState.New:
case MyObjectState.Modified:
switch (MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.SaveConfirm))
{
case DialogResult.Yes:
dgvFeeTypes.EndEdit();
bindingFeeTypes.EndEdit();
try
{
feetype.Save(true);
bindingFeeTypes.ResetCurrentItem();
rtnValue = true;
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.SaveError, ex);
rtnValue = false;
}
break;
case DialogResult.No:
if (feetype.MyState == MyObjectState.New)
{
bindingFeeTypes.RemoveCurrent();
bindingFeeTypes.ResetBindings(false);
}
else
{
feetype.Reset();
}
rtnValue = true;
break;
case DialogResult.Cancel:
rtnValue = false;
break;
}
break;
}
}
return(rtnValue);
}
private void mnuFeeType_Click(object sender, EventArgs e)
{
FeeType feetype = (FeeType)bindingFeeTypes.Current;
if (sender.Equals(mnuFeeTypeNew))
{
/********************************************************************************
* New
********************************************************************************/
if (CanChangeCurrentFeeType())
{
_GridViewState = GridViewState.Adding;
bindingFeeTypes.AddNew();
_GridViewState = GridViewState.None;
}
}
else if (sender.Equals(mnuFeeTypeRemove))
{
/********************************************************************************
* Remove
********************************************************************************/
if (DialogResult.OK == MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.RemoveConfirm))
{
try
{
bindingFeeTypes.RemoveCurrent();
bindingFeeTypes.ResetBindings(false);
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.RemoveError, ex);
}
}
}
else if (sender.Equals(mnuFeeTypeRefresh))
{
/********************************************************************************
* Refresh
********************************************************************************/
if (!feetype.MyState.Equals(MyObjectState.Current))
{
if (DialogResult.Cancel == MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.RefreshConfirm))
{
return;
}
}
try
{
feetype.Refresh();
bindingFeeTypes.ResetBindings(false);
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.RefreshError, ex);
}
}
else if (sender.Equals(mnuFeeTypeSave))
{
/********************************************************************************
* Save
********************************************************************************/
dgvFeeTypes.EndEdit();
bindingFeeTypes.EndEdit();
try
{
feetype.Save(true);
bindingFeeTypes.ResetBindings(false);
/*
*
*
* will need to come up with better sorting when this form is updated.
*
*
*
*
*/
bindingFeeTypes.Sort = "";
if (dgvFeeTypes.SortOrder == SortOrder.Descending)
{
bindingFeeTypes.Sort = dgvFeeTypes.SortedColumn.DataPropertyName + " DESC";
}
else
{
bindingFeeTypes.Sort = dgvFeeTypes.SortedColumn.DataPropertyName + " ASC";
}
ResetDataGridViewFeeType(feetype);
}
catch (MyException ex)
{
MyMessageBox.Show(this, "Fee Type", MyDisplayMessage.SaveError, ex);
}
}
else if (sender.Equals(mnuFeeTypeCancel))
{
/********************************************************************************
* Cancel
********************************************************************************/
if (feetype.MyState == MyObjectState.New)
{
bindingFeeTypes.RemoveCurrent();
}
else
{
feetype.Reset();
bindingFeeTypes.ResetCurrentItem();
}
}
}
