public ResultModel <List <MagfaModel> > GLNsCount(ServicesReportModel model) { try { var DX = new EntitiesContext(); var dt = new DataTable(); var _FromDate = new DateTime?(); var _ToDate = new DateTime?(); if (model != null && model.FromDate != null && model.FromDate != "") { _FromDate = Convert.ToDateTime(Convert.ToDateTime(_FromDate).ToShortDateString()); } if (model != null && model.FromDate != null && model.FromDate != "") { _ToDate = Convert.ToDateTime(Convert.ToDateTime(_ToDate).ToShortDateString()); } dt = DX.ExecuteStoredProcedure(DX, "GLNsCountReport", new[] { new SqlParameter("@FromDate", _FromDate), //new SqlParameter("@StatusID", model.StatusID), new SqlParameter("@ToDate", _ToDate) }); if (dt.Rows.Count == 0) { return(new ResultModel <List <MagfaModel> > { Succeeded = false, Message = "اطلاعات موجود نمی باشد." }); } var query = dt.Rows.OfType <DataRow>().Select(x => new MagfaModel { Title = x["Title"].ToString(), CountGLN = x["CountGLN"] != null ? Convert.ToInt32(x["CountGLN"]) : 0, ExternalCodeCount = Convert.ToInt32(x["ExternalCodeCount"]), InternalCodeCount = Convert.ToInt32(x["InternalCodeCount"]) // RecpayID = (int)x["ID"], // TypeTitle = x["TypeTitle"].ToString(), // RecpayPrice = (decimal)x["RecpayPrice"], // RecpayDate = (DateTime)x["RecpayDate"], // RegisterSystemDate = (DateTime)x["RegisterSystemDate"], // OwnerUserDisplayName = x["OwnerUserDisplayName"].ToString(), // Status = Convert.ToInt32(x["Status"]), // RecPayConfrimDate = Convert.IsDBNull(x["RecPayConfrimDate"]) ? (DateTime?)null : (DateTime)x["RecPayConfrimDate"], }).ToList(); return(new ResultModel <List <MagfaModel> > { Succeeded = true, Result = query }); } catch (Exception x) { return(new ResultModel <List <MagfaModel> > { Succeeded = false, Message = "خطا در عملیات - لطفا دوباره تلاش نمائید." }); } }