public List<DepartmentDisbDetails> getDisbyStatus(string status, DateTime date)
        {
            DateTime checkdate = new DateTime();
            checkdate = date;
            List<DepartmentDisbDetails> finaldisbist = new List<DepartmentDisbDetails>();
            List<object> dlist = new List<object>();
            List<object> ditems = new List<object>();
            stationeryEntities db = new stationeryEntities();
            List<CustomDepartmentDisb> custdepdiblidt = new List<CustomDepartmentDisb>();
            custdepdiblidt = db.getDepForDisb1(checkdate, status).ToList<CustomDepartmentDisb>();
            foreach (CustomDepartmentDisb dep in custdepdiblidt)
            {
                DepartmentDisbDetails depitem = new DepartmentDisbDetails();
                depitem.DepID = dep.DepID;
                depitem.DepName = dep.DepName;
                depitem.DepCPName = dep.CollectionPointName;
                depitem.DepDisID = dep.DisbID;
                depitem.DepDisbItems = db.getDisbItemsByDep(dep.DepID, status, checkdate).ToList<object>();
                finaldisbist.Add(depitem);
            }

            return finaldisbist;
        }