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); }