public void Delete(BillPurpose billPurp)
{
try
{
Helpers.NonQueryHelper.DeleteOnId("spBillPurpose", 4, billPurp.Id);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void Update(BillPurpose billPurp)
{
try
{
Helpers.NonQueryHelper.Update(billPurp, "spBillPurpose", 3);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void Save(BillPurpose billPurp)
{
try
{
Helpers.NonQueryHelper.Insert(billPurp, "spBillPurpose", 2);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void SetStatusId(BillPurpose billPurp, string statusName)
{
billPurp.StatusID = Helpers.ReaderHelper.SelectId("select id from status where name = '" + statusName + "'");
}