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