public List <Review> GetReviewInvitesByUserId(int id)
{
CompanyContext cc = new CompanyContext();
List <Review> reviews = new List <Review>();
string query = "SELECT * FROM Review where User_Id = " + id + " AND IsInvite = true";
using (var conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(query, conn))
{
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
int userid = (int)reader["User_Id"];
Review review = new Review()
{
Function = (string)reader["Function"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Company = cc.GetCompanyById((int)reader["Company_Id"]),
};
AccountContext _accountContext = new AccountContext();
Account account = _accountContext.GetAccountById(userid);
review.Account = account;
reviews.Add(review);
}
}
}
}
return(reviews);
}
}
public List <Review> GetReviewsById(int id)
{
List <Review> reviews = new List <Review>();
string query = "SELECT * FROM Review where User_Id = " + id + "";
using (var conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(query, conn))
{
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
int userid = (int)reader["User_Id"];
Review review = new Review()
{
Function = (string)reader["Function"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Overall = (int)reader["Overall"],
Explanation = (string)reader["Explanation"],
};
AccountContext _accountContext = new AccountContext();
Account account = _accountContext.GetAccountById(userid);
review.Account = account;
reviews.Add(review);
}
}
}
}
return(reviews);
}
}