Ejemplo n.º 1
0
        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
            }));
        }