C# Models.TAS2013Entities类代码示例

        //
        // GET: /AttProcessors/Create
        public ActionResult Create()
        {
            TAS2013Entities db = new TAS2013Entities();
            User LoggedInUser = Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            String query = qb.QueryForCompanyViewLinq(LoggedInUser);
            ViewBag.PeriodTag = new SelectList(new List<SelectListItem>
            {
                new SelectListItem { Selected = true, Text = "Daily", Value = "D"},
                new SelectListItem { Selected = false, Text = "Monthly", Value = "M"},
                new SelectListItem { Selected = false, Text = "Summary", Value = "S"},

            }, "Value" , "Text",1);
            ViewBag.CriteriaID = new SelectList(new List<SelectListItem>
            {
                new SelectListItem { Selected = true, Text = "Company", Value = "C"},
                new SelectListItem { Selected = false, Text = "Location", Value = "L"},

            }, "Value", "Text", 1);
            ViewBag.ProcessCats = new SelectList(new List<SelectListItem>
            {
                new SelectListItem { Selected = true, Text = "Yes", Value = "1"},
                new SelectListItem { Selected = false, Text = "No", Value = "0"},

            }, "Value", "Text", 1);
            ViewBag.CompanyID = new SelectList(db.Companies.Where(query).OrderBy(s=>s.CompName), "CompID", "CompName");
            query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
            ViewBag.LocationID = new SelectList(db.Locations.Where(query).OrderBy(s=>s.LocName), "LocID", "LocName");

            ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName");
             return View();
        }

        public string CheckForUserRole(User user)
        {
            string val = "";
            using (var ctx = new TAS2013Entities())
            {
                string criteria = ctx.UserAccesses.Where(aa => aa.UserID == user.UserID).FirstOrDefault().Criteria;
                switch (criteria.Trim())
                {
                    case "Z":
                        val = "Zone";
                        break;

                    case "R":
                        val="Region";
                        break;
                    case "C":
                        val = "City";
                        break;
                    case "L":
                        val = "Location";
                        break;
                        case "S":
                        val = "SuperUser";
                        break;
                }
                ctx.Dispose();
            }
            return val;
        }

 public ActionResult Create()
 {
     var _wings = new List<Division>();
     using (TAS2013Entities context = new TAS2013Entities())
     {
         _wings = context.Divisions.ToList();
     }
     ViewBag.CompanyID = new SelectList(db.Companies.OrderBy(aa=>aa.CompName), "CompID", "CompName");
     ViewBag.CrewID = new SelectList(db.Crews.OrderBy(aa => aa.CrewName), "CrewID", "CrewName");
     ViewBag.DesigID = new SelectList(db.Designations.OrderBy(aa => aa.DesignationName), "DesignationID", "DesignationName");
     ViewBag.GradeID = new SelectList(db.Grades.OrderBy(aa => aa.GradeName), "GradeID", "GradeName");
     ViewBag.JobID = new SelectList(db.JobTitles.OrderBy(aa => aa.JobTitle1), "JobID", "JobTitle1");
     //ViewBag.LocID = new SelectList(db.Locations, "LocID", "LocName");
     ViewBag.SecID = new SelectList(db.Sections.OrderBy(aa => aa.SectionName), "SectionID", "SectionName");
     ViewBag.ShiftID = new SelectList(db.Shifts.OrderBy(aa => aa.ShiftName), "ShiftID", "ShiftName");
     ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(aa => aa.TypeName), "TypeID", "TypeName");
     ViewBag.EmpID = new SelectList(db.EmpFaces, "EmpID", "Face1");
     ViewBag.EmpID = new SelectList(db.EmpFps.OrderBy(aa => aa.Fp1), "EmpID", "Fp1");
     ViewBag.CatID = new SelectList(db.Categories.OrderBy(aa => aa.CatName), "CatID", "CatName");
     ViewBag.DeptID = new SelectList(db.Departments.OrderBy(aa => aa.DeptName), "DeptID", "DeptName");
     ViewBag.CityID = new SelectList(db.Cities.OrderBy(aa => aa.CityName), "CityID", "CityName");
     ViewBag.ZoneID = new SelectList(db.Zones.OrderBy(aa => aa.ZoneName), "ZoneID", "ZoneName");
     ViewBag.RegionID = new SelectList(db.Regions.OrderBy(aa => aa.RegionName), "RegionID", "RegionName");
     ViewBag.PostedAsID = new SelectList(db.Designations.OrderBy(aa => aa.DesignationName), "DesignationID", "DesignationName");
     return View();
 }

        public void AddHalfLeaveToLeaveData(LvApplication lvappl)
        {
            DateTime datetime = new DateTime();
            datetime = lvappl.FromDate;
            string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd");
            LvData _LVData = new LvData();
            _LVData.EmpID = lvappl.EmpID;
            _LVData.EmpDate = _EmpDate;
            _LVData.Remarks = lvappl.LvReason;
            _LVData.HalfLeave = true;
            _LVData.LvID = lvappl.LvID;
            _LVData.AttDate = datetime.Date;
            _LVData.LvCode = lvappl.LvType;
            _LVData.FirstHalf = lvappl.FirstHalf;
            try
            {
                using (var db = new TAS2013Entities())
                {
                    db.LvDatas.Add(_LVData);
                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {

            }
            // Balance Leaves from Emp Table
            BalanceLeaves(lvappl);
        }

 public int UploadImageInDataBase(HttpPostedFileBase file, string _empNo)
 {
     using (var context = new TAS2013Entities())
     {
         List<EmpPhoto> _empPhotoList = new List<EmpPhoto>();
         EmpPhoto _EmpPhoto = new EmpPhoto();
         Emp _Emp = new Emp();
         int empPhotoID = 0;
         _Emp = context.Emps.First(aa => aa.EmpNo == _empNo);
         _empPhotoList = context.EmpPhotoes.Where(aa => aa.EmpID == _Emp.EmpID).ToList();
         _EmpPhoto.EmpPic = ConvertToBytes(file);
         if (_empPhotoList.Count > 0)
         {
             //Update Existing Image
             _EmpPhoto.EmpID = _empPhotoList.FirstOrDefault().EmpID;
             _EmpPhoto.PhotoID = _empPhotoList.FirstOrDefault().PhotoID;
         }
         else
         {
             //Add New Image
             _EmpPhoto.EmpID = _Emp.EmpID;
             context.EmpPhotoes.Add(_EmpPhoto);
         }
         try
         {
             empPhotoID = _EmpPhoto.PhotoID;
             context.SaveChanges();
             return empPhotoID;
         }
         catch (Exception ex)
         {
             return empPhotoID;
         }
     }
 }

        public ActionResult GetBestCriteria(string CriteriaValue)
        {
            List<DailySummary> BestCriteria = new List<DailySummary>();
            using (TAS2013Entities dc = new TAS2013Entities())
            {
                DateTime To = (DateTime)dc.DailySummaries.Max(x => x.Date);
                DateTime From = To.AddDays(-20);
                var GetSummaries = dc.DailySummaries.Where(aa => aa.Criteria == CriteriaValue && (aa.Date >= From && aa.Date <= To)).ToList();
                var DistinctCriterias = GetSummaries.Select(aa => new { aa.CriteriaValue }).Distinct().ToList();
                foreach (var distinctcriteria in DistinctCriterias)
                {
                    DailySummary gatherinfo = new DailySummary();

                    List<DailySummary> intermediate = GetSummaries.Where(aa => aa.CriteriaValue == distinctcriteria.CriteriaValue).ToList();
                    gatherinfo = InitializeDailySummaryValues(intermediate);

                    foreach (DailySummary inter in intermediate)
                    {
                        gatherinfo = AddValues(gatherinfo, inter);

                    }
                    BestCriteria.Add(gatherinfo);

                }
            }
            Console.Write(CriteriaValue);
            return Json(BestCriteria, JsonRequestBehavior.AllowGet);
        }

        private void LoadSession()
        {
            using (TAS2013Entities dc = new TAS2013Entities())
            {
               var v = dc.Users.Where(aa => aa.UserName == "wms.ffl").FirstOrDefault();
                if (v != null)
                {
                    Session["MDevice"] = "0";
                    Session["MHR"] = "0";
                    Session["MDevice"] = "0";
                    Session["MLeave"] = "0";
                    Session["MEditAtt"] = "0";
                    Session["MUser"] = "0";
                    Session["LogedUserFullname"] = "";
                    Session["UserCompany"] = "";
                    Session["MRDailyAtt"] = "0";
                    Session["MRLeave"] = "0";
                    Session["MRMonthly"] = "0";
                    Session["MRAudit"] = "0";
                    Session["MRManualEditAtt"] = "0";
                    Session["MREmployee"] = "0";
                    Session["MRDetail"] = "0";
                    Session["MRSummary"] = "0";
                    Session["LogedUserID"] = v.UserID.ToString();
                    Session["LogedUserFullname"] = v.UserName;
                    Session["LoggedUser"] = v;
                    Session["UserCompany"] = v.CompanyID.ToString();
                    if (v.MHR == true)
                        Session["MHR"] = "1";
                    if (v.MDevice == true)
                        Session["MDevice"] = "1";
                    if (v.MLeave == true)
                        Session["MLeave"] = "1";
                    if (v.MEditAtt == true)
                        Session["MEditAtt"] = "1";
                    if (v.MUser == true)
                        Session["MUser"] = "1";
                    if (v.MRDailyAtt == true)
                        Session["MRDailyAtt"] = "1";
                    if (v.MRLeave == true)
                        Session["MRLeave"] = "1";
                    if (v.MRMonthly == true)
                        Session["MRMonthly"] = "1";
                    if (v.MRAudit == true)
                        Session["MRAudit"] = "1";
                    if (v.MRManualEditAtt == true)
                        Session["MRManualEditAtt"] = "1";
                    if (v.MREmployee == true)
                        Session["MREmployee"] = "1";
                    if (v.MRDetail == true)
                        Session["MRDetail"] = "1";
                    if (v.MRSummary == true)
                        Session["MRSummary"] = "1";
                    if (v.MRoster == true)
                        Session["MRoster"] = "1";

                }
            }
        }

        public string MakeCustomizeQuery(User _user)
        {
            string query = " where ";
            string subQuery = "";
            string subQueryLoc = "";
            List<string> _Criteria = new List<string>();
            List<string> _CriteriaForOr = new List<string>();
            List<string> _CriteriaForOrLoc = new List<string>();
               TAS2013Entities db = new TAS2013Entities();
            List<UserAccess> ulocs = new List<UserAccess>();
            ulocs = db.UserAccesses.Where(aa => aa.UserID == _user.UserID).ToList();
            foreach (var uloc in ulocs)
            {
                if(uloc.Criteria.Trim() == "Z")
                _CriteriaForOrLoc.Add(" ZoneID = " + uloc.CriteriaData + " ");
                if (uloc.Criteria.Trim() == "R")
                    _CriteriaForOrLoc.Add(" RegionID = " + uloc.CriteriaData + " ");
                if (uloc.Criteria.Trim() == "C")
                    _CriteriaForOrLoc.Add(" CityID = " + uloc.CriteriaData + " ");
                if (uloc.Criteria.Trim() == "L")
                    _CriteriaForOrLoc.Add(" LocID = " + uloc.CriteriaData + " ");
                if (uloc.Criteria.Trim() == "S")
                    query = "";
                if (uloc.Criteria.Trim() == "")
                {

                    query = "";
                return query;

                }
            }

            for (int i = 0; i < _CriteriaForOrLoc.Count - 1; i++)
            {
                subQueryLoc = subQueryLoc + _CriteriaForOrLoc[i] + " or ";
            }
            if(_CriteriaForOrLoc.Count>0)
            subQueryLoc = " ( " + subQueryLoc + _CriteriaForOrLoc[_CriteriaForOrLoc.Count - 1] + " ) ";

            //subQuery = " ( ";
            //for (int i = 0; i < _CriteriaForOr.Count - 1; i++)
            //{
            //    subQuery = subQuery + _CriteriaForOr[i] + " or ";
            //} if (_CriteriaForOr.Count > 0)
            //subQuery = subQuery + _CriteriaForOr[_CriteriaForOr.Count - 1];
            //subQuery = subQuery + " ) ";
            query = query + subQueryLoc;
            return query;
        }

        protected void btnlogin_Click(object sender, EventArgs e)
        {
            TAS2013Entities context = new TAS2013Entities();
            //lbError.Text = "";
            List<User> _User = context.Users.ToList();

            //Request.Cookies[user]
            if (tbUserName.Text != "" && tbPassword.Text != "")
            {
             foreach (var item in _User)
                {
                    if (item.UserName.ToUpper() == tbUserName.Text.ToUpper())
                    {
                        if (item.Password.ToUpper() == tbPassword.Text.ToUpper())
                        {
                            if (item.RoleID == 2 || item.RoleID == 3)
                            {
                                Response.Redirect("/WMS/Reports/ReportHome.aspx");
                                Session["RoleID"] = "Rpt";
                                //SaveAuditLogEntry(item.UserID, item.UserName);
                            }
                            else
                            {
                                Response.Redirect("~/Home");
                                if (item.RoleID == 4)
                                {
                                    Session["RoleID"] = "Entry";
                                }
                                //SaveAuditLogEntry(item.UserID, item.UserName);
                            }
                            if (item.RoleID == 5)
                            {
                                Session["RoleID"] = "Admin";
                            }
                        }
                        else
                        {
                            //lbError.Text = "*Password doesnot match";
                        }
                    }
                    else
                    {
                        //lbError.Text = "*Username is not valid";
                    }
                }
            }
        }

        public void AddHalfLeaveToAttData(LvApplication lvappl)
        {
            DateTime datetime = new DateTime();
            datetime = lvappl.FromDate;
            string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd");
            using (var db = new TAS2013Entities())
            {
                if (db.AttProcesses.Where(aa => aa.ProcessDate == datetime).Count() > 0)
                {
                    AttData _EmpAttData = new AttData();
                    _EmpAttData = db.AttDatas.First(aa => aa.EmpDate == _EmpDate);
                    if (lvappl.LvType == "A")//Casual Leave
                        _EmpAttData.Remarks = _EmpAttData.Remarks+"[H-CL]";
                    if (lvappl.LvType == "B")//Anual Leave
                        _EmpAttData.Remarks = _EmpAttData.Remarks+"[H-AL]";
                    if (lvappl.LvType == "C")//Sick Leave
                        _EmpAttData.Remarks = _EmpAttData.Remarks+"[H-SL]";

                    if (_EmpAttData.Remarks.Contains("[Absent]"))
                        _EmpAttData.Remarks.Replace("[Abesnt]", "");
                    if (_EmpAttData.Remarks.Contains("[EO]"))
                        _EmpAttData.Remarks.Replace("[EO]", "-");
                    if (_EmpAttData.Remarks.Contains("[LI]"))
                        _EmpAttData.Remarks.Replace("[LI]", "");
                    _EmpAttData.StatusLeave = true;
                    if (lvappl.FirstHalf == true)
                    {
                        _EmpAttData.LateIn = 0;
                        _EmpAttData.StatusLI = false;
                    }
                    else
                    {
                        _EmpAttData.StatusEO = false;
                        _EmpAttData.EarlyOut = 0;
                    }
                    //_EmpAttData.statushl

                    db.SaveChanges();
                }
            }
        }

        public ActionResult Create()
        {
            var _wings = new List<Division>();
            using (TAS2013Entities context = new TAS2013Entities())
            {
                _wings = context.Divisions.ToList();
            }

            ViewBag.CrewID = new SelectList(db.Crews.OrderBy(s => s.CrewName), "CrewID", "CrewName");
            ViewBag.DesigID = new SelectList(db.Designations.OrderBy(s => s.DesignationName), "DesignationID", "DesignationName");
            ViewBag.GradeID = new SelectList(db.Grades.OrderBy(s=>s.GradeName), "GradeID", "GradeName");
            ViewBag.JobID = new SelectList(db.JobTitles.OrderBy(s=>s.JobTitle1), "JobID", "JobTitle1");
            ViewBag.LocID = new SelectList(db.Locations.OrderBy(s=>s.LocName), "LocID", "LocName");
            ViewBag.SecID = new SelectList(db.Sections.OrderBy(s=>s.SectionName), "SectionID", "SectionName");
            ViewBag.ShiftID = new SelectList(db.Shifts.OrderBy(s=>s.ShiftName), "ShiftID", "ShiftName");
            ViewBag.TypeID = new SelectList(db.EmpTypes.OrderBy(s=>s.TypeName), "TypeID", "TypeName");
            ViewBag.EmpID = new SelectList(db.EmpFaces.OrderBy(s=>s.Face1), "EmpID", "Face1");
            ViewBag.EmpID = new SelectList(db.EmpFps.OrderBy(s=>s.Fp1), "EmpID", "Fp1");
            ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName");
            ViewBag.DeptID = new SelectList(db.Departments.OrderBy(s=>s.DeptName), "DeptID", "DeptName");
            return View();
        }

        public ActionResult GetCriteriaNames(string Criteria)
        {
            List<CriteriaFoAngular> GetValueNames = new List<CriteriaFoAngular>();
            using (TAS2013Entities dc = new TAS2013Entities())
            {
                FiltersModel fm = Session["FiltersModel"] as FiltersModel;
                if (Criteria == "C")
                {
                    foreach (var company in fm.CompanyFilter)
                        GetValueNames.Add(new CriteriaFoAngular("" + company.ID, company.FilterName));

                }
                if (Criteria == "L")
                {
                    foreach (var location in fm.LocationFilter)
                        GetValueNames.Add(new CriteriaFoAngular("" + location.ID, location.FilterName));
                }
                if (Criteria == "S")
                {
                    foreach (var shift in fm.ShiftFilter)
                        GetValueNames.Add(new CriteriaFoAngular("" + shift.ID, shift.FilterName));
                }
                if (Criteria == "E")
                {
                    foreach (var section in fm.SectionFilter)
                        GetValueNames.Add(new CriteriaFoAngular("" + section.ID, section.FilterName));
                }
                if (Criteria == "D")
                {
                    foreach (var department in fm.DepartmentFilter)
                        GetValueNames.Add(new CriteriaFoAngular("" + department.ID, department.FilterName));
                }
                //var getSummaries = dc.DailySummaries.Where(aa => aa.Criteria == Criteria).Select(aa => new { aa.CriteriaValue, aa.CriteriaName }).Distinct().ToList();
                return Json(
                              GetValueNames.ToArray()

                         , JsonRequestBehavior.AllowGet);
            }
        }

        public int UploadImageInDataBase(HttpPostedFileBase file, Emp _Emp)
        {
            using (var context = new TAS2013Entities())
            {
                List<EmpPhoto> _empPhotoList = new List<EmpPhoto>();
                EmpPhoto _EmpPhoto = new EmpPhoto();
                int empPhotoID = 0;

                _empPhotoList = context.EmpPhotoes.Where(aa => aa.EmpID == _Emp.EmpID).ToList();
                _EmpPhoto.EmpPic = ConvertToBytes(file);
                if (_empPhotoList.Count > 0)
                {
                    _EmpPhoto.PhotoID = _empPhotoList.FirstOrDefault().PhotoID;
                    _empPhotoList.FirstOrDefault().EmpPic = _EmpPhoto.EmpPic;
                    context.EmpPhotoes.Attach(_empPhotoList.FirstOrDefault());
                    context.Entry(_empPhotoList.FirstOrDefault()).State = EntityState.Modified;
                    context.SaveChanges();

                }
                else
                {
                    //Add New Image
                    _EmpPhoto.EmpID = _Emp.EmpID;
                    context.EmpPhotoes.Add(_EmpPhoto);
                }
                try
                {

                    empPhotoID = _EmpPhoto.PhotoID;
                    context.SaveChanges();
                    return empPhotoID;
                }
                catch (Exception ex)
                {
                    return empPhotoID;
                }
            }
        }

 internal string QueryForShiftForLinq(User LoggedInUser)
 {
     TAS2013Entities db = new TAS2013Entities();
     List<UserLocation> ulocs = new List<UserLocation>();
     List<string> _CriteriaForOrLoc = new List<string>();
     ulocs = db.UserLocations.Where(aa => aa.UserID == LoggedInUser.UserID).ToList();
     string query = "";
     foreach (var uloc in ulocs)
     {
         _CriteriaForOrLoc.Add(" LocationID = " + uloc.LocationID + " ");
     }
     for (int i = 0; i < _CriteriaForOrLoc.Count - 1; i++)
     {
         query = query + _CriteriaForOrLoc[i] + " or ";
     }
     query = query + _CriteriaForOrLoc[_CriteriaForOrLoc.Count - 1];
     return query;
 }

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