public async Task <IActionResult> AdjustmentRecordDelete(string id) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; AdjustmentRecord adjustmentRecordToBeDeleted = _context.AdjustmentRecord.FirstOrDefault(x => x.VoucherNo == id); _context.AdjustmentRecord.Remove(adjustmentRecordToBeDeleted); _context.SaveChanges(); b.RemoveRecordDetails(id); AdjustmentRecord ar = _context.AdjustmentRecord.FirstOrDefault(x => x.ClerkId == userID && !x.VoucherNo.Contains("Vtemp")); List <AdjustmentRecord> tempAdjustmentRecords = new List <AdjustmentRecord>(); List <AdjustmentRecordViewModel> arViewModelList = new List <AdjustmentRecordViewModel>(); if (ar != null) { tempAdjustmentRecords = _context.AdjustmentRecord.Where(x => x.ClerkId == userID && !x.VoucherNo.Contains("Vtemp") && x.Status == "Draft").OrderByDescending(x => x.VoucherNo).ToList(); arViewModelList = b.CreateAdjustmentRecordViewModel(tempAdjustmentRecords); } else { NotFound(); } return(PartialView("_TempAdjustmentRecords", arViewModelList)); }
public async Task <IActionResult> RequestItemDelete(string itemNumber) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; //Viewbag for category dropdown list, need to post back List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; var deleteItem = tempNewRequests.FirstOrDefault(x => x.ItemNumber == itemNumber); tempNewRequests.Remove(deleteItem); if (tempNewRequests == null) { tempNewRequests = new List <TempNewRequest>(); } return(PartialView("_TempNewRequest", tempNewRequests)); }
public List <string> checkUserIdentityAsync(ADTeam5User user) { List <string> result = new List <string>(); int workID = user.WorkID; //var users = from m in _context.User // select m; var users = _context.User.FirstOrDefault(s => s.UserId == workID); if (users == null) { result.Add("NoWork"); result.Add("NoJob"); return(result); } string department = users.DepartmentCode; result.Add(department); var roles = from m in _context.Department select m; roles = roles.Where(s => s.DepartmentCode == department); Department depm = roles.First(); if (depm.DepartmentCode == "STAS")//this part should add the store code { if (depm.HeadId == workID) { result.Add("Manager"); } else if (depm.RepId == workID) { result.Add("Superviser"); } else { result.Add("Clerk"); } } else { if (depm.HeadId == workID) { result.Add("Head"); } else if (depm.RepId == workID) { result.Add("Rep"); } else if (depm.CoveringHeadId == workID) { result.Add("CoveringHead"); } else { result.Add("Employee"); } } return(result); }
// GET: DisbursementLists public async Task <IActionResult> Index() { ViewData["InsufficientCheck"] = null; ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; ViewData["Department"] = identity[0]; ViewData["role"] = identity[1]; //Generate disbursement list List <Models.Department> dList = _context.Department.ToList(); List <string> depCodeList = new List <string>(); foreach (Models.Department d in dList) { depCodeList.Add(d.DepartmentCode); } for (int i = 0; i < depCodeList.Count(); i++) { List <RecordDetails> rd = b.GenerateRecordDetailsOfDisbursementList(depCodeList[i]); } var sSISTeam5Context = _context.DisbursementList.Include(d => d.CollectionPointNavigation).Include(d => d.DepartmentCodeNavigation).Include(d => d.RepNavigation).OrderByDescending(x => x.Dlid); return(View(await sSISTeam5Context.ToListAsync())); }
public async Task <IActionResult> POItemDelete(int id) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //Viewbag for category dropdown list, need to post back List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; List <TempPurchaseOrderDetails> tempPurchaseOrderDetailsList1 = b.GetTempPurchaseOrderDetailsList(); b.DeletePOItem(id, tempPurchaseOrderDetailsList1); List <TempPurchaseOrderDetails> tempPurchaseOrderDetailsList = b.GetTempPurchaseOrderDetailsList(); if (tempPurchaseOrderDetailsList == null) { tempPurchaseOrderDetailsList = new List <TempPurchaseOrderDetails>(); } return(PartialView("_TempPurchaseOrderDetailsList", tempPurchaseOrderDetailsList)); }
// GET: IssueVoucher public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; List <TempVoucherDetails> tempVoucherDetailsList = b.GetTempVoucherDetailsList(userID); List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; List <Catalogue> itemNameList = new List <Catalogue>(); itemNameList = (from x in _context.Catalogue select x).ToList(); itemNameList.Insert(0, new Catalogue { ItemNumber = "0", ItemName = "---Select Item---" }); ViewBag.ListofItemName = itemNameList; return(View(tempVoucherDetailsList)); }
// GET: PurchaseOrderRecords public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; PurchaseOrderRecord purchaseOrderRecord = _context.PurchaseOrderRecord.FirstOrDefault(x => !x.Poid.Contains("POTemp")); List <PurchaseOrderRecord> poList = new List <PurchaseOrderRecord>(); if (purchaseOrderRecord != null) { poList = _context.PurchaseOrderRecord.Where(x => !x.Poid.Contains("POTemp")).OrderByDescending(x => x.Poid).ToList(); //foreach (var q in poList) //{ // var p = _context.RecordDetails.FirstOrDefault(x => x.Rrid == q.Poid); // if(p == null) // { // b.RemovePORecord(q.Poid); // } //} } else { NotFound(); } return(View(poList)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; Models.Department d1 = b.getDepartmentDetails(dept); if (d1.CoveringHeadId != null) { edit = true; currentDeputyHeadId = (int)d1.CoveringHeadId; string name = b.getCurrentDeputyHeadName(currentDeputyHeadId); ViewData["CurrentDeputyHead"] = name; Models.DepartmentCoveringHeadRecord d2 = b.findCurrentDeputyHeadToEdit(currentDeputyHeadId); ViewData["CurrentDeputyHeadStartDate"] = d2.StartDate.ToShortDateString(); ViewData["CurrentDeputyHeadEndDate"] = d2.EndDate.ToShortDateString(); } List <User> userList = new List <User>(); Models.Department d = b.getDepartmentDetails(dept); int repid = d.RepId; int headid = d.HeadId; userList = b.populateAssignDeputyDropDownList(dept, repid, headid); ViewBag.listofitems = userList; return(View()); }
// GET: IssueVoucher public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //b.AddReorderLevelItemToTempPurchaseOrderDetailsList(); List <TempPurchaseOrderDetails> tempPurchaseOrderDetails = b.GetTempPurchaseOrderDetailsList(); //Viewbag for catagory List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "" }); ViewBag.ListofCategory = categoryList; return(View(tempPurchaseOrderDetails)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; var q1 = b.findDisbursementListStatus(dept); DisbursementList d1 = q1; int currentCollectionPoint = d1.CollectionPointId; var q2 = b.findCollectionPointToEdit(currentCollectionPoint); CollectionPoint c1 = q2; string currentName = c1.CollectionPointName; ViewData["Name"] = currentName; List <CollectionPoint> u = new List <CollectionPoint>(); u = context.CollectionPoint.Where(x => x.CollectionPointId != currentCollectionPoint).ToList(); ViewBag.listofitems = u; return(View()); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; List <Catalogue> catalogueList = new List <Catalogue>(); catalogueList = (from x in context.Catalogue select x).ToList(); catalogueList.Insert(0, new Catalogue { ItemNumber = "0", ItemName = "Select" }); ViewBag.ListofCatalogueName = catalogueList; if (ItemNumberList.Count > 0) { ViewBag.ItemNameList = ItemNameList; ViewBag.QuantityList = QuantityList; ViewData["SubmitButton"] = true; } else { ViewData["SubmitButton"] = null; } return(View()); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; Models.Department d1 = b.getDepartmentDetails(dept); int currentRepId = d1.RepId; Models.User u1 = b.getUser(currentRepId); string currentRepName = u1.Name; ViewData["CurrentRepName"] = currentRepName; List <User> u = new List <User>(); Models.Department d = b.getDepartmentDetails(dept); int repid = d.RepId; int headid = d.HeadId; int coverheadid = 0; if (d.CoveringHeadId != null) { coverheadid = (int)d.CoveringHeadId; } u = b.populateAssignDepartmentDropDownList(dept, repid, headid, coverheadid); ViewBag.listofitems = u; return(View()); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; var q = from x in context.EmployeeRequestRecord join s in context.User on x.DepEmpId equals s.UserId where x.DepCode.Equals(dept) select new DepartmentRequest { Rrid = x.Rrid, RequestDate = x.RequestDate, EmployeeName = s.Name, Status = x.Status }; List <DepartmentRequest> list = q.ToList(); return(View(list)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //Generate disbursement list List <Models.Department> dList = _context.Department.ToList(); List <string> depCodeList = new List <string>(); foreach (Models.Department d in dList) { depCodeList.Add(d.DepartmentCode); } for (int i = 0; i < depCodeList.Count(); i++) { List <RecordDetails> rd = b.GenerateRecordDetailsOfDisbursementList(depCodeList[i]); } List <StationeryRetrievalList> result = b.GetStationeryRetrievalLists(); return(View(result)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "" }); ViewBag.ListofCategory = categoryList; //List<Catalogue> itemNameList = new List<Catalogue>(); //itemNameList = (from x in _context.Catalogue select x).ToList(); //itemNameList.Insert(0, new Catalogue { ItemNumber = "0", ItemName = "---Select Item---" }); //ViewBag.ListofItemName = itemNameList; return(View(tempNewRequests)); }
public async Task <IActionResult> Index(string[] itemSubmitted) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; dept = identity[0]; role = identity[1]; if (itemSubmitted.Length != 0) { rrid = b.IDGenerator(dept); foreach (var item in tempNewRequests) { if (Array.Exists(itemSubmitted, i => i == item.ItemNumber.ToString())) { //add items to request RecordDetails r = new RecordDetails(); r.Rrid = rrid; r.ItemNumber = item.ItemNumber; r.Quantity = item.Quantity; r.QuantityDelivered = 0; _context.RecordDetails.Add(r); _context.SaveChanges(); } } //check if item exists in record details var record = _context.RecordDetails.FirstOrDefault(x => x.Rrid == rrid); if (record != null) { // Make new EmployeeRequestRecord EmployeeRequestRecord e = new EmployeeRequestRecord(); DateTime requestDate = DateTime.Now.Date; int empId = userid; var findHeadId = _context.Department.Where(x => x.DepartmentCode == dept).First(); int headId = findHeadId.HeadId; string deptCode = dept; string status = "Pending Approval"; e.Rrid = rrid; e.RequestDate = requestDate; e.DepEmpId = empId; e.DepHeadId = headId; e.DepCode = deptCode; e.Status = status; _context.EmployeeRequestRecord.Add(e); _context.SaveChanges(); TempData["Submitted"] = "New request has been created successfully!"; } } tempNewRequests = new List <TempNewRequest>(); List <RecordDetails> rdList = _context.RecordDetails.Where(x => x.Rrid == rrid).ToList(); //return RedirectToAction("Details", new { id = rrid }); return(Json(new { redirecturl = "NewRequest/Details/" + rrid })); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; return(View()); }
// GET: DisbursementLists public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); ViewData["Department"] = identity[0]; ViewData["role"] = identity[1]; var sSISTeam5Context = _context.DisbursementList.Include(d => d.CollectionPointNavigation).Include(d => d.DepartmentCodeNavigation).Include(d => d.RepNavigation); return(View(await sSISTeam5Context.ToListAsync())); }
//[Route("AdjustmentRecords/Details/{id?}")] public async Task <IActionResult> VoucherItemDelete(string id, int rdid) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //string voucherNo = _context.RecordDetails.FirstOrDefault(x => x.Rdid == rdid).Rrid; List <AdjustmentRecordDetails> adjustmentRecordDetailsList = new List <AdjustmentRecordDetails>(); if (id != null) { List <AdjustmentRecordDetails> adjustmentRecordDetailsList1 = b.GetAdjustmentRecordDetails(id); b.DeleteVoucherItem(rdid, adjustmentRecordDetailsList1); adjustmentRecordDetailsList = b.GetAdjustmentRecordDetails(id); } if (adjustmentRecordDetailsList == null) { adjustmentRecordDetailsList = new List <AdjustmentRecordDetails>(); } //ViewData for voucherNo ViewData["VoucherNo"] = id; //ViewBag for voucher price decimal?amount = b.GetTotalAmountForVoucher(id); decimal?GST = Math.Round((decimal)(amount * (decimal?)0.07), 2); ViewBag.Amount = amount; ViewBag.GST = GST; ViewBag.TotalAmount = amount + GST; List <AdjustmentRecordDetails> result = b.GetAdjustmentRecordDetails(id); //Viewbag for category dropdown list, need to post back List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; //ViewBag for record status ViewBag.AdjustmentRecordStatus = _context.AdjustmentRecord.FirstOrDefault(x => x.VoucherNo == id).Status; return(PartialView("_TempDetails", adjustmentRecordDetailsList)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; var q = context.EmployeeRequestRecord.Where(x => x.DepCode == dept && x.DepEmpId == userid).OrderByDescending(x => x.Rrid); return(View(q)); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); ViewData["UserRole"] = identity[1]; switch (ViewData["UserRole"].ToString()) { case "Manager": return(RedirectToAction("Index", "AdjustmentRecords")); break; case "Supervisor": return(RedirectToAction("Index", "AdjustmentRecords")); break; case "Clerk": return(RedirectToAction("Index", "PurchaseOrderRecords")); break; case "Head": return(RedirectToAction("Index", "OutstandingOrder")); break; case "Rep": return(RedirectToAction("Index", "Catalogues")); break; case "CoveringHead": return(RedirectToAction("Index", "OutstandingOrder")); break; case "Employee": return(RedirectToAction("Index", "NewRequest")); break; } return(View()); }
public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; List <DisbursementList> dbList = b.findDisbursementListStatusComplete(dept); decimal sum = b.findTotalExpenditure(dept, dbList); @ViewData["Sum"] = sum; return(View(dbList)); }
//Stationery usage public async Task <IActionResult> StationeryUsage() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; List <StationeryUsageViewModel> stationeryUsageViewModels = b.GetStationeryUsage("Completed"); if (stationeryUsageViewModels.Count != 0) { //Viewbag for year and month dropdownlist, need to post back List <int> years = new List <int>(); List <int> months = new List <int>() { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }; var q = stationeryUsageViewModels.GroupBy(x => new { x.Year }).Select(y => new { year = y.Key.Year }); foreach (var item in q.ToList()) { years.Add(item.year); } ViewBag.ListOfYear = years; ViewBag.ListOfMonth = months; //Viewbag for department dropdownlist, need to post back var departments = _context.Department.ToList(); if (departments.Count != 0) { ViewBag.ListOfDepartment = departments.Select(x => new Department { DepartmentName = x.DepartmentName, DepartmentCode = x.DepartmentCode }); } //Viewbag for category dropdownlist, need to post back List <string> categories = new List <string>(); var p = stationeryUsageViewModels.GroupBy(x => new { x.Category }).Select(y => new { category = y.Key.Category }); foreach (var item in p.ToList()) { categories.Add(item.category); } ViewBag.ListOfCategory = categories; } return(View()); }
public async Task <IActionResult> POItemDelete(string poid, int id) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //Viewbag for category dropdown list, need to post back List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; List <PurchaseOrderRecordDetails> purchaseOrderDetailsList1 = b.GetPurchaseOrderRecordDetails(poid); b.DeletePOItem(id, purchaseOrderDetailsList1); List <PurchaseOrderRecordDetails> purchaseOrderDetailsList = b.GetPurchaseOrderRecordDetails(poid); //ViewBag for voucher price decimal?amount = b.GetTotalAmountForPO(poid); decimal?GST = Math.Round((decimal)(amount * (decimal?)0.07), 2); ViewBag.Amount = amount; ViewBag.GST = GST; ViewBag.TotalAmount = amount + GST; ViewBag.POStatus = _context.PurchaseOrderRecord.Find(poid).Status; if (purchaseOrderDetailsList.Count == 0) { purchaseOrderDetailsList = new List <PurchaseOrderRecordDetails>(); return(Redirect("/PurchaseOrderRecords")); } else { return(View("Details", purchaseOrderDetailsList)); } }
public async Task <IActionResult> Index(string itemNumber, int quantityRetrieved, int quantityForVoucher, string remark, int quantityRetrievedModalName, int addToVoucherModalName) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; if (itemNumber == null) { return(NotFound()); } if (addToVoucherModalName == 1) { if (quantityForVoucher == 0) { TempData["QuantityError"] = "Please select a quantity to add to voucher. Quantity cannot be 0."; return(RedirectToAction("Index")); } else { b.CreateNewVoucherItem(userID, itemNumber, quantityForVoucher, remark); } } else if (quantityRetrievedModalName == 1) { var stockCheck = _context.Catalogue.Where(x => x.ItemNumber == itemNumber).FirstOrDefault(); int stockAmt = stockCheck.Stock + stockCheck.Out; if (quantityRetrieved > stockAmt) { TempData["InsufficientStock"] = "Stock level: " + stockAmt + ". There is insufficient stock. Please select a quantity less than or equals to stock level."; } else { b.UpdateCatalogueOutAndStockAfterRetrieval(itemNumber, quantityRetrieved); } } List <StationeryRetrievalList> result = b.GetStationeryRetrievalLists(); return(View(result)); }
//[ActionName("VoucherItemDelete"), Route("~/IssueVoucher")] public async Task <IActionResult> VoucherItemDelete(int id) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; //Viewbag for category dropdown list, need to post back List <Catalogue> categoryList = new List <Catalogue>(); var q = _context.Catalogue.GroupBy(x => new { x.Category }).Select(x => x.FirstOrDefault()); foreach (var item in q) { categoryList.Add(item); } categoryList.Insert(0, new Catalogue { ItemNumber = "0", Category = "---Select Category---" }); ViewBag.ListofCategory = categoryList; List <TempVoucherDetails> tempVoucherDetailsList1 = b.GetTempVoucherDetailsList(userID); b.DeleteVoucherItem(id, tempVoucherDetailsList1); List <TempVoucherDetails> tempVoucherDetailsList = b.GetTempVoucherDetailsList(userID); if (tempVoucherDetailsList.Count == 0) { tempVoucherDetailsList = new List <TempVoucherDetails>(); } //ViewBag for voucher price string tempVoucherNo = "VTemp" + userID; decimal?amount = b.GetTotalAmountForVoucher(tempVoucherNo); decimal?GST = Math.Round((decimal)(amount * (decimal?)0.07), 2); ViewBag.Amount = amount; ViewBag.GST = GST; ViewBag.TotalAmount = amount + GST; return(PartialView("_TempVoucherDetailsList", tempVoucherDetailsList)); }
public async Task <IActionResult> Index(string departmentName, DateTime estDeliverDate, int changeEstDeliverDateModalName) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; if (departmentName == null) { return(NotFound()); } if (changeEstDeliverDateModalName == 1) { b.ChangeEstDeliverDate(departmentName, estDeliverDate); } var sSISTeam5Context = _context.DisbursementList.Include(d => d.CollectionPointNavigation).Include(d => d.DepartmentCodeNavigation).Include(d => d.RepNavigation).OrderByDescending(x => x.Dlid); return(View(sSISTeam5Context)); }
public async Task <IActionResult> OnPostAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); if (ModelState.IsValid) { var user = new ADTeam5User { UserName = Input.Email, Email = Input.Email }; var result = await _userManager.CreateAsync(user, Input.Password); if (result.Succeeded) { _logger.LogInformation("User created a new account with password."); var code = await _userManager.GenerateEmailConfirmationTokenAsync(user); var callbackUrl = Url.Page( "/Account/ConfirmEmail", pageHandler: null, values: new { userId = user.Id, code = code }, protocol: Request.Scheme); await _emailSender.SendEmailAsync(Input.Email, "Confirm your email", $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>."); await _signInManager.SignInAsync(user, isPersistent : false); return(LocalRedirect(returnUrl)); } foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } // If we got this far, something failed, redisplay form return(Page()); }
public async Task <IActionResult> PurchaseOrderRecordDelete(string id) { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; b.RemoveRecordDetails(id); b.RemovePORecord(id); var q = _context.PurchaseOrderRecord.Where(x => !x.Poid.Contains("POTemp")); List <PurchaseOrderRecord> tempPurchaseOrderRecords = new List <PurchaseOrderRecord>(); if (q != null) { tempPurchaseOrderRecords = q.OrderByDescending(x => x.Poid).ToList(); } else { tempPurchaseOrderRecords = new List <PurchaseOrderRecord>(); } return(PartialView("_TempPurchaseOrderRecords", tempPurchaseOrderRecords)); }
// GET: Catalogues public async Task <IActionResult> Index() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); userid = user.WorkID; List <string> identity = userCheck.checkUserIdentityAsync(user); dept = identity[0]; role = identity[1]; if (dept == "STAS") { ViewData["ClerkRole"] = "true"; } else { ViewData["ClerkRole"] = null; } var sSISTeam5Context = _context.Catalogue.Include(c => c.Supplier1Navigation).Include(c => c.Supplier2Navigation).Include(c => c.Supplier3Navigation); return(View(await sSISTeam5Context.ToListAsync())); }