public HttpResponseMessage fetchallissues()
{
using (var context = new problemupdatedbEntities())
{
var data = context.user_table.
Join
(
context.issue_table,
user_table => user_table.user_id,
issue_table => issue_table.user_table.user_id,
(user_table, issue_table) => new
{
IssueImage = issue_table.IssueImage,
UserImage = user_table.profile_pic,
UserName = user_table.name,
IssueDate = issue_table.IssueDate,
IssueStatement = issue_table.issueStatement,
IssueLatitude = issue_table.locationLatitude,
IssueLongitude = issue_table.locationLongitude,
Issueflag = issue_table.issueFlag,
IssueType = issue_table.issueType,
estimatedCost = issue_table.estimated_cost,
amountCollected = issue_table.amount_collected,
isworkingstarted = issue_table.isWorkingStarted,
isResolved = issue_table.isresolved,
IssueId = issue_table.issue_id,
location_name = issue_table.location_name,
WorkingStatus = issue_table.WorkingStatus
}).Where(x => x.WorkingStatus != "Resolved" && x.WorkingStatus != "Conflict").ToList();
return(Request.CreateResponse(HttpStatusCode.Accepted, data));
}
}
public HttpResponseMessage getfundbyid(int id)
{
using (var context = new problemupdatedbEntities())
{
var data = context.issue_table.
Join
(
context.funds_table,
issue_table => issue_table.issue_id,
funds_table => funds_table.issue_table.issue_id,
(issue_table, funds_table) => new
{
user_id = funds_table.user_id,
issue_id = funds_table.issue_id,
funds_id = funds_table.funds_id,
amount = funds_table.amount,
issueStatement = issue_table.issueStatement,
Location_name = issue_table.location_name,
fund_date = funds_table.fund_date,
estimated_cost = issue_table.estimated_cost,
//balance_payment = issue_table.balance_payment
}).Where(x => x.funds_id == id).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.Accepted, data));
}
}
public HttpResponseMessage fetchallassignedissues()
{
problemupdatedbEntities dbContext = new problemupdatedbEntities();
var entryPoint = (from assignedtable in dbContext.AssignedByAdmin
join volunteertable in dbContext.Volunteer_table on assignedtable.volunteer_id equals volunteertable.volunteer_id
join issuetable in dbContext.issue_table on assignedtable.issue_id equals issuetable.issue_id
select new
{
volunteer_id = assignedtable.volunteer_id,
user_id = issuetable.user_id,
issue_id = assignedtable.issue_id,
issueStatement = issuetable.issueStatement,
location_name = issuetable.location_name
}).ToList();
return(Request.CreateResponse(HttpStatusCode.Accepted, entryPoint));
}
