/// <summary> /// Get Employee Details /// </summary> /// <param name="data"></param> /// <returns></returns> public List <OperatorDetailsShift> GetEmployeeDetails(DownloadPdf data) { DateTime FromDate = DateTime.Now; try { string[] dt = data.fromDate.Split('/'); string frDate = dt[2] + '-' + dt[1] + '-' + dt[0]; FromDate = Convert.ToDateTime(frDate); } catch { FromDate = Convert.ToDateTime(data.fromDate); } DateTime ToDate = DateTime.Now; try { string[] dt = data.toDate.Split('/'); string torDate = dt[2] + '-' + dt[1] + '-' + dt[0]; ToDate = Convert.ToDateTime(torDate); } catch { ToDate = Convert.ToDateTime(data.toDate); } List <OperatorDetailsShift> operatorDetailsShiftsList = new List <OperatorDetailsShift>(); if (data.cellId != 0 && data.subCellId != 0 && data.departmentId != 0) { var dbChecks = db.UnitworkccsTbloperatordetails.Where(m => m.CellId == data.cellId && m.SubCellId == data.subCellId && m.DepartmentId == data.departmentId).Select(m => m.OpId).ToList(); foreach (var i in dbChecks) { var check = (from wf in db.UnitworkccsTblemployeeshiftdetails where wf.IsDeleted == 0 && wf.FromDate >= FromDate && wf.ToDate <= ToDate && wf.EmployeeId == i select new { employeeId = wf.EmployeeId, fromDate = wf.FromDate, toDate = wf.ToDate, //shift = wf.Shift, machineIds = wf.MachineIds, employeeName = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OperatorName).FirstOrDefault(), cellName = db.UnitworkccsTblshop.Where(m => m.ShopId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.CellId).FirstOrDefault())).Select(m => m.ShopName).FirstOrDefault(), subCellName = db.UnitworkccsTblcell.Where(m => m.CellId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.SubCellId).FirstOrDefault())).Select(m => m.CellName).FirstOrDefault(), designation = db.UnitworkccsTblroles.Where(m => m.RoleId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.RoleId).FirstOrDefault())).Select(m => m.RoleName).FirstOrDefault(), department = db.UnitworkccsTbldepartmentdetails.Where(m => m.DepartmentId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.DepartmentId).FirstOrDefault())).Select(m => m.DepartmentName).FirstOrDefault(), employeeNo = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OpNo).FirstOrDefault(), shift = db.UnitworkccsTblshiftMstr.Where(m => m.ShiftId == Convert.ToInt32(wf.Shift)).Select(m => m.ShiftName).FirstOrDefault() }).ToList(); foreach (var item in check) { OperatorDetailsShift operatorDetailsShift = new OperatorDetailsShift(); operatorDetailsShift.employeeName = item.employeeName; DateTime fDate = Convert.ToDateTime(item.fromDate); operatorDetailsShift.fromDate = fDate.ToString("yyyy-MM-dd"); DateTime tDate = Convert.ToDateTime(item.toDate); operatorDetailsShift.toDate = tDate.ToString("yyyy-MM-dd"); operatorDetailsShift.Cell = item.cellName; operatorDetailsShift.subCell = item.subCellName; operatorDetailsShift.department = item.department; operatorDetailsShift.designation = item.designation; operatorDetailsShift.employeeNo = item.employeeNo; operatorDetailsShift.shift = item.shift; if (item.machineIds != null) { List <int> machineIds = new List <int>(); try { machineIds = item.machineIds.Split(',').Select(x => int.Parse(x.Trim())).ToList(); } catch (Exception ex) { } List <MachineDetails1> machineDetailsList = new List <MachineDetails1>(); foreach (var ids in machineIds) { var dbCheck = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == ids).FirstOrDefault(); if (dbCheck != null) { MachineDetails1 machineDetails = new MachineDetails1(); machineDetails.machineId = dbCheck.MachineId; machineDetails.machineName = dbCheck.MachineName; machineDetailsList.Add(machineDetails); } } operatorDetailsShift.machinesList = machineDetailsList; } operatorDetailsShiftsList.Add(operatorDetailsShift); } } //return operatorDetailsShiftsList; } else if (data.cellId != 0 && data.departmentId != 0) { var dbChecks = db.UnitworkccsTbloperatordetails.Where(m => m.CellId == data.cellId && m.DepartmentId == data.departmentId).Select(m => m.OpId).ToList(); //List<OperatorDetailsShift> operatorDetailsShiftsList = new List<OperatorDetailsShift>(); foreach (var i in dbChecks) { var check = (from wf in db.UnitworkccsTblemployeeshiftdetails where wf.IsDeleted == 0 && wf.FromDate >= FromDate && wf.ToDate <= ToDate && wf.EmployeeId == i select new { employeeId = wf.EmployeeId, fromDate = wf.FromDate, toDate = wf.ToDate, //shift = wf.Shift, machineIds = wf.MachineIds, employeeName = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OperatorName).FirstOrDefault(), cellName = db.UnitworkccsTblshop.Where(m => m.ShopId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.CellId).FirstOrDefault())).Select(m => m.ShopName).FirstOrDefault(), subCellName = db.UnitworkccsTblcell.Where(m => m.CellId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.SubCellId).FirstOrDefault())).Select(m => m.CellName).FirstOrDefault(), designation = db.UnitworkccsTblroles.Where(m => m.RoleId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.RoleId).FirstOrDefault())).Select(m => m.RoleName).FirstOrDefault(), department = db.UnitworkccsTbldepartmentdetails.Where(m => m.DepartmentId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.DepartmentId).FirstOrDefault())).Select(m => m.DepartmentName).FirstOrDefault(), employeeNo = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OpNo).FirstOrDefault(), shift = db.UnitworkccsTblshiftMstr.Where(m => m.ShiftId == Convert.ToInt32(wf.Shift)).Select(m => m.ShiftName).FirstOrDefault() }).ToList(); foreach (var item in check) { OperatorDetailsShift operatorDetailsShift = new OperatorDetailsShift(); operatorDetailsShift.employeeName = item.employeeName; DateTime fDate = Convert.ToDateTime(item.fromDate); operatorDetailsShift.fromDate = fDate.ToString("yyyy-MM-dd"); DateTime tDate = Convert.ToDateTime(item.toDate); operatorDetailsShift.toDate = tDate.ToString("yyyy-MM-dd"); operatorDetailsShift.Cell = item.cellName; operatorDetailsShift.subCell = item.subCellName; operatorDetailsShift.department = item.department; operatorDetailsShift.designation = item.designation; operatorDetailsShift.employeeNo = item.employeeNo; operatorDetailsShift.shift = item.shift; if (item.machineIds != null) { List <int> machineIds = new List <int>(); try { machineIds = item.machineIds.Split(',').Select(x => int.Parse(x.Trim())).ToList(); } catch (Exception ex) { } List <MachineDetails1> machineDetailsList = new List <MachineDetails1>(); foreach (var ids in machineIds) { var dbCheck = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == ids).FirstOrDefault(); if (dbCheck != null) { MachineDetails1 machineDetails = new MachineDetails1(); machineDetails.machineId = dbCheck.MachineId; machineDetails.machineName = dbCheck.MachineName; machineDetailsList.Add(machineDetails); } } operatorDetailsShift.machinesList = machineDetailsList; } operatorDetailsShiftsList.Add(operatorDetailsShift); } } } else if (data.departmentId != 0) { var dbChecks = db.UnitworkccsTbloperatordetails.Where(m => m.DepartmentId == data.departmentId).Select(m => m.OpId).ToList(); //List<OperatorDetailsShift> operatorDetailsShiftsList = new List<OperatorDetailsShift>(); foreach (var i in dbChecks) { var check = (from wf in db.UnitworkccsTblemployeeshiftdetails where wf.IsDeleted == 0 && wf.FromDate >= FromDate && wf.ToDate <= ToDate && wf.EmployeeId == i select new { employeeId = wf.EmployeeId, fromDate = wf.FromDate, toDate = wf.ToDate, //shift = wf.Shift, machineIds = wf.MachineIds, employeeName = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OperatorName).FirstOrDefault(), cellName = db.UnitworkccsTblshop.Where(m => m.ShopId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.CellId).FirstOrDefault())).Select(m => m.ShopName).FirstOrDefault(), subCellName = db.UnitworkccsTblcell.Where(m => m.CellId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.SubCellId).FirstOrDefault())).Select(m => m.CellName).FirstOrDefault(), designation = db.UnitworkccsTblroles.Where(m => m.RoleId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.RoleId).FirstOrDefault())).Select(m => m.RoleName).FirstOrDefault(), department = db.UnitworkccsTbldepartmentdetails.Where(m => m.DepartmentId == (db.UnitworkccsTbloperatordetails.Where(n => n.OpId == wf.EmployeeId).Select(n => n.DepartmentId).FirstOrDefault())).Select(m => m.DepartmentName).FirstOrDefault(), employeeNo = db.UnitworkccsTbloperatordetails.Where(m => m.OpId == wf.EmployeeId).Select(m => m.OpNo).FirstOrDefault(), shift = db.UnitworkccsTblshiftMstr.Where(m => m.ShiftId == Convert.ToInt32(wf.Shift)).Select(m => m.ShiftName).FirstOrDefault() }).ToList(); foreach (var item in check) { OperatorDetailsShift operatorDetailsShift = new OperatorDetailsShift(); operatorDetailsShift.employeeName = item.employeeName; DateTime fDate = Convert.ToDateTime(item.fromDate); operatorDetailsShift.fromDate = fDate.ToString("yyyy-MM-dd"); DateTime tDate = Convert.ToDateTime(item.toDate); operatorDetailsShift.toDate = tDate.ToString("yyyy-MM-dd"); operatorDetailsShift.Cell = item.cellName; operatorDetailsShift.subCell = item.subCellName; operatorDetailsShift.department = item.department; operatorDetailsShift.designation = item.designation; operatorDetailsShift.employeeNo = item.employeeNo; operatorDetailsShift.shift = item.shift; if (item.machineIds != null) { List <int> machineIds = new List <int>(); try { machineIds = item.machineIds.Split(',').Select(x => int.Parse(x.Trim())).ToList(); } catch (Exception ex) { } List <MachineDetails1> machineDetailsList = new List <MachineDetails1>(); foreach (var ids in machineIds) { var dbCheck = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == ids).FirstOrDefault(); if (dbCheck != null) { MachineDetails1 machineDetails = new MachineDetails1(); machineDetails.machineId = dbCheck.MachineId; machineDetails.machineName = dbCheck.MachineName; machineDetailsList.Add(machineDetails); } } operatorDetailsShift.machinesList = machineDetailsList; } operatorDetailsShiftsList.Add(operatorDetailsShift); } } } return(operatorDetailsShiftsList); }
/// <summary> /// View Multiple Operator By Id /// </summary> /// <param name="opId"></param> /// <returns></returns> public CommonResponse ViewMultipleOperatorShiftById(int Id) { CommonResponse obj = new CommonResponse(); try { var item = db.UnitworkccsTblemployeeshiftdetails.Where(m => m.IsDeleted == 0 && m.Id == Id).FirstOrDefault(); if (item != null) { // List<OperatorDetails> operatorDetailsList = new List<OperatorDetails>(); var opDet = db.UnitworkccsTbloperatordetails.Where(m => m.OpNo == item.EmployeeId).FirstOrDefault(); if (opDet != null) { OperatorDetailsShift operatorDetails = new OperatorDetailsShift(); operatorDetails.id = item.Id; operatorDetails.employeeId = item.EmployeeId; operatorDetails.employeeName = opDet.OperatorName; operatorDetails.Cell = db.UnitworkccsTblshop.Where(m => m.ShopId == opDet.CellId).Select(m => m.ShopName).FirstOrDefault(); operatorDetails.subCell = db.UnitworkccsTblcell.Where(m => m.CellId == opDet.SubCellId).Select(m => m.CellName).FirstOrDefault(); operatorDetails.designation = db.UnitworkccsTblroles.Where(m => m.RoleId == opDet.RoleId).Select(m => m.RoleName).FirstOrDefault(); operatorDetails.department = db.UnitworkccsTbldepartmentdetails.Where(m => m.DepartmentId == opDet.DepartmentId).Select(m => m.DepartmentName).FirstOrDefault(); // operatorDetails.shift = item.shiftName; operatorDetails.shift = db.UnitworkccsTblshiftMstr.Where(m => m.ShiftId == Convert.ToInt32(item.Shift)).Select(m => m.ShiftName).FirstOrDefault(); string fdate = item.FromDate.ToString("yyyy-MM-dd"); operatorDetails.fromDate = fdate; string tdate = item.ToDate.ToString("yyyy-MM-dd"); operatorDetails.toDate = tdate; if (item.MachineIds != null) { List <int> machineIds = new List <int>(); try { machineIds = item.MachineIds.Split(',').Select(x => int.Parse(x.Trim())).ToList(); } catch (Exception ex) { } List <MachineDetails1> machineDetailsList = new List <MachineDetails1>(); foreach (var ids in machineIds) { var dbCheck = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == ids).FirstOrDefault(); if (dbCheck != null) { MachineDetails1 machineDetails = new MachineDetails1(); machineDetails.machineId = dbCheck.MachineId; machineDetails.machineName = dbCheck.MachineName; machineDetailsList.Add(machineDetails); } } operatorDetails.machinesList = machineDetailsList; } obj.isStatus = true; obj.response = operatorDetails; } } else { obj.isStatus = false; obj.response = "No Items Found"; } } catch (Exception e) { obj.isStatus = false; obj.response = ResourceResponse.FailureMessage; } return(obj); }