public List <MasjidConstruction> MasjidConstructionList()
{
List <MasjidConstruction> _masjidconst_localVar = new List <MasjidConstruction>();
var var_masjidconst = _tbl_MasjidConstruction.FindBy(x => x.Status == true).ToList();
_masjidconst_localVar = (from _Exvar in var_masjidconst
select new MasjidConstruction
{
Id = _Exvar.Id,
Area = _Exvar.Area,
Head = _Exvar.Head,
ConstructionCost = _Exvar.ConstructionCost,
Floors = _Exvar.Floors,
AmountCollected = _Exvar.AmountCollected,
EngineerName = _Exvar.EngineerName,
EngineerContact = _Exvar.EngineerContact,
PlanImg = _Exvar.PlanImg,
// ElevationImg = _Exvar.ElevationImg,
ConstructionImg1 = _Exvar.ConstructionImg1,
Location = _Exvar.Location,
ConstructionImg2 = _Exvar.ConstructionImg2,
ConstructionImg3 = _Exvar.ConstructionImg3,
Status = _Exvar.Status,
UserId = _Exvar.UserId,
Name = (_Exvar.tbl_User != null) ? _Exvar.tbl_User.Name : string.Empty,
//CommitteeId = _Exvar.CommitteeId,
//CommitteeName = (_Exvar.tbl_AddMasjidCommittee != null) ? _Exvar.tbl_AddMasjidCommittee.CommitteeName : string.Empty,
}).OrderByDescending(x => x.Id).ToList();
return(_masjidconst_localVar);
}
public List <ProductModel> ProductList(ProductModel _ProductModel)
{
List <ProductModel> _productList = new List <ProductModel>();
var productList = _Product.FindBy(m => m.IsActive == true);
if (!string.IsNullOrWhiteSpace(_ProductModel.ProductName))
{
productList = productList.Where(m => m.ProductName.ToLower().Contains(_ProductModel.ProductName.ToLower()));
}
productList = productList ?? new List <Product>();
_productList = (from item in productList
select new ProductModel
{
ID = item.ID,
ProductName = item.ProductName,
CategoryId = Convert.ToInt32(item.CategoryId),
Description = item.Description,
Price = Convert.ToDecimal(item.Price),
Image = item.Image,
ImageType = item.ImageType,
CategoryName = (item.Category != null) ? item.Category.CategoryName : string.Empty,
Quantity = 1
}).ToList();
return(_productList);
}
public bool IsAlreadyExists(PanelInvolvementModel model)
{
var GetList = _PanelInvolvement.FindBy(m => m.UserTypeId == model.UserTypeId && m.RequestSubmitId == model.RequestSubmitId);
if (GetList != null && GetList.Any())
{
return(true);
}
else
{
return(false);
}
}
public List <UserModel> GetUserTypesByMainUserType(int mainUserType)
{
List <UserModel> _UserModelList = new List <UserModel>();
var UserTypeList = tbl_UserType.FindBy(m => m.MainUserType == mainUserType);
if (UserTypeList != null && UserTypeList.Any())
{
_UserModelList = (from @item in UserTypeList
select new UserModel
{
UserTypeId = @item.Id
}).ToList();
}
return(_UserModelList);
}
public List <AddHalqa> HalqaList()
{
List <AddHalqa> _AddHalqaList = new List <AddHalqa>();
var AddHalqaData = _tbl_AddHalqa.FindBy(x => x.Status == true).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 <NewMadarsaOperation> NewMadarsaOperationList()
{
List <NewMadarsaOperation> _NewMadOp_LV = new List <NewMadarsaOperation>();
var var_LV = _tbl_NewMadarsaOperations.FindBy(x => x.Status == true);
_NewMadOp_LV = (from item in var_LV
select new NewMadarsaOperation
{
Id = item.Id,
HeadMasterName = item.HeadMasterName,
Head = item.Head,
ExpectedStudents = item.ExpectedStudents,
Boys = item.Boys,
Girls = item.Girls,
Teachers = item.Teachers,
Residential = item.Residential,
MonthlyCost = item.MonthlyCost,
PerStudentCost = item.PerStudentCost,
SourceofRevenue = item.SourceofRevenue,
Location = item.Location,
Address = item.Address,
OwnRented = item.OwnRented,
TotalLandArea = item.TotalLandArea,
ConstructedArea = item.ConstructedArea,
ChargingStudent = item.ChargingStudent,
Howmuch = item.Howmuch,
Picture1 = item.Picture1,
Picture2 = item.Picture2,
Picture3 = item.Picture3,
Picture4 = item.Picture4,
Status = item.Status,
UserId = item.UserId,
Name = (item.tbl_User != null) ? item.tbl_User.Name : string.Empty,
CommitteeId = item.CommitteeId,
CommitteeName = (item.tbl_AddMadarsaCommittee != null) ? item.tbl_AddMadarsaCommittee.CommitteeName : string.Empty,
Contact = (item.tbl_User != null) ? item.tbl_User.Mobile : string.Empty,
RequestId = item.RequestId,
}).OrderByDescending(x => x.Id).ToList();
return(_NewMadOp_LV);
}
public List <ExistingMadarsaOperations> _ExistingMadarsaOperarionList()
{
List <ExistingMadarsaOperations> _EMO_localVar = new List <ExistingMadarsaOperations>();
var var_EMO = _tbl_ExistingMadarsaOperations.FindBy(x => x.Status == true).ToList();
_EMO_localVar = (from _Exvar in var_EMO
select new ExistingMadarsaOperations
{
Id = _Exvar.Id,
HeadMasterName = _Exvar.HeadMasterName,
Head = _Exvar.Head,
ExpectedStudents = _Exvar.ExpectedStudents,
Boys = _Exvar.Boys,
Girls = _Exvar.Girls,
Teachers = _Exvar.Teachers,
Residential = _Exvar.Residential,
MonthlyCost = _Exvar.MonthlyCost,
PerStudentCost = _Exvar.PerStudentCost,
SourceofRevenue = _Exvar.SourceofRevenue,
Location = _Exvar.Location,
Address = _Exvar.Address,
OwnRented = _Exvar.OwnRented,
TotalLandArea = _Exvar.TotalLandArea,
ConstructedArea = _Exvar.ConstructedArea,
ChargingStudent = _Exvar.ChargingStudent,
Howmuch = _Exvar.Howmuch,
Picture1 = _Exvar.Picture1,
Picture2 = _Exvar.Picture2,
Picture3 = _Exvar.Picture3,
Picture4 = _Exvar.Picture4,
Status = _Exvar.Status,
CommitteeId = _Exvar.CommitteeId,
CommitteeName = (_Exvar.tbl_AddMadarsaCommittee != null) ? _Exvar.tbl_AddMadarsaCommittee.CommitteeName : string.Empty,
}).OrderByDescending(x => x.Id).ToList();
return(_EMO_localVar);
}