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