public ActionResult TimeLogReport(int weekNumber, int storesId, int years) { try { TimeLogReport report = new TimeLogReport(); var employeesTimeLogs = new List <EmployeesTimeLogsViewModel>(); var placeHolder = " ( " + GetDateFromWeekNumberAndDayOfWeek(weekNumber, years, 1).ToString("dd/MM") + " to " + GetDateFromWeekNumberAndDayOfWeek(weekNumber, years, 0).ToString("dd/MM") + " )"; ViewData["weekNumber"] = weekNumber; ViewData["storesId"] = storesId; ViewData["yearNumber"] = years; List <DateTime> weekDates = GetWeekDatesList(weekNumber, years); //get lists of employees by storesId var employeeLists = _employeeServices.GetAllEmployeesByLocation(CurrentTenantId, storesId).ToList(); var locationName = _tenantLocationsServices.GetTenantLocationById(storesId).WarehouseName; //CreateReportHeader(report, locationName); report.FindControl("xrLabel4", true).Text = $"{locationName}"; report.FindControl("xrLabel1", true).Text = $"Week {weekNumber} {placeHolder}"; report.FindControl("xrLabel3", true).Text = $"Time and Attendance @{DateTime.UtcNow.Year}"; report.FindControl("xrLabel7", true).Text = $"{DateTime.UtcNow.Date.ToString("dd/MM/yyyy")}"; if (employeeLists.Count() >= 1) { //get by employeeId and weeknumber foreach (var item in employeeLists) { employeesTimeLogs.Add(new EmployeesTimeLogsViewModel() { EmployeeId = item.ResourceId, PayrollEmployeeNo = item.PayrollEmployeeNo, FirstName = item.FirstName, SurName = item.SurName, FullName = item.Name, WeekNumber = weekNumber, EmployeeRole = item.EmployeeRoles.Count() <= 0 ? "" : item.EmployeeRoles.Where(x => x.IsDeleted != true).FirstOrDefault().Roles.RoleName, TimeLogs = TimeLogDataSource(item.ResourceId, weekNumber, storesId, years, weekDates) }); } CreateDetail(report, "FullName"); //Employees by Fullname CreateDetailReport(report, "TimeLogs"); //Lists of Timelogs report.DataSource = employeesTimeLogs; } return(View(report)); } catch (Exception e) { //log exception var err = e.Message; return(View("_EmptyResult")); } }
// GET: /Warehouse/Details/5 public ActionResult Details(int?id) { /// Authorization Check if (!caSession.AuthoriseSession()) { return(Redirect((string)Session["ErrorUrl"])); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TenantLocations tenantwarehouse = _tenantLocationServices.GetTenantLocationById((int)id); if (tenantwarehouse == null) { return(HttpNotFound()); } return(View(tenantwarehouse)); }
public PartialViewResult _AddPalletes() { int?receivedQty = 0; if (!string.IsNullOrEmpty(Request.Params["rec_qty"])) { receivedQty = int.Parse(Request.Params["rec_qty"]); } ViewBag.QuantityEnabled = true; int qty = int.Parse(Request.Params["qty"]); ViewBag.ProcessedQuantity = receivedQty; int prodId = int.Parse(Request.Params["pid"]); ViewBag.RequiredQuantity = qty - receivedQty; ViewBag.PalletPerCase = _productServices.GetProductMasterById(prodId).ProductsPerCase ?? 1; decimal caseperpallet = ((decimal)ViewBag.RequiredQuantity / (decimal?)ViewBag.PalletPerCase ?? 1); if (ViewBag.RequiredQuantity < 0) { ViewBag.RequiredQuantity = 0; } if (caseperpallet < 0) { caseperpallet = 0; } ViewBag.cases = caseperpallet; if (Request.UrlReferrer.AbsolutePath.Contains("PurchaseOrders")) { ViewBag.Locations = new SelectList(_productLookupService.GetAllValidProductLocations(CurrentTenantId, CurrentWarehouseId), "LocationId", "LocationCode"); ViewBag.QuantityEnabled = false; } if (Request.UrlReferrer.AbsolutePath.Contains("SalesOrders") || Request.UrlReferrer.AbsolutePath.Contains("WorksOrders")) { ViewBag.QuantityEnabled = false; var palletTracking = _tenantLocationServices.GetTenantLocationById(CurrentWarehouseId); if (palletTracking != null) { ViewBag.palletTracking = palletTracking.PalletTrackingScheme; ViewBag.palletTrackingId = (int)palletTracking.PalletTrackingScheme; int palletTrackingIds = (int)palletTracking.PalletTrackingScheme; if (palletTrackingIds == 3) { var date = _salesServices.GetSerialByPalletTrackingScheme(prodId, palletTrackingIds, CurrentTenantId, CurrentWarehouseId)?.ExpiryDate; if (date != null) { ViewBag.MoYy = date.Value.Day + "/" + date.Value.Month + "/" + date.Value.Year; ViewBag.expDate = date; } } if (palletTrackingIds == 4) { var date = _salesServices.GetSerialByPalletTrackingScheme(prodId, palletTrackingIds, CurrentTenantId, CurrentWarehouseId)?.ExpiryDate; if (date != null) { ViewBag.MoYy = date.Value.ToString("MMMM", CultureInfo.InvariantCulture) + "-" + date.Value.Year; ViewBag.expDate = date; } } else { ViewBag.Serial = _salesServices.GetSerialByPalletTrackingScheme(prodId, palletTrackingIds, CurrentTenantId, CurrentWarehouseId)?.PalletSerial; } } } ViewBag.product = _productServices.GetProductMasterById(prodId); return(PartialView()); }