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