public HttpResponseMessage GetSchemaDetails(dbschemarequestdetails dbinforequest) { dbserverdetails serverdetails = dbinforequest.serverdetailsReq; dbdetailsrequest dbdetails = dbinforequest.schemadetailsReq; HttpResponseMessage response = null; try { var resultData = new DatamanagerBpl().GetSchemadetails(serverdetails, dbdetails); response = Request.CreateResponse(HttpStatusCode.OK, resultData); } catch (Exception ex) { response = Request.CreateErrorResponse(HttpStatusCode.Forbidden, ex); } return(response); }
public List <DbSchemaDetails> GetSchemadetails(dbserverdetails serverdetails, dbdetailsrequest dbdetails) { return(new DataManagerRal().GetSchemadetails(serverdetails, dbdetails)); }
public List <DbSchemaDetails> GetSchemadetails(dbserverdetails serverdetails, dbdetailsrequest dbdetails) { strTableName = dbdetails.TableName; strColumnName = dbdetails.ColumnName; strObjectType = "U"; string strQueryExtension = $" and so.name like '%{strTableName}%' and sc.name like '%{strColumnName}%' AND so.type in('{strObjectType}')"; string tmpConnectionString = $"server={serverdetails.dbserver};Initial Catalog={serverdetails.database};uid={serverdetails.userid};pwd={serverdetails.password}"; var dynParams = new DynamicParameters(); dynParams.Add("@ColumnName", dbdetails.ColumnName); dynParams.Add("@TableName", dbdetails.TableName); dynParams.Add("@ViewName", dbdetails.ViewName); dynParams.Add("@SPName", dbdetails.StoredProcedure); return(Db.FetchByConnection <DbSchemaDetails>(tmpConnectionString, strdbschemaquery + strQueryExtension, dynParams)); }