// MP-846 Admin database cleanup and code cleanup.-CLIENT
internal List <MasterClientApplicationEntity> GetAllForClients()
{
List <MasterClientApplicationEntity> results = new List <MasterClientApplicationEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "capp.GetClientApplicationDataAll";
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new MasterClientApplicationAdapter().Adapt(dt);
foreach (MasterClientApplicationEntity comp in results)
{
results = new MasterClientApplicationAdapter().Adapt(dt);
}
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
internal MasterClientApplicationEntity GetSolidQUser(string ConnectionString)
{
SqlHelper sqlClient = new SqlHelper(ConnectionString);
List <MasterClientApplicationEntity> results = new List <MasterClientApplicationEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetUserList";
DataTable dt;
dt = sqlClient.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString());
if (dt != null && dt.Rows.Count > 0)
{
results = new MasterClientApplicationAdapter().AdaptSolidQUser(dt);
foreach (MasterClientApplicationEntity comp in results)
{
results = new MasterClientApplicationAdapter().AdaptSolidQUser(dt);
}
}
}
catch (Exception)
{
//Put log to db here
}
return(results.FirstOrDefault());
}
internal List <MasterClientApplicationEntity> GetClientApplicationDataByClientId(int clientId)
{
List <MasterClientApplicationEntity> results = new List <MasterClientApplicationEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.GetClientApplicationDataByClientId"; // MP-846 Admin database cleanup and code cleanup.
sproc.StoredProceduresParameter.Add(GetParam("@ClientId", clientId.ToString().Trim(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new MasterClientApplicationAdapter().Adapt(dt);
foreach (MasterClientApplicationEntity comp in results)
{
results = new MasterClientApplicationAdapter().Adapt(dt);
}
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results);
}
internal ClientApplicationDataEntity GetClientApplicationData(string AppicationSubDomain)
{
List <ClientApplicationDataEntity> results = new List <ClientApplicationDataEntity>();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "mapp.GetClientApplicationData"; // MP-846 Admin database cleanup and code cleanup.
sproc.StoredProceduresParameter.Add(GetParam("@AppicationSubDomain", AppicationSubDomain, SQLServerDatatype.VarcharDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
if (dt != null && dt.Rows.Count > 0)
{
results = new MasterClientApplicationAdapter().ClientApplicationDataAdapt(dt);
}
}
catch (Exception)
{
//Put log to db here
throw;
}
return(results.FirstOrDefault());
}
