public List <TableDetailsServiceModel> GetTablesDetails(IdNameServiceModel tableFilters)
{
try
{
if (string.IsNullOrWhiteSpace(tableFilters.Name))
{
//return error;
}
var tableDetails = GetTablesFieldsDetails(tableFilters.Id, tableFilters.Name);
tableDetails.ForEach(v =>
{
var refTableColumn = new List <string>();
if (!string.IsNullOrWhiteSpace(v.RelationShipTableName) && !string.IsNullOrEmpty(v.RelationShipTableName))
{
refTableColumn = GetPrimaryKeyTableColumns(new IdNameServiceModel()
{
Id = tableFilters.Id, Name = v.RelationShipTableName
});
v.ReferenceTableColumns = refTableColumn;
}
});
return(tableDetails);
}
catch (Exception ex)
{
return(null);
}
}
public List <string> GetPrimaryKeyTableColumns(IdNameServiceModel columnFilter)
{
try
{
if (columnFilter == null)
{
//return exception
}
if (columnFilter.Id == default(int))
{
//return exception
}
DatabaseConnection dataBaseDetails;
List <string> columnName = new List <string>();
List <TableDetailsServiceModel> tableDetails = new List <TableDetailsServiceModel>();
using (var dataBaseConnectionRepo = new RepositoryPattern <DatabaseConnection>())
{
dataBaseDetails = dataBaseConnectionRepo.SelectByID(columnFilter.Id);
}
if (dataBaseDetails == null)
{
//return null;
}
var connectionString = "server= " + dataBaseDetails.ServerInstanceName + ";Initial Catalog=" + dataBaseDetails.DatabaseName + " ;uid=" + dataBaseDetails.UserName + ";pwd=" + dataBaseDetails.Password + ";";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
string query = string.Empty;
query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + columnFilter.Name + "' ORDER BY ORDINAL_POSITION ";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
columnName.Add(dr[0].ToString());
}
}
}
conn.Close();
}
return(columnName);
}
catch (Exception ex)
{
throw;
}
}
public HttpResponseMessage GetPrimaryKeyTableColumnsName(IdNameServiceModel columnFilter)
{
return(Request.CreateResponse(HttpStatusCode.OK, _tableConfigurationService.GetPrimaryKeyTableColumns(columnFilter)));
}
public HttpResponseMessage GetDetailstableAndFieldsById(IdNameServiceModel ids)
{
return(Request.CreateResponse(HttpStatusCode.OK, _tableConfigurationService.GetDetailstableAndFieldsById(ids.Id)));
}
public HttpResponseMessage GetTablesDetails(IdNameServiceModel tableFilter)
{
return(Request.CreateResponse(HttpStatusCode.OK, _tableConfigurationService.GetTablesDetails(tableFilter)));
}
