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 = "خطا در عملیات - لطفا دوباره تلاش نمائید."
});
}
}