public List <ResultModel> GetResult()
{
List <ResultModel> objResultModel = new List <ResultModel>();
StabileLawFirmEntities dbentity = new StabileLawFirmEntities();
var result = (from s in dbentity.STtblUsers
join sa in dbentity.STtblResults on s.tblUserId equals sa.tblUserId
select new
{
tblResultId = sa.tblResultId,
tblUserId = sa.tblUserId,
UserName = s.UserName,
Result_Date = sa.Result_Date,
Result_Heading = sa.Result_Heading,
Result_Text = sa.Result_Text,
Name = s.Name
}).OrderByDescending(l => l.Result_Date).Take(3).ToList();
int i = 0;
var images = "";
foreach (var item in result)
{
if (i == 0)
{
images = "images/home/9.jpg";
}
if (i == 1)
{
images = "images/home/10.jpg";
}
if (i == 2)
{
images = "images/home/11.jpg";
}
i = i + 1;
objResultModel.Add(new ResultModel
{
tblResultId = item.tblResultId,
tblUserId = item.tblUserId,
UserName = item.UserName,
Result_Date = item.Result_Date,
Date = Convert.ToDateTime(item.Result_Date).ToShortDateString(),
Result_Heading = item.Result_Heading,
Result_Text = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 400)),
Result_Text_st = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 140)),
Name = item.Name,
Result_Heading_st = item.Result_Heading.Substring(0, Math.Min(item.Result_Heading.Length, 40)),
Image = images,
day = (Convert.ToDateTime(item.Result_Date).Day),
Month = (Convert.ToDateTime(item.Result_Date).ToString("MMMM").Substring(0, 3)),
year = (Convert.ToDateTime(item.Result_Date).Year),
});
}
return(objResultModel);
}
public List <Result> GetAllResult()
{
List <Result> objResultModel = new List <Result>();
StabileLawFirmEntities dbentity = new StabileLawFirmEntities();
var result = (from s in dbentity.STtblUsers
join sa in dbentity.STtblResults on s.tblUserId equals sa.tblUserId
select new
{
tblResultId = sa.tblResultId,
tblUserId = sa.tblUserId,
UserName = s.UserName,
Result_Date = sa.Result_Date,
Result_Heading = sa.Result_Heading,
Result_Text = sa.Result_Text,
Name = s.Name
}).OrderByDescending(l => l.Result_Date).ToList();
foreach (var item in result)
{
objResultModel.Add(new Result
{
tblResultId = item.tblResultId,
tblUserId = item.tblUserId,
UserName = item.UserName,
Result_Date = item.Result_Date,
Date = Convert.ToDateTime(item.Result_Date).ToShortDateString(),
Result_Heading = item.Result_Heading,
Result_Text = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 400)),
//Result_Text_st = item.Result_Text.Substring(0, Math.Min(item.Result_Text.Length, 140)),
Name = item.Name,
//Result_Heading_st = item.Result_Heading.Substring(0, Math.Min(item.Result_Heading.Length, 40)),
//day = (Convert.ToDateTime(item.Result_Date).Day),
//Month = (Convert.ToDateTime(item.Result_Date).ToString("MMMM").Substring(0, 3)),
//year = (Convert.ToDateTime(item.Result_Date).Year),
});
}
return(objResultModel);
}
