Beispiel #1
0
        public static List <Complaint> GetAllByAdhar(string Adhar)
        {
            List <Complaint> list = null;

            list = BaseDataAccess.GetRecordsList <Complaint>(String.Format("select * from Complaints where ReportingPersonAdhaarId='{0}' ", Adhar));
            foreach (Complaint info in list)
            {
                info.State = StateDA.GetDetails(info.StateId);
                info.City  = CityDA.GetDetails(info.CityId);
                if (info.VillageId != 0)
                {
                    info.Village = VillageDA.GetDetails(info.VillageId);
                }
                info.Locality        = LocalityDA.GetDetails(info.LocalityId);
                info.DepartmentType  = DepartmentTypeDA.GetDetails(info.DepartmentTypeId);
                info.ComplaintType   = ComplaintTypeDA.GetDetails(info.ComplaintTypeId);
                info.ComplaintStatus = ComplaintStatusDA.GetDetails(info.CurrentStatusId);
            }
            return(list);
        }
Beispiel #2
0
        public static List <Complaint> GetAllByDateRange(int departmentId)
        {
            List <Complaint> list = null;

            list = BaseDataAccess.GetRecordsList <Complaint>(String.Format("select * from Complaints where departmentId={0}", departmentId));
            foreach (Complaint info in list)
            {
                info.State = StateDA.GetDetails(info.StateId);
                info.City  = CityDA.GetDetails(info.CityId);
                if (info.VillageId != 0)
                {
                    info.Village = VillageDA.GetDetails(info.VillageId);
                }
                info.Locality        = LocalityDA.GetDetails(info.LocalityId);
                info.DepartmentType  = DepartmentTypeDA.GetDetails(info.DepartmentTypeId);
                info.ComplaintType   = ComplaintTypeDA.GetDetails(info.ComplaintTypeId);
                info.ComplaintStatus = ComplaintStatusDA.GetDetails(info.CurrentStatusId);
            }
            return(list);
        }
Beispiel #3
0
        public static Complaint GetDetails(int id)
        {
            Complaint info = null;

            info = BaseDataAccess.GetRecords <Complaint>(String.Format("select * from Complaints where Id='{0}' ", id));
            if (info != null)
            {
                info.State = StateDA.GetDetails(info.StateId);
                info.City  = CityDA.GetDetails(info.CityId);
                if (info.VillageId != 0)
                {
                    info.Village = VillageDA.GetDetails(info.VillageId);
                }
                info.Locality        = LocalityDA.GetDetails(info.LocalityId);
                info.DepartmentType  = DepartmentTypeDA.GetDetails(info.DepartmentTypeId);
                info.ComplaintType   = ComplaintTypeDA.GetDetails(info.ComplaintTypeId);
                info.ComplaintStatus = ComplaintStatusDA.GetDetails(info.CurrentStatusId);
                info.Department      = DepartmentDA.GetDetails(info.DepartmentId);
            }
            return(info);
        }