public ActionResult PaidBillEdit(tblBill bill) { if (ModelState.IsValid) { tblPaidBillModel model = new tblPaidBillModel(); model.Bid = bill.Bid; model.PaymentAmount1 = bill.PaymentAmount1; model.PaymentAmount2 = bill.PaymentAmount2; model.PaymentDate1 = bill.PaymentDate1; model.PaymentDate2 = bill.PaymentDate2; model.Monthcharge = bill.Monthcharge; model.Balance = bill.Balance; _db.Entry(bill).State = EntityState.Modified; _db.SaveChanges(); var result = _objReg.PaidBill(model); return(RedirectToAction("Dashboard", "Admin")); } return(View(bill)); }
public async Task <ProjectResult> ApprovalRequest(int id) { string OperatorCode = GenerateRandomChar() + Convert.ToString(GenerateRandomNo()); tblAdminRegistration _objAdmin = _db.tblAdminRegistrations.Find(id); try { var result = _db.tblAdminRegistrations.Where(psd => psd.OperatorCode == OperatorCode).ToList(); if (result.Count == 0) { _objAdmin.SkyStatus = 1; _objAdmin.OperatorCode = OperatorCode; _db.Entry(_objAdmin).State = EntityState.Modified; _db.SaveChanges(); } else { OperatorCode = GenerateRandomChar() + Convert.ToString(GenerateRandomNo()); _objAdmin.SkyStatus = 1; _objAdmin.OperatorCode = OperatorCode; _db.Entry(_objAdmin).State = EntityState.Modified; _db.SaveChanges(); } return(new ProjectResult { Message = "Success", Status = 1, Response = "Success" }); } catch (Exception exp) { return(new ProjectResult { Message = exp.ToString(), Status = 0, Response = null }); } }
public async Task <ProjectResult> PaidBill(tblPaidBillModel model) { try { if (ModelState.IsValid) { // var result = _db.tblBills.Where(psd=>psd.CustId==model.CustId).FirstOrDefault(); using (CableApiAndroidEntity _db = new CableApiAndroidEntity()) { tblBill _objBill = (from psd in _db.tblBills.Where(psd => psd.Bid == model.Bid) select psd).FirstOrDefault(); tblCustomerRegistration _objCust = (from psd in _db.tblCustomerRegistrations.Where(psd => psd.CustId == _objBill.CustId) select psd).FirstOrDefault(); if (model.PaymentAmount2 != 0 && model.PaymentDate2 != "") { //_objBill.PaymentAmount1 = model.PaymentAmount1; //_objBill.PaymentDate1 = model.PaymentDate1; _objBill.PaymentAmount2 = model.PaymentAmount2; _objBill.PaymentDate2 = model.PaymentDate2; _objBill.Balance = model.Balance; _objBill.Bid = model.Bid; } else { _objBill.PaymentAmount1 = model.PaymentAmount1; _objBill.PaymentDate1 = model.PaymentDate1; _objBill.PaymentAmount2 = 0; _objBill.PaymentDate2 = ""; _objBill.Balance = model.Balance; _objBill.Bid = model.Bid; } if (model.PaymentAmount1 != 0 && model.PaymentAmount2 == 0) { //_objBill.Balance = (model.Monthcharge-model.PaymentAmount1); _objCust.OldBal = model.Balance; } else { //_objBill.Balance = (model.Monthcharge - (model.PaymentAmount2 + model.PaymentAmount1)); _objCust.OldBal = model.Balance; } _db.Entry(_objBill).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); _db.Entry(_objCust).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); return(new ProjectResult { Message = "Success", Status = 1, Response = _objBill }); } } else { return(new ProjectResult { Message = "Failed", Status = 0, Response = null }); } } catch (Exception exp) { return(new ProjectResult { Message = exp.ToString(), Status = 0, Response = null }); } }
public async Task <ProjectResult> AdminRegistration(tblAdminRegistration model) { try { var result1 = _db.tblAdminRegistrations.Where(a => a.UserId == model.UserId && a.Password == model.Password && a.IMEINo == model.IMEINo).ToList(); if (result1.Count != 0) { return(new ProjectResult { Message = "User Already Exist", Status = 2, Response = result1 }); } else { model.SkyStatus = 0; var result = _db.tblAdminRegistrations.Max(psd => psd.RegId); if (result == null) { result = 0; } model.RegId = (result.Value) + 1; tblAdminRegistration _objAdmin = new tblAdminRegistration(); if (ModelState.IsValid) { _objAdmin.RegId = model.RegId; _objAdmin.Name = model.Name; _objAdmin.Address = model.Address; _objAdmin.City = model.City; _objAdmin.Email = model.Email; _objAdmin.MobileNo = model.MobileNo; _objAdmin.UserId = model.UserId; _objAdmin.Password = model.Password; _objAdmin.Pin = model.Pin; _objAdmin.NoOfAgent = model.NoOfAgent; //_objAdmin.RegDate = model.RegDate; _objAdmin.RegDate = System.DateTime.Now.Date; _objAdmin.SkyStatus = model.SkyStatus; _objAdmin.IMEINo = model.IMEINo; _objAdmin.OperatorCode = model.OperatorCode; _db.tblAdminRegistrations.Add(_objAdmin); _db.SaveChanges(); return(new ProjectResult { Message = "Success", Status = 1, Response = _objAdmin }); } else { return(new ProjectResult { Message = "No data found", Status = 0, Response = null }); } } } catch (Exception ex) { return(new ProjectResult { Message = ex.ToString(), Status = 0, Response = null }); } }