Hi ,
i have a web api like this :
public class CardsController : ApiController
{
[Route("{teamId}/metrics/{memberId}")]
public List GetCards(int teamId,int memberId)
{
//Send the list of cards associated with the team. Also send member previous rating and team average rating of past 7 days
throw new NotImplementedException();
}
in that given a teamId and memberId it goes to the Vote table and gets last Voted value and last Vote date time and card details also
this is my CardData Model :
public class CardData
{
public int CardID { get; set; }
public string CardName { get; set; }
public string CardDescription { get; set; }
public CardRatingData CardRating { get; set; }
}
and this is CardRatingData Model :
public class CardRatingData
{
public int MemberPreviousRating { get; set; }
public DateTime MemberPreviousRatingDateTime { get; set; }
public double TeamAverage7DayRating { get; set; }
}
this is my tables structure :
in that i want to implement using linq to sql stored procedure
please give a code for that.
thank you.
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Gowtham KPosted Aug 28, 2015, 4:32 AM