public List <Billing_Item> GetBillingItemDetails()
{
BillingDbContextBll db = new BillingDbContextBll();
List <Billing_Item> billDetails = new List <Billing_Item>();
billDetails = db.BillingItem.ToList();
return(billDetails);
}
public Billing_Item GetBillItemDetailsBasedOnId(int itemId)
{
Billing_Item billingItem = new Billing_Item();
BillingDbContextBll db = new BillingDbContextBll();
billingItem = db.BillingItem.FirstOrDefault(a => a.ItemID == itemId);
return(billingItem);
}
public void DeleteBillItemDetailsBasedOnId(int itemId)
{
Billing_Item billingItem = new Billing_Item();
BillingDbContextBll db = new BillingDbContextBll();
billingItem = db.BillingItem.FirstOrDefault(a => a.ItemID == itemId);
db.Entry(billingItem).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
public void UpdateServiceDB()
{
BillingDbContextBll context = new BillingDbContextBll();
if (!context.Database.Exists())
{
var migrate = new DbMigrator(new BillingDbContextConfiguration());
migrate.Update();
}
}
public void SaveItemMasterDetails(Billing_Item billingItem)
{
BillingDbContextBll db = new BillingDbContextBll();
if (billingItem.ItemID == 0)
{
db.Entry(billingItem).State = System.Data.Entity.EntityState.Added;
}
else
{
db.Entry(billingItem).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
