public HttpResponseMessage List([FromBody] WebDirectoryRequest Model)
{
List <WebDirectory> r = new List <WebDirectory>();
r = WBL.WDByUser(Model);
return(this.Request.CreateResponse(HttpStatusCode.OK, r));
}
public List <WebDirectory> WDByUser(WebDirectoryRequest Model)
{
List <WebDirectory> List = new List <WebDirectory>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspWebDirectorybyUser]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter pUserID = new SqlParameter
{
ParameterName = "@UserID",
SqlDbType = SqlDbType.Int,
Value = Model.UserID
};
SqlCmd.Parameters.Add(pUserID);
SqlParameter pAppID = new SqlParameter
{
ParameterName = "@AppID",
SqlDbType = SqlDbType.Int,
Value = Model.AppID
};
SqlCmd.Parameters.Add(pAppID);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new WebDirectory
{
AppID = Convert.ToInt32(dr["AppID"]),
WebID = Convert.ToInt32(dr["WebID"]),
Controller = dr["Controller"].ToString(),
Action = dr["Action"].ToString(),
DisplayName = dr["DisplayName"].ToString(),
Parameter = dr["Parameter"].ToString(),
Order = Convert.ToInt32(dr["Order"])
};
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
public List <WebDirectory> WDByUser(WebDirectoryRequest Model)
{
return(WDAL.WDByUser(Model));
}
