//Change collection point
        public void changeCollectionPoint(BriefDept2 briefDept2)
        {
            string deptCode            = briefDept2.deptCode;
            string collectionPointName = briefDept2.collectionPointName;

            var p = context.CollectionPoint.Where(x => x.CollectionPointName == collectionPointName).First();
            int newCollectionPointId = p.CollectionPointId;

            var        q = context.Department.Where(x => x.DepartmentCode == deptCode).First();
            Department d = new Department();

            d = q;
            d.CollectionPointId = newCollectionPointId;

            TimeSpan cutoff = TimeSpan.Parse("17:30"); // 5.30 PM
            TimeSpan now    = DateTime.Now.TimeOfDay;

            if (DateTime.Now.DayOfWeek == DayOfWeek.Tuesday || DateTime.Now.DayOfWeek == DayOfWeek.Wednesday || DateTime.Now.DayOfWeek == DayOfWeek.Thursday || (DateTime.Now.DayOfWeek == DayOfWeek.Friday && now <= cutoff))
            {
                var t = context.DisbursementList.Where(x => x.DepartmentCode == deptCode && x.Status == "Pending Delivery");
                if (t.Any())
                {
                    DisbursementList dl = new DisbursementList();
                    dl = t.First();
                    dl.CollectionPointId = newCollectionPointId;
                }
            }
            context.SaveChanges();
        }
        //List collection points
        public List <BriefDept2> listCollectionPoints()
        {
            var q = context.CollectionPoint.ToList();
            List <BriefDept2> list = new List <BriefDept2>();

            foreach (CollectionPoint current in q)
            {
                BriefDept2 b = new BriefDept2();
                b.collectionPointId   = current.CollectionPointId;
                b.collectionPointName = current.CollectionPointName;
                list.Add(b);
            }
            return(list);
        }
        //Get current collection point
        public BriefDept2 currentCollectionPoint(string dept)
        {
            var        q = context.Department.Where(x => x.DepartmentCode == dept).First();
            int        collectionPointId = q.CollectionPointId;
            BriefDept2 d = new BriefDept2();

            d.deptCode          = dept;
            d.collectionPointId = collectionPointId;
            var    t = context.CollectionPoint.Where(x => x.CollectionPointId == collectionPointId).First();
            string collectionPointName = t.CollectionPointName;

            d.collectionPointName = collectionPointName;

            return(d);
        }
 public void ChangeCollectionPoint(BriefDept2 briefDept2)
 {
     b.changeCollectionPoint(briefDept2);
 }