public HttpResponseMessage LoadReportPermissionBy() // IEnumerable(Of String)
{
string CategoryId = HttpContext.Current.Request.Form["CategoryId"].ToString();
string RoleId = HttpContext.Current.Request.Form["RoleId"].ToString();
List <SP_LoadReportByRId_Model> objLoadReport = new List <SP_LoadReportByRId_Model>();
DataSet Ds = SqlHelper.ExecuteDataset(strConn, CommandType.StoredProcedure, "SP_LoadReportPermissionBy",
new SqlParameter("@CategoryId", CategoryId)
, new SqlParameter("@RoleId", RoleId));
DataTable Dt = Ds.Tables[0];
if (Dt.Rows.Count > 0)
{
foreach (DataRow obj in Dt.Rows)
{
SP_LoadReportByRId_Model Lis = new SP_LoadReportByRId_Model();
Lis.ReportId = obj["ReportId"].ToString();
Lis.ReportName = obj["ReportName"].ToString();
objLoadReport.Add(Lis);
}
return(Request.CreateResponse(HttpStatusCode.OK, objLoadReport));
}
else
{
ResponceMessage objErr = new ResponceMessage();
objErr.code = "1";
objErr.message = "ไม่มีข้อมูล";
return(Request.CreateResponse(HttpStatusCode.BadRequest, objErr));
}
}
public HttpResponseMessage GetLoadReport() // IEnumerable(Of String)
{
List <SP_LoadReportByRId_Model> objLoadReport = new List <SP_LoadReportByRId_Model>();
DataSet Ds = SqlHelper.ExecuteDataset(strConn, CommandType.StoredProcedure, "SP_LoadReportByRId");
DataTable Dt = Ds.Tables[0];
if (Dt.Rows.Count > 0)
{
foreach (DataRow obj in Dt.Rows)
{
SP_LoadReportByRId_Model Lis = new SP_LoadReportByRId_Model();
Lis.ReportId = obj["ReportId"].ToString();
Lis.ReportName = obj["ReportName"].ToString();
Lis.ReportDescription = obj["ReportDescription"].ToString();
Lis.ReportData = obj["ReportData"].ToString();
Lis.IsPublish = obj["IsPublish"].ToString();
Lis.PublishDate = obj["PublishDate"].ToString();
Lis.PublishByUsername = obj["PublishByUsername"].ToString();
objLoadReport.Add(Lis);
}
return(Request.CreateResponse(HttpStatusCode.OK, objLoadReport));
}
else
{
ResponceMessage objErr = new ResponceMessage();
objErr.code = "1";
objErr.message = "ไม่มีข้อมูล";
return(Request.CreateResponse(HttpStatusCode.BadRequest, objErr));
}
}
