public List <RequestSubmitModel> RequestSubmitList()
{
GenericPattern <DataAccessLayer.DataModel.RequestSubmit> _tblList = new GenericPattern <DataAccessLayer.DataModel.RequestSubmit>();
List <RequestSubmitModel> _ModelList = new List <RequestSubmitModel>();
var varData = _tblList.GetAll().ToList();
_ModelList = (from item in varData
select new RequestSubmitModel
{
Id = item.Id,
}).OrderByDescending(x => x.Id).ToList();
return(_ModelList);
}
public List <CourseTestModel> CourseTestList()
{
GenericPattern <Course_Test> _tbl_CourseTest = new GenericPattern <Course_Test>();
List <CourseTestModel> _CourseTestList = new List <CourseTestModel>();
var CourseTestData = _tbl_CourseTest.GetAll().ToList();
_CourseTestList = (from item in CourseTestData
select new CourseTestModel
{
Id = item.Id,
}).OrderByDescending(x => x.Id).ToList();
return(_CourseTestList);
}
public List <CourseSessionModel> CourseSessionList()
{
GenericPattern <CourseSession> _tbl_CourseSession = new GenericPattern <CourseSession>();
List <CourseSessionModel> _SessionList = new List <CourseSessionModel>();
var CourseSessionData = _tbl_CourseSession.GetAll().ToList();
_SessionList = (from item in CourseSessionData
select new CourseSessionModel
{
Id = item.Id,
}).OrderByDescending(x => x.Id).ToList();
return(_SessionList);
}
public List <RequestTypeModel> RequestTypeList()
{
GenericPattern <RequestType> _tbl_RequestType = new GenericPattern <RequestType>();
List <RequestTypeModel> _RequestTypeModelList = new List <RequestTypeModel>();
var RequestTypeData = _tbl_RequestType.GetAll().ToList();
_RequestTypeModelList = (from item in RequestTypeData
select new RequestTypeModel
{
Id = item.Id,
Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_RequestTypeModelList);
}
public List <UserModel> UserList()
{
GenericPattern <User> _tbl_User = new GenericPattern <User>();
List <UserModel> _UserList = new List <UserModel>();
var UserData = _tbl_User.GetAll().ToList();
_UserList = (from item in UserData
select new UserModel
{
Id = item.Id,
Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_UserList);
}
public List <MasjidModel> MasjidList()
{
GenericPattern <Masjid> _tbl_Masjid = new GenericPattern <Masjid>();
List <MasjidModel> _MasjidList = new List <MasjidModel>();
var MasjidData = _tbl_Masjid.GetAll().ToList();
_MasjidList = (from item in MasjidData
select new MasjidModel
{
Id = item.Id,
Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_MasjidList);
}
public List <RequestSubmitModel> RequestSubmitList()
{
GenericPattern <RequestSubmit> _tbl_RequestSubmit = new GenericPattern <RequestSubmit>();
List <RequestSubmitModel> _RequestSubmitModelList = new List <RequestSubmitModel>();
var RequestSubmitData = _tbl_RequestSubmit.GetAll().ToList();
_RequestSubmitModelList = (from item in RequestSubmitData
select new RequestSubmitModel
{
//Id = item.Id,
//Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_RequestSubmitModelList);
}
public List <MadarsaModel> MadarsaList()
{
GenericPattern <Madarsa> _tblList = new GenericPattern <Madarsa>();
List <MadarsaModel> _ModelList = new List <MadarsaModel>();
var varData = _tblList.GetAll().ToList();
_ModelList = (from item in varData
select new MadarsaModel
{
Id = item.Id,
Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_ModelList);
}
public List <ZoneModel> ZoneList()
{
GenericPattern <Zone> _tbl_Zone = new GenericPattern <Zone>();
List <ZoneModel> _ZoneList = new List <ZoneModel>();
var ZoneData = _tbl_Zone.GetAll().ToList();
_ZoneList = (from item in ZoneData
select new ZoneModel
{
Id = item.Id,
Name = item.Name,
}).OrderByDescending(x => x.Id).ToList();
return(_ZoneList);
}
public List <AddMadarsaCommittee> AddMadarsaCommitteeList()
{
GenericPattern <tbl_AddMadarsaCommittee> _tbl_AddMadarsaCommittee = new GenericPattern <tbl_AddMadarsaCommittee>();
List <AddMadarsaCommittee> _AddMadarsaCommitteeList = new List <AddMadarsaCommittee>();
var Varial = _tbl_AddMadarsaCommittee.GetAll().ToList();
_AddMadarsaCommitteeList = (from item in Varial
select new AddMadarsaCommittee
{
Id = item.Id,
CommitteeName = item.CommitteeName,
}).OrderByDescending(x => x.Id).ToList();
return(_AddMadarsaCommitteeList);
}
public List <AddMasjid> AddMasjidList()
{
GenericPattern <tbl_AddMasjid> _tbl_AddMasjid = new GenericPattern <tbl_AddMasjid>();
List <AddMasjid> _AddMasjidList = new List <AddMasjid>();
var Varial = _tbl_AddMasjid.GetAll().ToList();
_AddMasjidList = (from item in Varial
select new AddMasjid
{
Id = item.Id,
MasjidName = item.MasjidName,
}).OrderByDescending(x => x.Id).ToList();
return(_AddMasjidList);
}
public List <AddHalqa> HalqaList()
{
GenericPattern <tbl_AddHalqa> _tbl_AddHalqa = new GenericPattern <tbl_AddHalqa>();
List <AddHalqa> _AddHalqaList = new List <AddHalqa>();
var AddHalqaData = _tbl_AddHalqa.GetAll().ToList();
_AddHalqaList = (from item in AddHalqaData
select new AddHalqa
{
Id = item.Id,
HalqaName = item.HalqaName,
Area = item.Area,
CreatedDate = item.CreatedDate,
CreatedBy = item.CreatedBy,
Status = item.Status
}).OrderByDescending(x => x.Id).ToList();
return(_AddHalqaList);
}
public List <AddMasjidCommittee> MasjidCommitteeList()
{
GenericPattern <tbl_AddMasjidCommittee> _tbl_AddMasjidCommittee = new GenericPattern <tbl_AddMasjidCommittee>();
List <AddMasjidCommittee> _AddMasjidCommitteeList = new List <AddMasjidCommittee>();
var AddMasjidCommitteeData = _tbl_AddMasjidCommittee.GetAll().ToList();
_AddMasjidCommitteeList = (from item in AddMasjidCommitteeData
select new AddMasjidCommittee
{
Id = item.Id,
CommitteeName = item.CommitteeName,
MasjidId = item.MasjidId,
MasjidName = (item.tbl_AddMasjid != null) ? item.tbl_AddMasjid.MasjidName : string.Empty,
CreatedDate = item.CreatedDate,
CreatedBy = item.CreatedBy,
Status = item.Status
}).OrderByDescending(x => x.Id).ToList();
return(_AddMasjidCommitteeList);
}
public List <User> UserList()
{
GenericPattern <tbl_User> _tbl_User = new GenericPattern <tbl_User>();
List <User> _UserList = new List <User>();
var UserData = _tbl_User.GetAll().ToList();
_UserList = (from item in UserData
select new User
{
Id = item.Id,
Name = item.Name,
Mobile = item.Mobile,
Email = item.Email,
Password = item.Password,
Area = item.Area,
CreatedDate = item.CreatedDate,
CreatedBy = item.CreatedBy,
Status = item.Status
}).OrderByDescending(x => x.Id).ToList();
return(_UserList);
}
public List <AddMasjid> MasjidList()
{
List <AddMasjid> _AddmasjidList = new List <AddMasjid>();
GenericPattern <tbl_AddMasjid> _tbl_AddMasjid = new GenericPattern <tbl_AddMasjid>();
var AddmasjidData = _tbl_AddMasjid.GetAll().ToList();
_AddmasjidList = (from item in AddmasjidData
select new AddMasjid
{
Id = item.Id,
MasjidName = item.MasjidName,
SadarUserId = item.SadarUserId,
SadarUserName = (item.tbl_User != null) ? item.tbl_User.Name : string.Empty,
HalqaId = item.HalqaId,
HalqaName = (item.tbl_AddHalqa != null) ? item.tbl_AddHalqa.HalqaName : string.Empty,
Lattitude = item.Lattitude,
Longitude = item.Longitude,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedDate,
Status = item.Status
}).OrderByDescending(x => x.Id).ToList();
return(_AddmasjidList);
}
public List <AddMadarsa> MadarsaList()
{
GenericPattern <tbl_AddMadarsa> _tbl_AddMadarsa = new GenericPattern <tbl_AddMadarsa>();
List <AddMadarsa> _AddMadarsaList = new List <AddMadarsa>();
var AddMadarsaData = _tbl_AddMadarsa.GetAll().ToList();
_AddMadarsaList = (from item in AddMadarsaData
select new AddMadarsa
{
Id = item.Id,
MadarsaName = item.MadarsaName,
HeadUserId = item.HeadUserId,
HeadUserName = (item.tbl_User != null) ? item.tbl_User.Name : string.Empty,
HalqaId = item.HalqaId,
HalqaName = (item.tbl_AddHalqa != null) ? item.tbl_AddHalqa.HalqaName : string.Empty,
Latitude = item.Latitude,
Longitude = item.Longitude,
CreatedDate = item.CreatedDate,
CreatedBy = item.CreatedBy,
Status = item.Status
}).OrderByDescending(x => x.Id).ToList();
return(_AddMadarsaList);
}