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)); }