public void Save(BillHead head)
{
Helpers.NonQueryHelper.Insert(head, "spBillInsert", 1);
try
{
SetId();//get max id from billhead
}
catch (Exception ex)
{
conn.Close();
MessageBox.Show(ex.ToString());
}
}
public void SetPurposeId(BillHead head, string purposeName)
{
head.BillPurposeID = Helpers.ReaderHelper.SelectId("select id from billpurpose where name = '" + purposeName + "'");
}
public void SetCategoryId(BillHead head, string categoryName)
{
head.BillCategoryID = Helpers.ReaderHelper.SelectId("select id from billcategory where name = '" + categoryName + "'");
}
public void SetStoreId(BillHead head, string storeName)
{
head.StoreID = Helpers.ReaderHelper.SelectId("select id from store where name = '" + storeName + "'");
}