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()));
}
