public ActionResult UpdateConcreteReport(int id) { ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int)); ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string)); var userId = Convert.ToInt32(Session["UserId"].ToString()); var factoryName = db.Factory11.Where(f => f.Id == id).Select(x => x.Name).FirstOrDefault(); var sampleNumber = from s in db.ConcreteSample1 join v in db.VisitDetails on s.SampledBy equals v.MonitorId where v.MonitorId == userId && DbFunctions.DiffDays(v.VisitDate, DateTime.Now) == 1 && v.FactoryId == id && s.FactoryName == factoryName select new List <long?> { s.SampleNumber }; var lst = sampleNumber.ToList(); var receivedSample = lst.Count() > 0?db.UpdateConcreteReport(sampleNumber.FirstOrDefault().FirstOrDefault(), statusCode, statusMessage):0; return(RedirectToAction("Home", "Home", new { id = 1 })); }