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