internal List <string> GetProductListFromDB(long selectedCategoryId)
{
GiveBackDBEntities db = new GiveBackDBEntities();
List <string> productList = new List <string>();
var resultsFromDB = (from a in db.ProductResources
join b in db.Requirements on a.ReqId equals b.ReqId
where b.ReceiverId == selectedCategoryId
select a.Name).Distinct().ToList();
foreach (var item in resultsFromDB)
{
productList.Add(item.ToString());
}
return(productList);
}
public List <MappedRequirementViewModel> ProductRequirementMapping(SpecifyParametersViewModel specifyParametersViewModel)
{
List <MappedRequirementViewModel> mappedRequirementViewModel = new List <MappedRequirementViewModel>();
// Business Logic here
GiveBackDBEntities db = new GiveBackDBEntities();
var pviewModel = new List <ProductReqViewModel>();
var resultsFromDB = (from a in db.OrgDetails
join b in db.Requirements on a.OrgId equals b.OrgId
join c in db.ProductResources on b.ReqId equals c.ReqId
where c.Quantity >= specifyParametersViewModel.UserMentionedQuantity &&
c.Name == specifyParametersViewModel.SelectedProductName &&
b.ResourceId == (long)specifyParametersViewModel.SelectedResource &&
b.ReceiverId == specifyParametersViewModel.SelectedcategoryId
select new { a.OrgId, a.OrgName, a.url, a.Address, a.Contact, b.ResourceId, b.ReceiverId, b.Description, c.ReqId, c.Unit, c.Quantity, c.Name });
foreach (var item in resultsFromDB)
{
pviewModel.Add(new ProductReqViewModel
{
SelectedCategory = specifyParametersViewModel.SelectedcategoryId,
SelectedCategoryName = specifyParametersViewModel.SelectedCategoryName,
SelectedResource = specifyParametersViewModel.SelectedResource,
OrganizationName = item.OrgName,
OrgAddress = item.Address,
OrgContact = item.Contact,
OrgUrl = item.url,
ProgramDescription = item.Description,
ProductName = item.Name,
Unit = item.Unit,
ProductQuantity = Int64.Parse(item.Quantity.ToString()),
UserMentionedQuantity = specifyParametersViewModel.UserMentionedQuantity
});
}
if (pviewModel.Count != 0)
{
foreach (var item in pviewModel)
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
SelectedcategoryId = item.SelectedCategory,
SelectedCategoryName = item.SelectedCategoryName,
SelectedResource = item.SelectedResource,
OrganizationName = item.OrganizationName,
OrganizationAddress = item.OrgAddress,
OrganizationContact = item.OrgContact,
OrgUrl = item.OrgUrl,
ProgramDescription = item.ProgramDescription,
ProductName = item.ProductName,
ProductUnit = item.Unit,
AvailableQuantity = item.ProductQuantity,
UserMentionedQuantity = item.UserMentionedQuantity,
resultsFound = true
});
}
}
else
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
resultsFound = false
});
}
return(mappedRequirementViewModel);
}
public List <MappedRequirementViewModel> MoneyRequirementMapping(SpecifyParametersViewModel specifyParametersViewModel)
{
List <MappedRequirementViewModel> mappedRequirementViewModel = new List <MappedRequirementViewModel>();
// Business Logic here
GiveBackDBEntities db = new GiveBackDBEntities();
var mviewModel = new List <MoneyReqViewModel>();
var resultsFromDB = (from a in db.OrgDetails
join b in db.Requirements on a.OrgId equals b.OrgId
join c in db.MoneyResources on b.ReqId equals c.ReqId
where c.AmountTotal >= specifyParametersViewModel.DonationAmount &&
b.ResourceId == (long)specifyParametersViewModel.SelectedResource &&
b.ReceiverId == specifyParametersViewModel.SelectedcategoryId
select new { a.OrgId, a.OrgName, a.url, a.Address, a.Contact, b.ResourceId, b.ReceiverId, b.Description, c.ReqId, c.AmountTotal, c.AmountRemaining });
foreach (var item in resultsFromDB)
{
mviewModel.Add(new MoneyReqViewModel
{
SelectedCategory = specifyParametersViewModel.SelectedcategoryId,
SelectedCategoryName = specifyParametersViewModel.SelectedCategoryName,
SelectedResource = specifyParametersViewModel.SelectedResource,
OrganizationName = item.OrgName,
OrganizationAddress = item.Address,
OrganizationContact = item.Contact,
OrgUrl = item.url,
ProgramDescription = item.Description,
DonationAmount = Int32.Parse(specifyParametersViewModel.DonationAmount.ToString()),
AmountTotal = Int32.Parse(item.AmountTotal.ToString()),
AmountRemaining = Int32.Parse(item.AmountRemaining.ToString())
});
}
if (mviewModel.Count != 0)
{
foreach (var item in mviewModel)
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
SelectedcategoryId = item.SelectedCategory,
SelectedCategoryName = item.SelectedCategoryName,
SelectedResource = (ResourceTypes)item.SelectedResource,
OrganizationName = item.OrganizationName,
OrganizationAddress = item.OrganizationAddress,
OrganizationContact = item.OrganizationContact,
OrgUrl = item.OrgUrl,
ProgramDescription = item.ProgramDescription,
DonationAmount = item.DonationAmount,
AmountTotal = item.AmountTotal,
AmountRemaining = item.AmountRemaining,
resultsFound = true
});
}
}
else
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
resultsFound = false
});
}
return(mappedRequirementViewModel);
}
public List <MappedRequirementViewModel> TimeRequirementMapping(SpecifyParametersViewModel specifyParametersViewModel)
{
List <MappedRequirementViewModel> mappedRequirementViewModel = new List <MappedRequirementViewModel>();
// Business Logic here
GiveBackDBEntities db = new GiveBackDBEntities();
var tviewModel = new List <TimeReqViewModel>();
var startTime = DateTime.Parse(specifyParametersViewModel.StartTime.SelectedTime.ToString());
var startDate = specifyParametersViewModel.StartDate.Add(startTime.TimeOfDay);
var resultsFromDB = (from a in db.OrgDetails
join b in db.Requirements on a.OrgId equals b.OrgId
join c in db.TimeResources on b.ReqId equals c.ReqId
where c.StartDate <= startDate &&
c.EndDate >= specifyParametersViewModel.EndDate
//&& c.ManHoursPerDay >= specifyParametersViewModel.HoursPerDate
&& b.ResourceId == (long)specifyParametersViewModel.SelectedResource &&
b.ReceiverId == specifyParametersViewModel.SelectedcategoryId
select new { a.OrgId, a.OrgName, a.url, a.Address, a.Contact, b.ResourceId, b.ReceiverId, b.Description, c.StartDate, c.EndDate, c.StartTime, c.ManHoursPerDay });
foreach (var item in resultsFromDB)
{
tviewModel.Add(new TimeReqViewModel
{
SelectedCategory = specifyParametersViewModel.SelectedcategoryId,
SelectedResource = specifyParametersViewModel.SelectedResource,
SelectedCategoryName = specifyParametersViewModel.SelectedCategoryName,
OrganizationName = item.OrgName,
ProgramDescription = item.Description,
OrgAddress = item.Address,
OrgContact = item.Contact,
OrgUrl = item.url,
StartDate = (DateTime)(item.StartDate),
EndDate = (DateTime)(item.EndDate),
StartTime = (DateTime)(item.StartTime),
ManHoursPerDay = item.ManHoursPerDay
});
}
if (tviewModel.Count != 0)
{
foreach (var item in tviewModel)
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
SelectedcategoryId = item.SelectedCategory,
SelectedCategoryName = item.SelectedCategoryName,
SelectedResource = item.SelectedResource,
OrganizationName = item.OrganizationName,
ProgramDescription = item.ProgramDescription,
OrganizationAddress = item.OrgAddress,
OrganizationContact = item.OrgContact,
OrgUrl = item.OrgUrl,
StartDate = item.StartDate,
EndDate = item.EndDate,
StartTime = item.StartTime,
HoursPerDate = item.ManHoursPerDay,
resultsFound = true
});
}
}
else
{
mappedRequirementViewModel.Add(new MappedRequirementViewModel
{
resultsFound = false
});
}
return(mappedRequirementViewModel);
}
