public async Task <ActionResult> BilingCodes() { var model = new BillingCodes(); ViewBag.BilingCodes = await _db.BillingCodes.ToListAsync(); ViewBag.BillingCategories = await _db.BillingCategories.ToListAsync(); ViewBag.BillingPeriod = await _db.BillingPeriods.ToListAsync(); return(View(model)); }
public async Task <JsonResult> AddUpdateBillingCode(BillingCodes obj) { var Exsist = await _db.BillingCategories.FirstOrDefaultAsync(x => x.Name == obj.Name); if (Exsist == null) { if (obj.Id == 0) { _db.BillingCodes.Add(obj); var save = await _db.SaveChangesAsync(); if (save > 0) { return(Json("added", JsonRequestBehavior.AllowGet)); } return(Json("error", JsonRequestBehavior.AllowGet)); } else { var billingCode = await _db.BillingCodes.FirstOrDefaultAsync(x => x.Id == obj.Id); billingCode.BillingCategoryId = obj.BillingCategoryId; //billingCode.BillingPeriodsId = obj.BillingPeriodsId; billingCode.MinimunMinutes = obj.MinimunMinutes; billingCode.Name = obj.Name; billingCode.Description = obj.Description; _db.Entry(billingCode).State = EntityState.Modified; var save = await _db.SaveChangesAsync(); if (save > 0) { return(Json("updated", JsonRequestBehavior.AllowGet)); } return(Json("error", JsonRequestBehavior.AllowGet)); } } else { return(Json("exists", JsonRequestBehavior.AllowGet)); } return(Json("", JsonRequestBehavior.AllowGet)); }