private void SaveGenderDs()
{
//Session["FiltersModel"] = fml;
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewGender, Session["FiltersModel"] as FiltersModel, "Gender");
Session["FiltersModel"] = FM;
}
public static void SetGridViewCheckState(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
return;
switch (filterName)
{
case "Department":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DepartmentFilter);
break;
case "Section":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.SectionFilter);
break;
case "Company":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CompanyFilter);
break;
case "Location":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.LocationFilter);
break;
case "Shift":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ShiftFilter);
break;
case "Division":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DivisionFilter);
break;
case "Employee":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.EmployeeFilter);
break;
case "Crew":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CrewFilter);
break;
case "Type":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.TypeFilter);
break;
}
}
public static string DeleteSingleFilter(string id, string parentid)
{
FiltersModel fml = new FiltersModel();
fml = HttpContext.Current.Session["FiltersModel"] as FiltersModel;
fml = WMSLibrary.Filters.DeleteSingleFilter(fml, id, parentid);
return DateTime.Now.ToString();
}
public FiltersModel DeleteAllFilters(FiltersModel filtersModel)
{
//filtersModel.CityFilter = new List<FiltersAttributes>();
filtersModel.CompanyFilter = new List <FiltersAttributes>();
//filtersModel.CrewFilter = new List<FiltersAttributes>();
filtersModel.DepartmentFilter = new List <FiltersAttributes>();
// filtersModel.DivisionFilter = new List<FiltersAttributes>();
filtersModel.EmployeeFilter = new List <FiltersAttributes>();
filtersModel.LocationFilter = new List <FiltersAttributes>();
// filtersModel.RegionFilter = new List<FiltersAttributes>();
filtersModel.SectionFilter = new List <FiltersAttributes>();
filtersModel.ShiftFilter = new List <FiltersAttributes>();
filtersModel.TypeFilter = new List <FiltersAttributes>();
filtersModel.ReaderFilter = new List <FiltersAttributes>();
//filtersModel.BusinessFilter = new List<FiltersAttributes>();
//filtersModel.BanksFilter = new List<FiltersAttributes>();
//filtersModel.PaymentModeFilter = new List<FiltersAttributes>();
filtersModel.CMDesignationFilter = new List <FiltersAttributes>();
filtersModel.QualificationFilter = new List <FiltersAttributes>();
filtersModel.DomicileFilter = new List <FiltersAttributes>();
filtersModel.InstituteFilter = new List <FiltersAttributes>();
filtersModel.DegreeFilter = new List <FiltersAttributes>();
//filtersModel.ProductionOrderFilter = new List<FiltersAttributes>();
return(filtersModel);
}
public FiltersModel SyncGridViewIDs(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
{
return(new FiltersModel());
}
if (filtersModel.ReaderFilter == null)
{
return(new FiltersModel());
}
for (int i = 0; i < gv.Rows.Count; i++)
{
bool isChecked = ((CheckBox)gv.Rows[i].FindControl("CheckOne")).Checked;
if (isChecked) // Add to filter list
{
string ItemID = gv.Rows[i].Cells[0].Text;
//string ItemID = gv.DataKeys[i].Value.ToString();
string ItemName = gv.Rows[i].Cells[2].Text;
AddObjectToList(filtersModel, filterName, ItemID, ItemName);
}
else // Remove from filter list
{
//string ItemID = gv.DataKeys[i].Value.ToString();
string ItemID = gv.Rows[i].Cells[0].Text;
RemoveObjectFromList(filtersModel, filterName, ItemID);
}
}
return(filtersModel);
}
public static FiltersModel SyncGridViewIDs(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
return new FiltersModel();
if (filtersModel.DepartmentFilter == null)
return new FiltersModel();
for (int i = 0; i < gv.Rows.Count; i++)
{
bool isChecked = ((CheckBox)gv.Rows[i].FindControl("CheckOne")).Checked;
if (isChecked) // Add to filter list
{
string ItemID = gv.Rows[i].Cells[1].Text;
//string ItemID = gv.DataKeys[i].Value.ToString();
string ItemName = gv.Rows[i].Cells[2].Text;
AddObjectToList(filtersModel, filterName, ItemID, ItemName);
}
else // Remove from filter list
{
//string ItemID = gv.DataKeys[i].Value.ToString();
string ItemID = gv.Rows[i].Cells[1].Text;
RemoveObjectFromList(filtersModel, filterName, ItemID);
}
}
return filtersModel;
}
private void SaveLocationIDs()
{
//Session["FiltersModel"] = fml;
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewLocation, Session["FiltersModel"] as FiltersModel, "Location");
Session["FiltersModel"] = FM;
//fml = Session["FiltersModel"] as FiltersModel;
}
private void SaveCompanyIDs()
{
WMSLibrary.Filters filtersHelper = new WMSLibrary.Filters();
FiltersModel modelTemp = Session["FiltersModel"] as FiltersModel;
WMSLibrary.FiltersModel FM = filtersHelper.SyncGridViewIDs(GridViewCompany, modelTemp, "Company");
Session["FiltersModel"] = FM;
//fml = Session["FiltersModel"] as FiltersModel;
}
public static void SetGridViewCheckState(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
{
return;
}
switch (filterName)
{
case "Department":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DepartmentFilter);
break;
case "Section":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.SectionFilter);
break;
case "Company":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CompanyFilter);
break;
case "Location":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.LocationFilter);
break;
case "Shift":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ShiftFilter);
break;
case "Division":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DivisionFilter);
break;
case "Employee":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.EmployeeFilter);
break;
case "Crew":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CrewFilter);
break;
case "Type":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.TypeFilter);
break;
case "Region":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.RegionFilter);
break;
case "City":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CityFilter);
break;
case "Wing":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.WingFilter);
break;
}
}
private void SaveSectionsIDs()
{
WMSLibrary.Filters filtersHelper = new WMSLibrary.Filters();
FiltersModel modelTemp = Session["FiltersModel"] as FiltersModel;
WMSLibrary.FiltersModel FM = filtersHelper.SyncGridViewIDs(GridViewSection, modelTemp, "Section");
Session["FiltersModel"] = FM;
//fml = Session["FiltersModel"] as FiltersModel;
}
public FiltersModel DeleteAllFilters(FiltersModel filtersModel)
{
filtersModel.CityFilter = new List<FiltersAttributes>();
filtersModel.CompanyFilter = new List<FiltersAttributes>();
filtersModel.CrewFilter = new List<FiltersAttributes>();
filtersModel.DepartmentFilter = new List<FiltersAttributes>();
filtersModel.DivisionFilter = new List<FiltersAttributes>();
filtersModel.EmployeeFilter = new List<FiltersAttributes>();
filtersModel.LocationFilter = new List<FiltersAttributes>();
filtersModel.RegionFilter = new List<FiltersAttributes>();
filtersModel.SectionFilter = new List<FiltersAttributes>();
filtersModel.ShiftFilter = new List<FiltersAttributes>();
filtersModel.TypeFilter = new List<FiltersAttributes>();
return filtersModel;
}
public FiltersModel DeleteAllFilters(FiltersModel filtersModel)
{
filtersModel.CityFilter = new List <FiltersAttributes>();
//filtersModel.CompanyFilter = new List<FiltersAttributes>();
//filtersModel.CrewFilter = new List<FiltersAttributes>();
filtersModel.DepartmentFilter = new List <FiltersAttributes>();
//filtersModel.DivisionFilter = new List<FiltersAttributes>();
filtersModel.EmployeeFilter = new List <FiltersAttributes>();
filtersModel.LocationFilter = new List <FiltersAttributes>();
filtersModel.RegionFilter = new List <FiltersAttributes>();
filtersModel.SectionFilter = new List <FiltersAttributes>();
filtersModel.ShiftFilter = new List <FiltersAttributes>();
filtersModel.TypeFilter = new List <FiltersAttributes>();
return(filtersModel);
}
private static void SetGridViewCheckStateChild(GridView gv, FiltersModel filtersModel, List <FiltersAttributes> list)
{
if (list == null)
{
return;
}
for (int j = 0; j < gv.Rows.Count; j++)
{
bool chk = false;
for (int i = 0; i < list.Count; i++)
{
if (list[i].ID == gv.Rows[j].Cells[0].Text)
{
chk = true;
}
}
((CheckBox)gv.Rows[j].FindControl("CheckOne")).Checked = chk;
}
}
internal static List <Models.Att_DailyAttendance> ReportsFilterImplementation(WMSLibrary.FiltersModel fm, List <Models.Att_DailyAttendance> _TempViewAttDataDetailed4, List <Models.Att_DailyAttendance> _ViewAttDataDetailed4)
{
return(_ViewAttDataDetailed4);
}
private void SaveTypeIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewLocation, Session["FiltersModel"] as FiltersModel, "Location");
Session["FiltersModel"] = FM;
}
private void AddObjectToList(FiltersModel filtersModel, string filterName, string ItemID, string ItemName)
{
switch (filterName)
{
case "Company":
if (filtersModel.CompanyFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.CompanyFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "Division":
// if (filtersModel.DivisionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.DivisionFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
case "Department":
if (filtersModel.DepartmentFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.DepartmentFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "City":
// if (filtersModel.CityFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.CityFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
case "Section":
if (filtersModel.SectionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.SectionFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Location":
if (filtersModel.LocationFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.LocationFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Shift":
if (filtersModel.ShiftFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.ShiftFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Type":
if (filtersModel.TypeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.TypeFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Employee":
if (filtersModel.EmployeeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.EmployeeFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "Crew":
// if (filtersModel.CrewFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.CrewFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
case "Reader":
if (filtersModel.ReaderFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.ReaderFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "Business":
// if (filtersModel.BusinessFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.BusinessFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
//case "Bank":
// if (filtersModel.BanksFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.BanksFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
//case "PaymentMode":
// if (filtersModel.PaymentModeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.PaymentModeFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
case "Designation":
if (filtersModel.CMDesignationFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.CMDesignationFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Qualification":
if (filtersModel.QualificationFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.QualificationFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Domicile":
if (filtersModel.DomicileFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.DomicileFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Degree":
if (filtersModel.DegreeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.DegreeFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Institute":
if (filtersModel.InstituteFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.InstituteFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "ProductionOrder":
// if (filtersModel.ProductionOrderFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.ProductionOrderFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
}
}
/// <summary>
/// This function will remove the id of a specific deparment, company... form the session
/// </summary>
/// <param name="filtersModel"></param>
/// <param name="filterName"></param>
/// <param name="ItemID"></param>
///
public static FiltersModel DeleteSingleFilter(FiltersModel fml, string id, string filtername)
{
RemoveObjectFromList(fml, filtername, id);
return(fml);
}
private void SaveCrewIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewCrew, Session["FiltersModel"] as FiltersModel, "Crew");
Session["FiltersModel"] = FM;
}
public void InitSession()
{
filterModel = new FiltersModel();
}
private void SaveEmployeeIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewEmployee, Session["FiltersModel"] as FiltersModel, "Employee");
Session["FiltersModel"] = FM;
}
private static void RemoveObjectFromList(FiltersModel filtersModel, string filterName, string ItemID)
{
switch (filterName)
{
//case "Company":
// for (int k = 0; k < filtersModel.CompanyFilter.Count; k++)
// {
// if (filtersModel.CompanyFilter[k].ID == ItemID)
// filtersModel.CompanyFilter.RemoveAt(k);
// }
// break;
//case "Division":
// for (int k = 0; k < filtersModel.DivisionFilter.Count; k++)
// {
// if (filtersModel.DivisionFilter[k].ID == ItemID)
// filtersModel.DivisionFilter.RemoveAt(k);
// }
// break;
case "Department":
for (int k = 0; k < filtersModel.DepartmentFilter.Count; k++)
{
if (filtersModel.DepartmentFilter[k].ID == ItemID)
{
filtersModel.DepartmentFilter.RemoveAt(k);
}
}
break;
case "Section":
for (int k = 0; k < filtersModel.SectionFilter.Count; k++)
{
if (filtersModel.SectionFilter[k].ID == ItemID)
{
filtersModel.SectionFilter.RemoveAt(k);
}
}
break;
case "Location":
for (int k = 0; k < filtersModel.LocationFilter.Count; k++)
{
if (filtersModel.LocationFilter[k].ID == ItemID)
{
filtersModel.LocationFilter.RemoveAt(k);
}
}
break;
case "Shift":
for (int k = 0; k < filtersModel.ShiftFilter.Count; k++)
{
if (filtersModel.ShiftFilter[k].ID == ItemID)
{
filtersModel.ShiftFilter.RemoveAt(k);
}
}
break;
//case "Crew":
// for (int k = 0; k < filtersModel.CrewFilter.Count; k++)
// {
// if (filtersModel.CrewFilter[k].ID == ItemID)
// filtersModel.CrewFilter.RemoveAt(k);
// }
// break;
case "Type":
for (int k = 0; k < filtersModel.TypeFilter.Count; k++)
{
if (filtersModel.TypeFilter[k].ID == ItemID)
{
filtersModel.TypeFilter.RemoveAt(k);
}
}
break;
case "Employee":
for (int k = 0; k < filtersModel.EmployeeFilter.Count; k++)
{
if (filtersModel.EmployeeFilter[k].ID == ItemID)
{
filtersModel.EmployeeFilter.RemoveAt(k);
}
}
break;
}
}
private void AddObjectToList(FiltersModel filtersModel, string filterName, string ItemID, string ItemName)
{
switch (filterName)
{
//case "Company":
// if (filtersModel.CompanyFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.CompanyFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
//case "Division":
// if (filtersModel.DivisionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.DivisionFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
case "Department":
if (filtersModel.DepartmentFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.DepartmentFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Section":
if (filtersModel.SectionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.SectionFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Location":
if (filtersModel.LocationFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.LocationFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Shift":
if (filtersModel.ShiftFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.ShiftFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Type":
if (filtersModel.TypeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.TypeFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
case "Employee":
if (filtersModel.EmployeeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
{
filtersModel.EmployeeFilter.Add(new FiltersAttributes()
{
ID = ItemID, FilterName = ItemName
});
}
break;
//case "Crew":
// if (filtersModel.CrewFilter.Where(aa => aa.ID == ItemID).Count() == 0)
// filtersModel.CrewFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
// break;
}
}
internal static List <ViewEmpHistory> ReportsFilterImplementation(WMSLibrary.FiltersModel fm, List <ViewEmpHistory> _TempViewAttMonthlySummary, List <ViewEmpHistory> _ViewAttMonthlySummary)
{
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.LocID == _locID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for shifts
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.ShftID == _shiftID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for department
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.DeptID == _deptID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for Designation
if (fm.CMDesignationFilter.Count > 0)
{
foreach (var type in fm.CMDesignationFilter)
{
string _desigName = type.FilterName.ToUpper();
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.DesignationName.ToUpper() == _desigName).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for sections
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.SecID == _secID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for type
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.TypID == _typeID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
//for Domicile
//if (fm.DomicileFilter.Count > 0)
//{
// foreach (var type in fm.DomicileFilter)
// {
// string search = type.ID;
// _TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.DomicileProvince == search).ToList());
// }
// _ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
//}
//else
// _TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
_TempViewAttMonthlySummary.Clear();
//Employee
if (fm.EmployeeFilter.Count > 0)
{
foreach (var emp in fm.EmployeeFilter)
{
int _empID = Convert.ToInt32(emp.ID);
_TempViewAttMonthlySummary.AddRange(_ViewAttMonthlySummary.Where(aa => aa.EmployeeID == _empID).ToList());
}
_ViewAttMonthlySummary = _TempViewAttMonthlySummary.ToList();
}
else
{
_TempViewAttMonthlySummary = _ViewAttMonthlySummary.ToList();
}
_TempViewAttMonthlySummary.Clear();
return(_ViewAttMonthlySummary);
}
internal static List <Models.ViewVisitEmp> ReportsFilterImplementation(WMSLibrary.FiltersModel fm, List <Models.ViewVisitEmp> _TempViewVisitorEmp, List <Models.ViewVisitEmp> _ViewVisitorEmp)
{
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.LocID == _locID).ToList());
}
_ViewVisitorEmp = _TempViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
//for shifts
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.ShftID == _shiftID).ToList());
}
_ViewVisitorEmp = _TempViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
//for type
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.TypID == _typeID).ToList());
}
_ViewVisitorEmp = _ViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
//for department
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.DeptID == _deptID).ToList());
}
_ViewVisitorEmp = _TempViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
//for sections
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.SecID == _secID).ToList());
}
_ViewVisitorEmp = _TempViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
//Employee
if (fm.EmployeeFilter.Count > 0)
{
foreach (var emp in fm.EmployeeFilter)
{
int _empID = Convert.ToInt32(emp.ID);
_TempViewVisitorEmp.AddRange(_ViewVisitorEmp.Where(aa => aa.EmployeeID == _empID).ToList());
}
_ViewVisitorEmp = _TempViewVisitorEmp.ToList();
}
else
{
_TempViewVisitorEmp = _ViewVisitorEmp.ToList();
}
_TempViewVisitorEmp.Clear();
return(_ViewVisitorEmp);
}
private List<DailySummary> ReportsFilterImplementation(FiltersModel fm, List<DailySummary> _TempViewList, List<DailySummary> _ViewList)
{
//for company
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "C" && aa.Criteria==comp.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for location
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "L" && aa.Criteria==loc.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for shifts
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "S" && aa.Criteria == shift.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for type
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "T" && aa.Criteria == type.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
////for crews
//if (fm.CrewFilter.Count > 0)
//{
// foreach (var cre in fm.CrewFilter)
// {
// short _crewID = Convert.ToInt16(cre.ID);
// _TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "C" && aa.Criteria == loc.ID).ToList());
// }
// _ViewList = _TempViewList.ToList();
//}
//else
// _TempViewList = _ViewList.ToList();
//_TempViewList.Clear();
////for division
//if (fm.DivisionFilter.Count > 0)
//{
// foreach (var div in fm.DivisionFilter)
// {
// //baldi doesnt have the division id so using division name in
// _TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "L" && aa.Criteria == loc.ID).ToList());
// }
// _ViewList = _TempViewList.ToList();
//}
//else
// _TempViewList = _ViewList.ToList();
//_TempViewList.Clear();
//for department
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "D" && aa.Criteria == dept.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for sections
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "E" && aa.Criteria == sec.ID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
////Employee
//if (fm.EmployeeFilter.Count > 0)
//{
// foreach (var emp in fm.EmployeeFilter)
// {
// int _empID = Convert.ToInt32(emp.ID);
// _TempViewList.AddRange(_ViewList.Where(aa => aa.Criteria == "L" && aa.Criteria == loc.ID).ToList());
// }
// _ViewList = _TempViewList.ToList();
//}
//else
// _TempViewList = _ViewList.ToList();
//_TempViewList.Clear();
return _ViewList;
}
//ViewJob Card
public List<ViewJobCardEmp> ReportsFilterImplementation(FiltersModel fm, List<ViewJobCardEmp> _TempViewList, List<ViewJobCardEmp> _ViewList)
{
//for region
if (fm.RegionFilter.Count > 0)
{
foreach (var comp in fm.RegionFilter)
{
string regionname = comp.FilterName;
_TempViewList.AddRange(_ViewList.Where(aa => aa.RegionName == regionname).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for city
if (fm.CityFilter.Count > 0)
{
foreach (var city in fm.CityFilter)
{
string _cityID = city.FilterName;
_TempViewList.AddRange(_ViewList.Where(aa => aa.CityName == _cityID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for location
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.LocID == _locID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for shifts
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.ShiftID == _shiftID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for type
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.TypeID == _typeID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for crews
if (fm.CrewFilter.Count > 0)
{
foreach (var cre in fm.CrewFilter)
{
short _crewID = Convert.ToInt16(cre.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.CrewID == _crewID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for regioon
if (fm.RegionFilter.Count > 0)
{
foreach (var cre in fm.RegionFilter)
{
string _regionName = cre.FilterName;
_TempViewList.AddRange(_ViewList.Where(aa => aa.RegionName == _regionName).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for division
if (fm.DivisionFilter.Count > 0)
{
foreach (var div in fm.DivisionFilter)
{
short _divID = Convert.ToInt16(div.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.DivID == _divID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for department
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.DeptID == _deptID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for sections
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.SecID == _secID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//Employee
if (fm.EmployeeFilter.Count > 0)
{
foreach (var emp in fm.EmployeeFilter)
{
int _empID = Convert.ToInt32(emp.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.EmpID == _empID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
return _ViewList;
}
private void SaveEmployeeIDs()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewEmployee, Session["FiltersModel"] as FiltersModel, "Employee");
Session["FiltersModel"] = FM;
}
protected void Page_Load(object sender, EventArgs e)
{
String reportName = Request.QueryString["reportname"];
String type = Request.QueryString["type"];
if (!Page.IsPostBack)
{
List<string> list = Session["ReportSession"] as List<string>;
fm = new FiltersModel();
fm = Session["FiltersModel"] as FiltersModel;
CreateDataTable();
CreateFlexyMonthlyDataTable();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.MakeCustomizeQuery(LoggedInUser);
_dateFrom = list[0];
string _dateTo = list[1];
companyimage = GetCompanyImages(fm);
string PathString = "";
string consolidatedMonth = "";
switch (reportName)
{
case "monthly_productivity":
monthlyProductivityProcess(_dateFrom,_dateTo,query);
break;
case "badli_report":
DataTable badlidt = qb.GetValuesfromDB("select * from ViewBadli where (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )");
List<ViewBadli> _BadliList = badlidt.ToList<ViewBadli>();
List<ViewBadli> _TempBadliList = new List<ViewBadli>();
title = "Badli Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/BadliReport.rdlc";
else
PathString = "/WMS/Reports/RDLC/BadliReport.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempBadliList, _BadliList), _dateFrom + " TO " + _dateTo);
break;
//please modify the first case
case "summarized_monthly_report":
List<TASReportDataSet.SummarizedMonthlyReportDataTable> AttDeptdummy = new List<TASReportDataSet.SummarizedMonthlyReportDataTable>().ToList();
title = "Department Attendace Summary";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/SummarizedMonthlyReport.rdlc";
else
PathString = "/WMS/Reports/RDLC/SummarizedMonthlyReport.rdlc";
LoadReport(PathString, AttDeptdummy, _dateFrom + " TO " + _dateTo);
break;
case "Employee_Att_Summary_New_report": DataTable dt4 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1" + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )");
List<ViewAttData> ListOfAttDate = new List<ViewAttData>();
List<ViewAttData> TempList = new List<ViewAttData>();
title = "Employee Attendace Summary New";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/EmpAttSummaryNew.rdlc";
else
PathString = "/WMS/Reports/RDLC/EmpAttSummaryNew.rdlc";
ListOfAttDate = dt4.ToList<ViewAttData>();
TempList = new List<ViewAttData>();
LoadReport(PathString, ReportsFilterImplementation(fm, TempList, ListOfAttDate), _dateFrom + " TO " + _dateTo);
break;
case "department_attendance_summary": HRReportsMaker hrm = new HRReportsMaker();
List<AttDeptSummary> AttDept = hrm.GetListForAttDepartmentsSummary(Session["FiltersModel"] as FiltersModel, _dateFrom, _dateTo);
title = "Department Attendace Summary";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/AttDepartmentSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/AttDepartmentSummary.rdlc";
LoadReport(PathString, AttDept, _dateFrom + " TO " + _dateTo);
break;
case "emp_record": DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1 ");
List<EmpView> _ViewList = dt.ToList<EmpView>();
List<EmpView> _TempViewList = new List<EmpView>();
title = "Employee Record Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/Employee.rdlc";
else
PathString = "/WMS/Reports/RDLC/Employee.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList, _ViewList), _dateFrom + " TO " + _dateTo);
break;
case "emp_record_active": dt = qb.GetValuesfromDB("select * from EmpView " + query+ " and Status=1 ");
_ViewList = dt.ToList<EmpView>();
_TempViewList = new List<EmpView>();
title = "Active Employees Record Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/Employee.rdlc";
else
PathString = "/WMS/Reports/RDLC/Employee.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList, _ViewList), _dateFrom + " TO " + _dateTo);
break;
case "emp_record_inactive": dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=0 ");
_ViewList = dt.ToList<EmpView>();
_TempViewList = new List<EmpView>();
title = "Inactive Employees Record Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/Employee.rdlc";
else
PathString = "/WMS/Reports/RDLC/Employee.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList, _ViewList), _dateFrom + " TO " + _dateTo);
break;
case "emp_detail_excel": DataTable dt1 = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1 ");
List<EmpView> _ViewList1 = dt1.ToList<EmpView>();
List<EmpView> _TempViewList1 = new List<EmpView>();
title = "Employee Detail Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/EmployeeDetail.rdlc";
else
PathString = "/WMS/Reports/RDLC/EmployeeDetail.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList1, _ViewList1), _dateFrom + " TO " + _dateTo);
break;
case "leave_application": dt1 = qb.GetValuesfromDB("select * from ViewLvApplication " + query + " and (FromDate >= '" + _dateFrom + "' and ToDate <= '" + _dateTo + "' )");
List<ViewLvApplication> _ViewListLvApp = dt1.ToList<ViewLvApplication>();
List<ViewLvApplication> _TempViewListLvApp = new List<ViewLvApplication>();
title = "Leave Application Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRLeave.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRLeave.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListLvApp, _ViewListLvApp), _dateFrom + " TO " + _dateTo);
break;
case "detailed_att": DataTable dt2 = qb.GetValuesfromDB("select * from ViewDetailAttData " + query + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )");
List<ViewDetailAttData> _ViewList2 = dt2.ToList<ViewDetailAttData>();
List<ViewDetailAttData> _TempViewList2 = new List<ViewDetailAttData>();
title = "Detailed Attendence";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRdetailed.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRdetailed.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList2, _ViewList2), _dateFrom + " TO " + _dateTo);
break;
case "consolidated_att": DataTable dt3 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )");
List<ViewAttData> _ViewList3 = dt3.ToList<ViewAttData>();
List<ViewAttData> _TempViewList3 = new List<ViewAttData>();
title = "Consolidated Attendence Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRAttendance.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRAttendance.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList3, _ViewList3), _dateFrom + " TO " + _dateTo);
break;
case "present": DataTable datatable = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusP = 1 ");
List<ViewAttData> _ViewList4 = datatable.ToList<ViewAttData>();
List<ViewAttData> _TempViewList4 = new List<ViewAttData>();
title = "Present Employee Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRPresent.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRPresent.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList4, _ViewList4), _dateFrom + " TO " + _dateTo);
break;
case "absent": DataTable dt5 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusAB = 1 ");
List<ViewAttData> _ViewList5 = dt5.ToList<ViewAttData>();
List<ViewAttData> _TempViewList5 = new List<ViewAttData>();
title = "Absent Employee Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRAbsent.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRAbsent.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList5, _ViewList5), _dateFrom + " TO " + _dateTo);
break;
case "lv_application": DataTable dt6 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and (StatusLeave=1 OR StatusHL=1)");
List<ViewAttData> _ViewList6 = dt6.ToList<ViewAttData>();
List<ViewAttData> _TempViewList6 = new List<ViewAttData>();
title = "Leave Attendence Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRAbsent.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRAbsent.rdlc";
//LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList6, _ViewList6), _dateFrom + " TO " + _dateTo);
//To-do Develop Leave Attendance Report
break;
case "short_lv": DataTable dt7 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusSL=1");
List<ViewAttData> _ViewList7 = dt7.ToList<ViewAttData>();
List<ViewAttData> _TempViewList7 = new List<ViewAttData>();
title = "Short Leave Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRShortLeave.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRShortLeave.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList7, _ViewList7), _dateFrom + " TO " + _dateTo);
break;
case "late_in": DataTable dt8 = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusLI=1 ");
List<ViewAttData> _ViewList8 = dt8.ToList<ViewAttData>();
List<ViewAttData> _TempViewList8 = new List<ViewAttData>();
title = "Late In Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRLateIn.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRLateIn.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "late_out": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusLO=1 ");
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
title = "Late Out Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRLateOut.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRLateOut.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "early_in": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusEI=1 ");
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
title = "Early In Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DREarlyIn.rdlc";
else
PathString = "/WMS/Reports/RDLC/DREarlyIn.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "early_out": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusEO=1 ");
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
title = "Early Out Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DREarlyOut.rdlc";
else
PathString = "/WMS/Reports/RDLC/DREarlyOut.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "overtime": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and StatusOT=1 ");
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
title = "OverTime Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DROverTime.rdlc";
else
PathString = "/WMS/Reports/RDLC/DROverTime.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "missing_attendance": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1 " + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and ((TimeIn is null and TimeOut is not null) or (TimeIn is not null and TimeOut is null)) ");
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
title = "Missing Attendence Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRMissingAtt.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRMissingAtt.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "multiple_in_out": dt = qb.GetValuesfromDB("select * from ViewMultipleInOut " + query + " and Status=1" + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'"
+ _dateTo + "'" + " )" + " and (Tin1 is not null or TOut1 is not null)");
//change query for multiple_in_out
List<ViewMultipleInOut> _ViewList9 = dt.ToList<ViewMultipleInOut>();
List<ViewMultipleInOut> _TempViewList9 = new List<ViewMultipleInOut>();
title = "Multiple In/Out Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DRMultipleInOut.rdlc";
else
PathString = "/WMS/Reports/RDLC/DRMultipleInOut.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList9, _ViewList9), _dateFrom + " TO " + _dateTo);
break;
case "monthly_leave_sheet": string _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1 ");
_ViewList1 = dt.ToList<EmpView>();
_TempViewList1 = new List<EmpView>();
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MLvConsumed.rdlc";
else
PathString = "/WMS/Reports/RDLC/MLvConsumed.rdlc";
int monthfrom = Convert.ToDateTime(_dateFrom).Month;
int monthTo = Convert.ToDateTime(_dateTo).Month;
//int totalMonths = monthfrom < monthTo ? monthTo : monthfrom;
for (int ul = monthfrom > monthTo ? monthTo : monthfrom; ul <= (monthfrom < monthTo ? monthTo : monthfrom); ul++)
{
LoadReport(PathString, GetLV(ReportsFilterImplementation(fm, _TempViewList1, _ViewList1), monthfrom), ul);
}
// LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList1, _ViewList1), _dateFrom);
break;
case "monthly_21-20": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Status=1 " + " and" + consolidatedMonth);
//dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Period = " + _period);
title = "Monthly Sheet (21st to 20th)";
List<ViewMonthlyDataPer> _ViewListMonthlyDataPer = dt.ToList<ViewMonthlyDataPer>();
List<ViewMonthlyDataPer> _TempViewListMonthlyDataPer = new List<ViewMonthlyDataPer>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRSheetP.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRSheetP.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom);
break;
case "monthly_1-31": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyData " + query + " and Status=1" + " and" + consolidatedMonth);
//dt = qb.GetValuesfromDB("select * from ViewMonthlyData " + query + " and Period = " + _period);
title = "Monthly Sheet (1st to 31st)";
List<ViewMonthlyData> _ViewListMonthlyData = dt.ToList<ViewMonthlyData>();
List<ViewMonthlyData> _TempViewListMonthlyData = new List<ViewMonthlyData>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRSheetC.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRSheetC.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyData, _ViewListMonthlyData), _dateFrom);
break;
case "monthlysummary_21-20": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Status=1" + " and" + consolidatedMonth);
//dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Period = " + _period);
title = "Monthly Summary Report (21st to 20th)";
_ViewListMonthlyDataPer = dt.ToList<ViewMonthlyDataPer>();
_TempViewListMonthlyDataPer = new List<ViewMonthlyDataPer>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom);
break;
case "monthlysummary_1-31": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyData " + query + " and Status=1" + " and" + consolidatedMonth);
//dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Period = " + _period);
title = "Monthly Summary (1st to 31st)";
_ViewListMonthlyData = dt.ToList<ViewMonthlyData>();
_TempViewListMonthlyData = new List<ViewMonthlyData>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRSummaryC.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRSummaryC.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyData, _ViewListMonthlyData), _dateFrom);
break;
case "monthly_21-20_excel": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Status=1" + " and" + consolidatedMonth);
//dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Period = " + _period);
title = "Monthly Sheet (21st to 20th)";
_ViewListMonthlyDataPer = dt.ToList<ViewMonthlyDataPer>();
_TempViewListMonthlyDataPer = new List<ViewMonthlyDataPer>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRDetailExcelP.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRDetailExcelP.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom);
break;
case "monthly_1-31_consolidated": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyData " + query + " and Status=1" + " and" + consolidatedMonth);
title = "Monthly Consolidated Attendance Sheet (1st to 31th)";
_ViewListMonthlyData = dt.ToList<ViewMonthlyData>();
_TempViewListMonthlyData = new List<ViewMonthlyData>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRDetailExcelC.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRDetailExcelC.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyData, _ViewListMonthlyData), _dateFrom + " to " + _dateTo);
break;
case "monthly_21-20_consolidated": _period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
consolidatedMonth = "";
monthfrom = Convert.ToDateTime(_dateFrom).Month;
monthTo = Convert.ToDateTime(_dateTo).Month;
for (int i = monthfrom; i <= monthTo; i++)
{
consolidatedMonth = consolidatedMonth + " Period =" + i + Convert.ToDateTime(_dateFrom).Year.ToString() + " OR";
}
if (consolidatedMonth.Length > 4)
consolidatedMonth = consolidatedMonth.Substring(0, consolidatedMonth.Length - 3);
dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Status=1" + " and" + consolidatedMonth);
title = "Monthly Consolidated (21th to 20th)(Excel)";
_ViewListMonthlyDataPer = dt.ToList<ViewMonthlyDataPer>();
_TempViewListMonthlyDataPer = new List<ViewMonthlyDataPer>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRDetailExcelP.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRDetailExcelP.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom + " to " + _dateTo);
break;
case "monthly_21-20_flexy":
dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1 ");
_ViewList = dt.ToList<EmpView>();
_TempViewList = new List<EmpView>();
title = "Employee Record Report";
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRFlexyDetailExcelP.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRFlexyDetailExcelP.rdlc";
LoadReport(LoadPermanentMonthlyDT(ReportsFilterImplementation(fm, _TempViewList, _ViewList), Convert.ToDateTime(_dateFrom), Convert.ToDateTime(_dateTo)), PathString, _dateFrom + " TO " + _dateTo);
break;
case "emp_att": dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1" + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )");
title = "Employee Attendance";
_ViewList8 = dt.ToList<ViewAttData>();
_TempViewList8 = new List<ViewAttData>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/EmpAttSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/EmpAttSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewList8, _ViewList8), _dateFrom + " TO " + _dateTo);
break;
case "emp_absent":
_period = Convert.ToDateTime(_dateFrom).Month.ToString() + Convert.ToDateTime(_dateFrom).Year.ToString();
dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and Status=1" + " and (AttDate >= " + "'" + _dateFrom + "'" + " and AttDate <= " + "'" + _dateTo + "'" + " )" + " and StatusAB = 1 ");
title = "Employee Absent";
_ViewListMonthlyDataPer = dt.ToList<ViewMonthlyDataPer>();
_TempViewListMonthlyDataPer = new List<ViewMonthlyDataPer>();
//Change the Paths
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MRSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/MRSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom);
break;
case "lv_quota": dt = qb.GetValuesfromDB("select * from EmpView " + query + " and Status=1");
_ViewList1 = dt.ToList<EmpView>();
_TempViewList1 = new List<EmpView>();
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/MYLeaveSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/MYLeaveSummary.rdlc";
LoadReport(PathString, GYL(ReportsFilterImplementation(fm, _TempViewList1, _ViewList1)));
// LoadReport(PathString, ReportsFilterImplementation(fm, _TempViewListMonthlyDataPer, _ViewListMonthlyDataPer), _dateFrom);
break;
/////////////////////////////////////////////////////////////
/////////////////Summary Reports////////////////////////////
///////////////////////////////////////////////////////////
case "company_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm,_dateFrom,_dateTo,"C"), _dateFrom + " TO " + _dateTo,"Company Consolidated Summary");
break;
case "company_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "C"), _dateFrom + " TO " + _dateTo, "Company Strength Summary");
break;
case "company_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "C"), _dateFrom + " TO " + _dateTo, "Company Work Times Summary");
break;
case "location_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
ReportsFilterImplementation(fm, _dateFrom, _dateTo, "L");
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "L"), _dateFrom + " TO " + _dateTo, "Location Consolidated Summary");
break;
case "location_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "L"), _dateFrom + " TO " + _dateTo, "Location Strength Summary");
break;
case "location_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "L"), _dateFrom + " TO " + _dateTo, "Location Work Times Summary");
break;
case "shift_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "S"), _dateFrom + " TO " + _dateTo, "Shift Consolidated Summary");
break;
case "shift_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "S"), _dateFrom + " TO " + _dateTo, "Shift Strength Summary");
break;
case "shift_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "S"), _dateFrom + " TO " + _dateTo, "Shift Work Times Summary");
break;
case "category_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "A"), _dateFrom + " TO " + _dateTo, "Category Consolidated Summary");
break;
case "category_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "A"), _dateFrom + " TO " + _dateTo, "Category Strength Summary");
break;
case "category_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "A"), _dateFrom + " TO " + _dateTo, "Category Work Times Summary");
break;
case "type_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "T"), _dateFrom + " TO " + _dateTo, "Employee Type Consolidated Summary");
break;
case "type_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "T"), _dateFrom + " TO " + _dateTo, "Employee Type Strength Summary");
break;
case "type_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "T"), _dateFrom + " TO " + _dateTo, "Employee Type Work Times Summary");
break;
case "dept_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "D"), _dateFrom + " TO " + _dateTo, "Department Consolidated Summary");
break;
case "dept_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "D"), _dateFrom + " TO " + _dateTo, "Department Strength Summary");
break;
case "dept_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "D"), _dateFrom + " TO " + _dateTo, "Department Work Times Summary");
break;
case "section_consolidated":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSConsolidated.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSConsolidated.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "E"), _dateFrom + " TO " + _dateTo, "Section Consolidated Summary");
break;
case "section_strength":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSEmpStrength.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSEmpStrength.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "E"), _dateFrom + " TO " + _dateTo, "Section Strength Summary");
break;
case "section_worktimes":
if (GlobalVariables.DeploymentType == false)
PathString = "/Reports/RDLC/DSWorkSummary.rdlc";
else
PathString = "/WMS/Reports/RDLC/DSWorkSummary.rdlc";
LoadReport(PathString, ReportsFilterImplementation(fm, _dateFrom, _dateTo, "E"), _dateFrom + " TO " + _dateTo, "Section Work Times Summary");
break;
}
}
}
public List<EmpPhoto> GetCompanyImages(FiltersModel fm)
{
TAS2013Entities ctx = new TAS2013Entities();
companyimage = new List<EmpPhoto>();
if (fm.CompanyFilter.Count > 1)
{
companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 4785).First());
}
else
{
if (fm.CompanyFilter.Count > 0)
{
int id = Int32.Parse(fm.CompanyFilter.First().ID);
Company comp = ctx.Companies.Where(aa => aa.CompID == id).FirstOrDefault();
companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == comp.ImageID).First());
}
else
{
companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 4785).First());
}
}
return companyimage;
}
internal static FiltersModel Init()
{
if (filterModel == null)
filterModel = new FiltersModel();
return filterModel;
}
private void SaveDepartmentIDs()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewDepartment, Session["FiltersModel"] as FiltersModel, "Department");
Session["FiltersModel"] = FM;
}
/// <summary>
/// This function will remove the id of a specific deparment, company... form the session
/// </summary>
/// <param name="filtersModel"></param>
/// <param name="filterName"></param>
/// <param name="ItemID"></param>
///
private void RemoveObjectFromList(FiltersModel filtersModel, string filterName, string ItemID)
{
switch (filterName)
{
case "Company":
for (int k = 0; k < filtersModel.CompanyFilter.Count; k++)
{
if (filtersModel.CompanyFilter[k].ID == ItemID)
filtersModel.CompanyFilter.RemoveAt(k);
}
break;
case "Division":
for (int k = 0; k < filtersModel.DivisionFilter.Count; k++)
{
if (filtersModel.DivisionFilter[k].ID == ItemID)
filtersModel.DivisionFilter.RemoveAt(k);
}
break;
case "Department":
for (int k = 0; k < filtersModel.DepartmentFilter.Count; k++)
{
if (filtersModel.DepartmentFilter[k].ID == ItemID)
filtersModel.DepartmentFilter.RemoveAt(k);
}
break;
case "Section":
for (int k = 0; k < filtersModel.SectionFilter.Count; k++)
{
if (filtersModel.SectionFilter[k].ID == ItemID)
filtersModel.SectionFilter.RemoveAt(k);
}
break;
case "Location":
for (int k = 0; k < filtersModel.LocationFilter.Count; k++)
{
if (filtersModel.LocationFilter[k].ID == ItemID)
filtersModel.LocationFilter.RemoveAt(k);
}
break;
case "Shift":
for (int k = 0; k < filtersModel.ShiftFilter.Count; k++)
{
if (filtersModel.ShiftFilter[k].ID == ItemID)
filtersModel.ShiftFilter.RemoveAt(k);
}
break;
case "Crew":
for (int k = 0; k < filtersModel.CrewFilter.Count; k++)
{
if (filtersModel.CrewFilter[k].ID == ItemID)
filtersModel.CrewFilter.RemoveAt(k);
}
break;
case "Type":
for (int k = 0; k < filtersModel.TypeFilter.Count; k++)
{
if (filtersModel.TypeFilter[k].ID == ItemID)
filtersModel.TypeFilter.RemoveAt(k);
}
break;
case "Employee":
for (int k = 0; k < filtersModel.EmployeeFilter.Count; k++)
{
if (filtersModel.EmployeeFilter[k].ID == ItemID)
filtersModel.EmployeeFilter.RemoveAt(k);
}
break;
}
}
private static void RemoveObjectFromList(FiltersModel filtersModel, string filterName, string ItemID)
{
switch (filterName)
{
//case "Company":
// for (int k = 0; k < filtersModel.CompanyFilter.Count; k++)
// {
// if (filtersModel.CompanyFilter[k].ID == ItemID)
// filtersModel.CompanyFilter.RemoveAt(k);
// }
// break;
//case "Division":
// for (int k = 0; k < filtersModel.DivisionFilter.Count; k++)
// {
// if (filtersModel.DivisionFilter[k].ID == ItemID)
// filtersModel.DivisionFilter.RemoveAt(k);
// }
// break;
case "Department":
for (int k = 0; k < filtersModel.DepartmentFilter.Count; k++)
{
if (filtersModel.DepartmentFilter[k].ID == ItemID)
{
filtersModel.DepartmentFilter.RemoveAt(k);
}
}
break;
case "Section":
for (int k = 0; k < filtersModel.SectionFilter.Count; k++)
{
if (filtersModel.SectionFilter[k].ID == ItemID)
{
filtersModel.SectionFilter.RemoveAt(k);
}
}
break;
//case "City":
// for (int k = 0; k < filtersModel.CityFilter.Count; k++)
// {
// if (filtersModel.CityFilter[k].ID == ItemID)
// filtersModel.CityFilter.RemoveAt(k);
// }
// break;
case "Location":
for (int k = 0; k < filtersModel.LocationFilter.Count; k++)
{
if (filtersModel.LocationFilter[k].ID == ItemID)
{
filtersModel.LocationFilter.RemoveAt(k);
}
}
break;
case "Shift":
for (int k = 0; k < filtersModel.ShiftFilter.Count; k++)
{
if (filtersModel.ShiftFilter[k].ID == ItemID)
{
filtersModel.ShiftFilter.RemoveAt(k);
}
}
break;
//case "Crew":
// for (int k = 0; k < filtersModel.CrewFilter.Count; k++)
// {
// if (filtersModel.CrewFilter[k].ID == ItemID)
// filtersModel.CrewFilter.RemoveAt(k);
// }
// break;
case "Type":
for (int k = 0; k < filtersModel.TypeFilter.Count; k++)
{
if (filtersModel.TypeFilter[k].ID == ItemID)
{
filtersModel.TypeFilter.RemoveAt(k);
}
}
break;
case "Employee":
for (int k = 0; k < filtersModel.EmployeeFilter.Count; k++)
{
if (filtersModel.EmployeeFilter[k].ID == ItemID)
{
filtersModel.EmployeeFilter.RemoveAt(k);
}
}
break;
case "Reader":
for (int k = 0; k < filtersModel.ReaderFilter.Count; k++)
{
if (filtersModel.ReaderFilter[k].ID == ItemID)
{
filtersModel.ReaderFilter.RemoveAt(k);
}
}
break;
//case "Business":
// for (int k = 0; k < filtersModel.BusinessFilter.Count; k++)
// {
// if (filtersModel.BusinessFilter[k].ID == ItemID)
// filtersModel.BusinessFilter.RemoveAt(k);
// }
// break;
//case "Bank":
// for (int k = 0; k < filtersModel.BanksFilter.Count; k++)
// {
// if (filtersModel.BanksFilter[k].ID == ItemID)
// filtersModel.BanksFilter.RemoveAt(k);
// }
// break;
//case "PaymentMode":
// for (int k = 0; k < filtersModel.PaymentModeFilter.Count; k++)
// {
// if (filtersModel.PaymentModeFilter[k].ID == ItemID)
// filtersModel.PaymentModeFilter.RemoveAt(k);
// }
// break;
case "Designation":
for (int k = 0; k < filtersModel.CMDesignationFilter.Count; k++)
{
if (filtersModel.CMDesignationFilter[k].ID == ItemID)
{
filtersModel.CMDesignationFilter.RemoveAt(k);
}
}
break;
case "Qualification":
for (int k = 0; k < filtersModel.QualificationFilter.Count; k++)
{
if (filtersModel.QualificationFilter[k].ID == ItemID)
{
filtersModel.QualificationFilter.RemoveAt(k);
}
}
break;
case "Domicile":
for (int k = 0; k < filtersModel.DomicileFilter.Count; k++)
{
if (filtersModel.DomicileFilter[k].ID == ItemID)
{
filtersModel.DomicileFilter.RemoveAt(k);
}
}
break;
case "Degree":
for (int k = 0; k < filtersModel.DegreeFilter.Count; k++)
{
if (filtersModel.DegreeFilter[k].ID == ItemID)
{
filtersModel.DegreeFilter.RemoveAt(k);
}
}
break;
case "Institute":
for (int k = 0; k < filtersModel.InstituteFilter.Count; k++)
{
if (filtersModel.InstituteFilter[k].ID == ItemID)
{
filtersModel.InstituteFilter.RemoveAt(k);
}
}
break;
//case "ProductionOrder":
// for (int k = 0; k < filtersModel.ProductionOrderFilter.Count; k++)
// {
// if (filtersModel.ProductionOrderFilter[k].ID == ItemID)
// filtersModel.ProductionOrderFilter.RemoveAt(k);
// }
// break;
}
}
private void SaveShiftIDs()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewShift, Session["FiltersModel"] as FiltersModel, "Shift");
Session["FiltersModel"] = FM;
}
public static void SetGridViewCheckState(GridView gv, FiltersModel filtersModel, string filterName)
{
if (filtersModel == null)
{
return;
}
switch (filterName)
{
case "Department":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DepartmentFilter);
break;
//case "Region":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.RegionFilter);
// break;
case "Section":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.SectionFilter);
break;
//case "Company":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CompanyFilter);
// break;
case "Location":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.LocationFilter);
break;
//case "City":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CityFilter);
// break;
case "Shift":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ShiftFilter);
break;
//case "Division":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DivisionFilter);
// break;
case "Employee":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.EmployeeFilter);
break;
//case "Crew":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CrewFilter);
// break;
case "Type":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.TypeFilter);
break;
case "Reader":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ReaderFilter);
break;
//case "Business":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.BusinessFilter);
// break;
//case "Bank":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.BanksFilter);
// break;
//case "PaymentMode":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.PaymentModeFilter);
// break;
case "Designation":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.CMDesignationFilter);
break;
case "Qualification":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.QualificationFilter);
break;
case "Domicile":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DomicileFilter);
break;
case "Degree":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.DegreeFilter);
break;
case "Institute":
SetGridViewCheckStateChild(gv, filtersModel, filtersModel.InstituteFilter);
break;
//case "ProductionOrder":
// SetGridViewCheckStateChild(gv, filtersModel, filtersModel.ProductionOrderFilter);
// break;
}
}
public List<EmpPhoto> GetCompanyImages(FiltersModel fm)
{
TAS2013Entities ctx = new TAS2013Entities();
companyimage = new List<EmpPhoto>();
companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 4785).First());
return companyimage;
}
private void SaveDepartmentIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewWing, Session["FiltersModel"] as FiltersModel, "Department");
Session["FiltersModel"] = FM;
}
/// <summary>
/// This function takes FiltersModel and an empty list of AttDeptSummary as input and
/// gives a populated AttDeptSummary as output. If there is any dept selected in the filter
/// it will iterate through all the departments if there is no dept selected it will try to
/// find all the depts of the company.
/// </summary>
/// <param name="fm"> FiltersModel </param>
/// <param name="attDeptList">Empty List of AttDeptSummary</param>
/// <returns>Populated List of AttDeptSummary</returns>
public List<AttDeptSummary> GetListForAttDepartmentsSummary(FiltersModel fm, string _dateFrom,string _dateTo)
{
List<AttDeptSummary> attDeptList = new List<AttDeptSummary>();
TAS2013Entities db = new TAS2013Entities();
//To get the query from the db
QueryBuilder qb = new QueryBuilder();
//Get the Department filters
List<FiltersAttributes> departments = new List<FiltersAttributes>();
departments = fm.DepartmentFilter;
//if more then 0 it means some departments are selected now we iterate over them and see
//how many employee does one dept has. The table empView is the most suitable db for this case.
if (departments.Count > 0)
{
//do nothing still cater for it in future there might be a need
}
//if there is no department list in the filter then first get the company's department and then do the same as above.
else
{
foreach (var comp in fm.CompanyFilter)
{
int compID = Convert.ToInt16(comp.ID);
List<Department> depts = db.Departments.Where(aa => aa.CompanyID == compID).ToList();
foreach (var dept in depts)
departments.Add(new FiltersAttributes() { ID=dept.DeptID + "", FilterName=dept.DeptName });
}
}
//NOw run the departments if they are from the department filter or from the company itself
foreach (var dept in departments)
{
DataTable dt = qb.GetValuesfromDB("select * from EmpView where DeptID=" + dept.ID);
List<EmpView> EmView = dt.ToList<EmpView>();
//2015-01-24
foreach (DateTime day in EachDay(Convert.ToDateTime(_dateFrom), Convert.ToDateTime(_dateTo)))
{
AttDeptSummary singleInstance = new AttDeptSummary();
singleInstance.Department = dept.FilterName;
singleInstance.TotalStrength = EmView.Count();
singleInstance.Total = singleInstance.TotalStrength;
singleInstance.Location = EmView.FirstOrDefault().LocName;
singleInstance.Section = EmView.FirstOrDefault().SectionName;
singleInstance.Company = EmView.FirstOrDefault().CompName;
singleInstance.CardSwapped = 0;
singleInstance.Absent = 0;
singleInstance.OnLeave = 0;
string dynamicQueryForEmps = GetDynamicQueryForEmps(EmView);
string queryForCardSwapped = "select * from AttData where (TimeIn is not null AND AttDate = '" + day + "') AND ";
string queryForAbsent = "select * from AttData where (StatusAB = 1 AND AttDate = '" + day + "') AND ";
string queryOnLeave = "select * from AttData where (StatusHL = 1 OR StatusLeave =1 AND StatusSL=1 AND AttDate = '" + day + "') AND ";
queryForCardSwapped = queryForCardSwapped + dynamicQueryForEmps;
singleInstance.CardSwapped = qb.GetValuesfromDB(queryForCardSwapped).ToList<AttData>().Count();
queryForAbsent = queryForAbsent + dynamicQueryForEmps;
singleInstance.Absent = qb.GetValuesfromDB(queryForAbsent).ToList<AttData>().Count(); queryOnLeave = queryOnLeave + dynamicQueryForEmps;
singleInstance.OnLeave = qb.GetValuesfromDB(queryOnLeave).ToList<AttData>().Count();
//foreach (var emp in EmView)
//{
//s= singleInstance.CardSwapped + db.AttDatas.Where(aa => aa.TimeIn != null && aa.AttDate == day && aa.EmpID == emp.EmpID).Count();
//singleInstance.Absent = singleInstance.Absent+ db.AttDatas.Where(aa => aa.StatusAB == true && aa.AttDate == day && aa.EmpID == emp.EmpID).Count();
//singleInstance.OnLeave = singleInstance.OnLeave + db.AttDatas.Where(aa => (aa.StatusHL == true || aa.StatusLeave == true || aa.StatusSL == true) && aa.AttDate == day && aa.EmpID == emp.EmpID).Count();
//}
singleInstance.date = day;
attDeptList.Add(singleInstance);
}
}
return attDeptList;
}
private List<CriteriaFoAngular> GetInitialValuesFromFilters(FiltersModel fm)
{
List<CriteriaFoAngular> populateData = new List<CriteriaFoAngular>();
// CriteriaFoAngular cfa = new CriteriaFoAngular();
if (fm.CompanyFilter.Count > 0)
populateData.Add(new CriteriaFoAngular("C","Company"));
if (fm.LocationFilter.Count > 0)
populateData.Add(new CriteriaFoAngular("L", "Location"));
if (fm.SectionFilter.Count > 0)
populateData.Add(new CriteriaFoAngular("E", "Section"));
if (fm.ShiftFilter.Count > 0)
populateData.Add(new CriteriaFoAngular("S", "Shift"));
if (fm.DepartmentFilter.Count > 0)
populateData.Add(new CriteriaFoAngular("D", "Department"));
return populateData;
}
private List<VMPosting> ReportsFilterImplementation(FiltersModel fm, List<VMPosting> _TempVMPosting, List<VMPosting> _VMPosting)
{
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempVMPosting.AddRange(_VMPosting.Where(aa => aa.OLocationID == _locID).ToList());
}
_VMPosting = _TempVMPosting.ToList();
}
else
_TempVMPosting = _VMPosting.ToList();
_TempVMPosting.Clear();
return _VMPosting;
}
private static void SetGridViewCheckStateChild(GridView gv, FiltersModel filtersModel, List<FiltersAttributes> list)
{
if (list == null)
return;
for(int j = 0; j < gv.Rows.Count; j++)
{
bool chk = false;
for (int i = 0; i < list.Count; i++)
{
if (list[i].ID == gv.Rows[j].Cells[1].Text)
{
chk = true;
}
}
((CheckBox)gv.Rows[j].FindControl("CheckOne")).Checked = chk;
}
}
private void SaveRegionIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewRegion, Session["FiltersModel"] as FiltersModel, "Region");
Session["FiltersModel"] = FM;
}
private void AddObjectToList(FiltersModel filtersModel, string filterName, string ItemID, string ItemName)
{
switch (filterName)
{
case "Company":
if (filtersModel.CompanyFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.CompanyFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Division":
if (filtersModel.DivisionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.DivisionFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Department":
if (filtersModel.DepartmentFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.DepartmentFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Section":
if (filtersModel.SectionFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.SectionFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Location":
if (filtersModel.LocationFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.LocationFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Shift":
if (filtersModel.ShiftFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.ShiftFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Type":
if (filtersModel.TypeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.TypeFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Employee":
if (filtersModel.EmployeeFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.EmployeeFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
case "Crew":
if (filtersModel.CrewFilter.Where(aa => aa.ID == ItemID).Count() == 0)
filtersModel.CrewFilter.Add(new FiltersAttributes() { ID = ItemID, FilterName = ItemName });
break;
}
}
private void SaveShiftIDs()
{
WMSLibrary.FiltersModel FM = WMSLibrary.Filters.SyncGridViewIDs(GridViewShift, Session["FiltersModel"] as FiltersModel, "Shift");
Session["FiltersModel"] = FM;
}
public List<EmpPhoto> GetCompanyImages(FiltersModel fm)
{
TAS2013Entities ctx = new TAS2013Entities();
companyimage = new List<EmpPhoto>();
companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 454).First());
return companyimage;
//if (fm.CompanyFilter.Count > 1)
//{
// companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 4785).First());
//}
//else
//{
// if (fm.CompanyFilter.Count > 0)
// {
// int id = Int32.Parse(fm.CompanyFilter.First().ID);
// Company comp = ctx.Companies.Where(aa => aa.CompID == id).FirstOrDefault();
// //here there is no ImageID of comp thats why it throws exception, so thats why i m commenting out.
// //companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == comp.ImageID).First());
// }
// else
// {
// companyimage.Add(ctx.EmpPhotoes.Where(aa => aa.PhotoID == 4785).First());
// }
//}
}
private void SaveInstituteIDs()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewInstitute, Session["FiltersModel"] as FiltersModel, "Institute");
Session["FiltersModel"] = FM;
}
private void SaveDivisionIDs()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewDivision, Session["FiltersModel"] as FiltersModel, "Division");
Session["FiltersModel"] = FM;
}
private void BindGridViewDegree()
{
WMSLibrary.Filters filterHelper = new WMSLibrary.Filters();
WMSLibrary.FiltersModel FM = filterHelper.SyncGridViewIDs(GridViewDegree, Session["FiltersModel"] as FiltersModel, "Degree");
Session["FiltersModel"] = FM;
}
private List<DailySummary> ReportsFilterImplementation(FiltersModel fm,string dateFrom,string dateTo, string Criteria)
{
List<DailySummary> ViewDS = new List<DailySummary>();
List<DailySummary> TempDS = new List<DailySummary>();
QueryBuilder qb = new QueryBuilder();
DataTable dt = new DataTable();
switch (Criteria)
{
case "C":
//for company
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _compID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
case "L":
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _locID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
case "D":
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _deptID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
case "E":
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _secID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
case "S":
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _shiftID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
case "T":
dt = qb.GetValuesfromDB("select * from DailySummary " + " where Criteria = '"+Criteria + "' and (Date >= " + "'" + dateFrom + "'" + " and Date <= " + "'"
+ dateTo + "'" + " )");
ViewDS = dt.ToList<DailySummary>();
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _typeID && aa.Criteria == Criteria).ToList());
}
ViewDS = TempDS.ToList();
}
else
TempDS = ViewDS.ToList();
TempDS.Clear();
break;
//case "A":
// if (fm.CompanyFilter.Count > 0)
// {
// foreach (var comp in fm.CompanyFilter)
// {
// short _compID = Convert.ToInt16(comp.ID);
// TempDS.AddRange(ViewDS.Where(aa => aa.CriteriaValue == _compID && aa.Criteria == Criteria).ToList());
// }
// ViewDS = TempDS.ToList();
// }
// else
// TempDS = ViewDS.ToList();
// TempDS.Clear();
// break;
}
return ViewDS;
}
/// <summary>
/// This function will remove the id of a specific deparment, company... form the session
/// </summary>
/// <param name="filtersModel"></param>
/// <param name="filterName"></param>
/// <param name="ItemID"></param>
///
public static FiltersModel DeleteSingleFilter(FiltersModel fml, string id,string filtername)
{
RemoveObjectFromList(fml, filtername, id);
return fml;
}
//ViewMonthlyDataPer
public List<ViewMonthlyDataPer> ReportsFilterImplementation(FiltersModel fm, List<ViewMonthlyDataPer> _TempViewList, List<ViewMonthlyDataPer> _ViewList)
{
//for company
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.CompanyID == _compID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for location
if (fm.LocationFilter.Count > 0)
{
foreach (var loc in fm.LocationFilter)
{
short _locID = Convert.ToInt16(loc.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.LocID == _locID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for shifts
if (fm.ShiftFilter.Count > 0)
{
foreach (var shift in fm.ShiftFilter)
{
short _shiftID = Convert.ToInt16(shift.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.ShiftID == _shiftID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for type
if (fm.TypeFilter.Count > 0)
{
foreach (var type in fm.TypeFilter)
{
short _typeID = Convert.ToInt16(type.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.TypeID == _typeID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for crews
if (fm.CrewFilter.Count > 0)
{
foreach (var cre in fm.CrewFilter)
{
short _crewID = Convert.ToInt16(cre.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.CrewID == _crewID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for division
if (fm.DivisionFilter.Count > 0)
{
foreach (var div in fm.DivisionFilter)
{
short _divID = Convert.ToInt16(div.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.DivID == _divID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for department
if (fm.DepartmentFilter.Count > 0)
{
foreach (var dept in fm.DepartmentFilter)
{
short _deptID = Convert.ToInt16(dept.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.DeptID == _deptID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//for sections
if (fm.SectionFilter.Count > 0)
{
foreach (var sec in fm.SectionFilter)
{
short _secID = Convert.ToInt16(sec.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.SecID == _secID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
//Employee
if (fm.EmployeeFilter.Count > 0)
{
foreach (var emp in fm.EmployeeFilter)
{
int _empID = Convert.ToInt32(emp.ID);
_TempViewList.AddRange(_ViewList.Where(aa => aa.EmpID == _empID).ToList());
}
_ViewList = _TempViewList.ToList();
}
else
_TempViewList = _ViewList.ToList();
_TempViewList.Clear();
return _ViewList;
}
public static bool UserHasValuesInSession(FiltersModel fm)
{
bool check = false;
if (fm.CompanyFilter.Count > 0)
check = true;
if (fm.LocationFilter.Count > 0)
check = true;
if (fm.DivisionFilter.Count > 0)
check = true;
if (fm.CityFilter.Count > 0)
check = true;
if (fm.RegionFilter.Count > 0)
check = true;
if (fm.ShiftFilter.Count > 0)
check = true;
if (fm.WingFilter.Count > 0)
check = true;
if (fm.SectionFilter.Count > 0)
check = true;
if (fm.TypeFilter.Count > 0)
check = true;
if (fm.CrewFilter.Count > 0)
check = true;
if (fm.EmployeeFilter.Count > 0)
check = true;
return check;
}
