public ActionResult DeletePassedOnBilling(int idToDelete, FormCollection frm) { var id = frm[0].ToString(); int CompanyId = int.Parse(id); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; PassedOnBillingInformation passedOnBillingInformation = new PassedOnBillingInformation(); passedOnBillingInformation = db.PassedOnBillingInformation.Find(idToDelete); db.PassedOnBillingInformation.Remove(passedOnBillingInformation); db.SaveChanges(); PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); try { passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Delete Record -from Terminal:" + ipaddress); } catch (Exception) { passedonBillingViewModels.TotalAmount = 0; } ViewBag.CompanySelected = "OK"; passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); TempData["TransactionSuccess"] = "delete"; TempData["PassedOnBillingData"] = passedonBillingViewModels; return(RedirectToAction("ViewPassedOnBillingPRG", "DataEntryPassedOnBilling")); }
public ActionResult DisplayPassedOnBilling(int CompId, FormCollection frmcollection) { PassedOnBillingViewModel searchcompany = new PassedOnBillingViewModel(); searchcompany.ZoneList = db.Zone.Select(x => x).ToList(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; PassedOnBillingViewModel SearchCompanyViewModels = new PassedOnBillingViewModel(); if (frmcollection.Count == 0) { SearchCompanyViewModels.PassedOnBillingList = db.PassedOnBillingInformation.SqlQuery("Select * from SecurityGuardFeeInformations where CompanyId = '" + frmcollection["CompanyId"] + "'").ToList(); SearchCompanyViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).Sum(x => x.Amount); return(View(SearchCompanyViewModels)); } else if (frmcollection.Count >= 1) { PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); int parsedID = int.Parse(frmcollection["PassedOnBillingInformationId"]); PassedOnBillingInformation securityfee = db.PassedOnBillingInformation.Find(parsedID); //db.PassedOnBillingInformation.Remove(securityfee); //db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompId).Sum(x => x.Amount); return(View("ViewPassedOnBilling", passedonBillingViewModels)); } ViewBag.CompanySelected = "OK"; //SearchCompanyViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); SearchCompanyViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = SearchCompanyViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); SearchCompanyViewModels.BillingPeriodList = billp.ToList(); return(View()); }
public void ProcessRequest(HttpContext context) { var a = context.Request.QueryString["Copy"].ToString(); var b = context.Request.QueryString["Type"].ToString(); var origin = context.Request.QueryString["Origin"].ToString(); var billing = context.Request.QueryString["Billing"].ToString(); DateTime originNew = Convert.ToDateTime(origin); DateTime billingNew = Convert.ToDateTime(billing); HttpFileCollection files = context.Request.Files; HttpPostedFile file = files["uploadData"]; int copy = int.Parse(a); BCS_Context db = new BCS_Context(); if ((file != null) && (file.ContentLength > 0) && (!string.IsNullOrEmpty(file.FileName))) { using (var dbtransaction = db.Database.BeginTransaction()) { try { ApplicationDbContext con = new ApplicationDbContext(); //db.PassedOnBillingInformation.RemoveRange(db.PassedOnBillingInformation) var userid = System.Web.HttpContext.Current.User.Identity.GetUserId(); var zonegroup = con.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; SearchCompanyPerGroup searchCompanyPerGroup = new SearchCompanyPerGroup(zonegroup); IEnumerable <Company> company = searchCompanyPerGroup.Companies; using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 12; rowIterator <= noOfRow; rowIterator++) { var compid = workSheet.Cells[rowIterator, 3].Value; var newCompId = int.Parse(compid.ToString()); Company comp = company.Where(m => m.CompanyID == newCompId).FirstOrDefault(); var type = workSheet.Cells[rowIterator, 12].Value.ToString() != null ? workSheet.Cells[rowIterator, 12].Value.ToString() : ""; if (type == b) { PassedOnBillingInformation passedOnBillingInformation = new PassedOnBillingInformation(); passedOnBillingInformation.Type = type; var cid = workSheet.Cells[rowIterator, 3].Value != null ? workSheet.Cells[rowIterator, 3].Value : 0; passedOnBillingInformation.CompanyId = int.Parse(cid.ToString()); passedOnBillingInformation.BillingPeriod = int.Parse(a); var amt = workSheet.Cells[rowIterator, 13].Value != null ? workSheet.Cells[rowIterator, 13].Value : 0; passedOnBillingInformation.Amount = decimal.Parse(amt.ToString()); passedOnBillingInformation.CreatedBy = userid; passedOnBillingInformation.CreateDate = DateTime.Now; passedOnBillingInformation.OriginDate = originNew; passedOnBillingInformation.BillingDate = billingNew; passedOnBillingInformation.Remarks = workSheet.Cells[rowIterator, 14].ToString(); db.PassedOnBillingInformation.Add(passedOnBillingInformation); db.SaveChanges(); } } } dbtransaction.Commit(); } catch (Exception ex) { var error = ex.Message; dbtransaction.Rollback(); } } } }
public ActionResult AddPassedOnBilling(int CompanyId, Decimal Amount, DateTime OriginDateAdd, DateTime BillingDateAdd, int BillingPeriod, string Type, string isEdit, string PassedOnBillingInfoId) { PassedOnBillingViewModel searchcompany = new PassedOnBillingViewModel(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.FirstOrDefault(m => m.Id == userid).ZoneGroup; var username = User.Identity.GetUserName(); RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username); ViewBag.IsValidRole = roleAssignmentMatrix.PassedOnBilling; //SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry PassOnBilling) - from Terminal:" + ipaddress); PassedOnBillingInformation passedonBillingInfo = null; passedonBillingInfo = db.PassedOnBillingInformation.Find(CompanyId); if (isEdit != "Edit") { PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); PassedOnBillingInformation passedonBillingAssignment = new PassedOnBillingInformation(); passedonBillingViewModels.ZoneList = db.Zone.Select(x => x).ToList(); passedonBillingAssignment.CompanyId = CompanyId; passedonBillingAssignment.Amount = Amount; passedonBillingAssignment.Type = Type; passedonBillingAssignment.OriginDate = OriginDateAdd; passedonBillingAssignment.BillingDate = BillingDateAdd; passedonBillingAssignment.CreateDate = DateTime.Now; passedonBillingAssignment.CreatedBy = userid; passedonBillingAssignment.BillingPeriod = BillingPeriod; db.PassedOnBillingInformation.Add(passedonBillingAssignment); db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); //passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); //return View("ViewSecurityGuardFee", SearchSecurityGuardFeeViewModels); TempData["TransactionSuccess"] = "Add"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Add -from Terminal:" + ipaddress); TempData["PassedOnBillingData"] = passedonBillingViewModels; } else { int passedonbillingid = Convert.ToInt32(PassedOnBillingInfoId); passedonBillingInfo = db.PassedOnBillingInformation.FirstOrDefault(m => m.PassedOnBillingInformationId == passedonbillingid); PassedOnBillingViewModel passedonBillingViewModels = new PassedOnBillingViewModel(); passedonBillingViewModels.ZoneList = db.Zone.Select(x => x).ToList(); passedonBillingInfo.Amount = Amount; passedonBillingInfo.OriginDate = OriginDateAdd; passedonBillingInfo.BillingDate = BillingDateAdd; passedonBillingInfo.BillingPeriod = BillingPeriod; passedonBillingInfo.Type = Type; passedonBillingInfo.UpdatedBy = userid; passedonBillingInfo.UpdateDate = DateTime.Now; db.Entry(passedonBillingInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); passedonBillingViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList(); passedonBillingViewModels.PassedOnBillingList = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).ToList(); passedonBillingViewModels.TotalAmount = db.PassedOnBillingInformation.Where(m => m.CompanyId == CompanyId).Sum(x => x.Amount); ViewBag.CompanySelected = "OK"; //passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).Where(m => m.Finalized.ToUpper() != "YES").ToList(); passedonBillingViewModels.BillingPeriodList = db.BillingPeriod.Where(x => x.groupCode == ZoneGroup).ToList(); var billp = passedonBillingViewModels.BillingPeriodList.OrderByDescending(m => m.BillingPeriodId); passedonBillingViewModels.BillingPeriodList = billp.ToList(); TempData["TransactionSuccess"] = "Edit"; SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Passed OnBilling - Edit -from Terminal:" + ipaddress); TempData["PassedOnBillingData"] = passedonBillingViewModels; } return(RedirectToAction("ViewPassedOnBillingPRG", "DataEntryPassedOnBilling")); }