public CollectionPointDetail getCollectionPointByDepId(string depId)  //To get collection point
        {
            Department            d = getDepartmentByDepId(depId);
            string                collectionPointId = d.CollectionPointID;
            CollectionPointDetail c = context.CollectionPointDetails.Where(x => x.CollectionPointID == collectionPointId).FirstOrDefault();

            return(c);
        }
        public bool updateCollectionTime(string cp, string ct)
        {
            bool r = false;

            CollectionPointDetail d = new CollectionPointDetail();

            d = (from x in context.CollectionPointDetails
                 where x.CollectionPoint.Equals(cp)
                 select x).First();

            if (d != null)
            {
                d.CollectionTime = ct;
                context.SaveChanges();
                r = true;
            }
            return(r);
        }
        public string getCollectionTime(string depId)//To get collection time
        {
            CollectionPointDetail cp = getCollectionPointByDepId(depId);

            return(cp.CollectionTime);
        }
        public string getCollectionpoint(string depId)//To get collection point object
        {
            CollectionPointDetail cp = getCollectionPointByDepId(depId);

            return(cp.CollectionPoint);
        }