public DataTable GetSolutionOverviewData(string projectid) { DataSet dsSolutionOverviewData = new DataSet(); DataTable dtSolutionOverviewData = new DataTable(); try { String connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectSolutionOverview; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@ProjectID"; paramCollection[0].Value = projectid; dsSolutionOverviewData = objDA.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsSolutionOverviewData.Tables.Count > 0) { dtSolutionOverviewData = dsSolutionOverviewData.Tables[0]; } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetSolutionOverviewData"); } return(dtSolutionOverviewData); }
public DataSet GetModellingReportData(string reportid, string projectid) { DataSet dsModellingReportData = new DataSet(); try { var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectModellingData; SqlParameter[] paramCollection = new SqlParameter[2]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@Report_ID"; paramCollection[0].Value = reportid; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.VarChar; paramCollection[1].ParameterName = "@ProjectID"; paramCollection[1].Value = projectid; dsModellingReportData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetModellingReportData"); } return(dsModellingReportData); }
public DataTable GetClientDetailsByUserId(string userId, string appType) { DataSet dsClientDetails = new DataSet(); DataTable dtClientDetails = new DataTable(); try { String connectionString = ApplicationCommon.GetConnectionString("AIES"); const string sqlCommand = StoredProcedures.SpSelectClientDetails; SqlParameter[] paramCollection = new SqlParameter[2]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@userId"; paramCollection[0].Value = userId; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.VarChar; paramCollection[1].ParameterName = "@appType"; paramCollection[1].Value = appType; dsClientDetails = objDA.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsClientDetails.Tables.Count > 0) { dtClientDetails = dsClientDetails.Tables[0]; } } catch (Exception ex) { errlog.Log("BW", "ERROR", ex.Message, "ModelClass", "GetClientDetailsByUserId"); } return(dtClientDetails); }
//private String ConnectionString; //public DataSet GetClients(string clientId) //{ // DataSet ds = new DataSet(); // try // { // ds = GetClientList(); // } // catch (Exception ex) // { // // Error Logger // } // return ds; //} //public DataSet GetClientList() //{ // ConnectionString = ApplicationCommon.GetConnectionString("BW"); // const string sqlCommand = StoredProcedures.SPSelectIndustryName; // DataSet _dataset = new DataSet(); // _dataset = objDA.ExecuteQuery(sqlCommand, ConnectionString); // return _dataset; //} #endregion public bool GetUserId(string userId) { bool flag = false; var result = string.Empty; try { var connectionString = ApplicationCommon.GetConnectionString("AIES"); var userExists = string.Empty; const string sqlCommand = StoredProcedures.SpCheckUser; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@USERID"; paramCollection[0].Value = userId; result = objDA.ExecuteScalar(sqlCommand, paramCollection, connectionString); flag = result == "Y"; } catch (Exception ex) { flag = false; errlog.Log("BW", "ERROR", ex.Message, "ModelClass", "GetUserId"); } return(flag); }
public string GetNavigationTreeByProjectId(string projectid) { DataSet dsNavigationTreeDetails = new DataSet(); DataTable dtNavigationTreeDetails = new DataTable(); DataTable dtNavigationTreeDetails1 = new DataTable(); string Result = ""; try { String connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectNavigationTreeDetails; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@ProjectId"; paramCollection[0].Value = projectid; dsNavigationTreeDetails = objDA.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsNavigationTreeDetails.Tables.Count > 0) { dtNavigationTreeDetails = dsNavigationTreeDetails.Tables[0]; dtNavigationTreeDetails1 = dsNavigationTreeDetails.Tables[1]; } Result = ConvertDataTableTojSonString(dtNavigationTreeDetails, dtNavigationTreeDetails1); } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetNavigationTreeByProjectId"); } return(Result); }
//public DataSet GetCioAnalysisData(string projectid) //{ // DataSet dsCioAnalysisData = new DataSet(); // try // { // var connectionString = ApplicationCommon.GetConnectionString("BW"); // const string sqlCommand = StoredProcedures.SpSelectCioAnalysis; // SqlParameter[] paramCollection = new SqlParameter[1]; // paramCollection[0] = new SqlParameter(); // paramCollection[0].SqlDbType = SqlDbType.VarChar; // paramCollection[0].ParameterName = "@PROJECT_ID"; // paramCollection[0].Value = projectid; // dsCioAnalysisData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); // } // catch (Exception ex) // { // errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetCioAnalysisData"); // } // return dsCioAnalysisData; //} public List <KFIOAnalysis> GetKeyFigureAnalysisData(string projectId) { List <KFIOAnalysis> lstKfioAnalysisData = new List <KFIOAnalysis>(); try { //var lstKfioAnalysis = new List<KFIOAnalysis>(); var lstKfioMode = new List <KFIOMode>(); var lstKfioException = new List <KFIOException>(); DataSet dsKfioAnalysisData = new DataSet(); var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectKeyFigureAnalysis; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@PROJECT_ID"; paramCollection[0].Value = projectId; dsKfioAnalysisData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsKfioAnalysisData != null && dsKfioAnalysisData.Tables.Count > 0) { lstKfioMode = dsKfioAnalysisData.Tables[0].AsEnumerable().Select( dataRow => new KFIOMode { RowCount = dataRow.Field <int>("Row_Count"), Mode = dataRow.Field <string>("Mode") }).ToList(); //lstKfioAnalysisData.AddRange(lstKfioMode); //lstKfioException = dsKfioAnalysisData.Tables[1].AsEnumerable().Select( // dataRow => new KFIOException // { // KFExceptionAggregation = dataRow.Field<string>("KF_EXCEPTION_AGGREGATION"), // MaxCount = dataRow.Field<int>("MAX_COUNT") // }).ToList(); //lstKfioAnalysisData.Add(lstKfioException); } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetKeyFigureAnalysisData"); } return(lstKfioAnalysisData); }
public DataTable GetCioDetailsData(string cioinfoobject, string cioreportid, string ciotransferid, string projectId) { DataSet dsCioDetailsData = new DataSet(); DataTable dtCioDetailsData = new DataTable(); try { var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectCioDetails; SqlParameter[] paramCollection = new SqlParameter[4]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@CIO_INFO_OBJECT"; paramCollection[0].Value = cioinfoobject; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.VarChar; paramCollection[1].ParameterName = "@CIO_REPORT_DATA_ID"; paramCollection[1].Value = cioreportid; paramCollection[2] = new SqlParameter(); paramCollection[2].SqlDbType = SqlDbType.VarChar; paramCollection[2].ParameterName = "@CIO_TRANSFER_ROUTINE_ID"; paramCollection[2].Value = ciotransferid; paramCollection[3] = new SqlParameter(); paramCollection[3].SqlDbType = SqlDbType.VarChar; paramCollection[3].ParameterName = "@PROJECT_ID"; paramCollection[3].Value = projectId; dsCioDetailsData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsCioDetailsData.Tables.Count > 0) { dtCioDetailsData = dsCioDetailsData.Tables[0]; } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetCioDetailsData"); } return(dtCioDetailsData); }
public List <List <InfosetAnalysis> > GetInfosetAnalysis(string projectid) { List <List <InfosetAnalysis> > lstInfoAnalysisData = new List <List <InfosetAnalysis> >(); try { var lstInfosetAnalysis = new List <InfosetAnalysis>(); DataSet dsInfoAnalysisData = new DataSet(); var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectInfosetAnalysis; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@PROJECT_ID"; paramCollection[0].Value = projectid; dsInfoAnalysisData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsInfoAnalysisData != null && dsInfoAnalysisData.Tables.Count > 0) { lstInfosetAnalysis = dsInfoAnalysisData.Tables[0].AsEnumerable().Select( dataRow => new InfosetAnalysis { Infoset = dataRow.Field <string>("INFOSET"), InfosetDesc = dataRow.Field <string>("INFOSET_DESC"), InfosetInfoCube = dataRow.Field <string>("INFOSET_INFO_CUBE"), InfosetInfoObject = dataRow.Field <string>("INFOSET_INFO_OBJECT"), InfosetDSO = dataRow.Field <string>("INFOSET_DSO") }).ToList(); lstInfoAnalysisData.Add(lstInfosetAnalysis); lstInfosetAnalysis = dsInfoAnalysisData.Tables[1].AsEnumerable().Select( dataRow => new InfosetAnalysis { RowCount = dataRow.Field <int>("Row_Count"), Mode = dataRow.Field <string>("Mode") }).ToList(); lstInfoAnalysisData.Add(lstInfosetAnalysis); } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetInfoAnalysisData"); } return(lstInfoAnalysisData); }
public DataTable GetInfosetDetails(string isInfocube, string isInfoobject, string isDso, string projectId) { DataSet dsInfosetDetails = new DataSet(); DataTable dtInfosetDetails = new DataTable(); try { var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectInfosetDetails; SqlParameter[] paramCollection = new SqlParameter[4]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@INFO_CUBE "; paramCollection[0].Value = isInfocube; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.VarChar; paramCollection[1].ParameterName = "@INFO_OBJECT"; paramCollection[1].Value = isInfoobject; paramCollection[2] = new SqlParameter(); paramCollection[2].SqlDbType = SqlDbType.VarChar; paramCollection[2].ParameterName = "@DSO"; paramCollection[2].Value = isDso; paramCollection[3] = new SqlParameter(); paramCollection[3].SqlDbType = SqlDbType.VarChar; paramCollection[3].ParameterName = "@PROJECT_ID"; paramCollection[3].Value = projectId; dsInfosetDetails = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsInfosetDetails.Tables.Count > 0) { dtInfosetDetails = dsInfosetDetails.Tables[0]; } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetInfosetDetails"); } return(dtInfosetDetails); }
public DataSet GetKeyFigureAnalysisData1(string projectid) { DataSet dsKfioAnalysisData = new DataSet(); try { var connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SpSelectKeyFigureAnalysis; SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@PROJECT_ID"; paramCollection[0].Value = projectid; dsKfioAnalysisData = _objDa.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "ModelClass", "GetKeyFigureAnalysisData"); } return(dsKfioAnalysisData); }
public DataTable GetTransformationData(int PageNo, int PageSize, string TableName, string RowField, string SelectedFields, string WhereCondition, string ClientID, string ProjectID, string SystemID, string selectSecrchOption ) { DataSet dsTransformationData = new DataSet(); DataTable dtTransformationData = new DataTable(); try { String connectionString = ApplicationCommon.GetConnectionString("BW"); const string sqlCommand = StoredProcedures.SPSelectTransformationDetails; SqlParameter[] paramCollection = new SqlParameter[10]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.Int; paramCollection[0].ParameterName = "@PageNo"; paramCollection[0].Value = PageNo; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.Int; paramCollection[1].ParameterName = "@PageSize"; paramCollection[1].Value = PageSize; paramCollection[2] = new SqlParameter(); paramCollection[2].SqlDbType = SqlDbType.VarChar; paramCollection[2].ParameterName = "@TableName"; paramCollection[2].Value = TableName; paramCollection[3] = new SqlParameter(); paramCollection[3].SqlDbType = SqlDbType.VarChar; paramCollection[3].ParameterName = "@RowField"; paramCollection[3].Value = RowField; paramCollection[4] = new SqlParameter(); paramCollection[4].SqlDbType = SqlDbType.VarChar; paramCollection[4].ParameterName = "@SelectedFields"; paramCollection[4].Value = SelectedFields; paramCollection[5] = new SqlParameter(); paramCollection[5].SqlDbType = SqlDbType.VarChar; paramCollection[5].ParameterName = "@WhereCondition"; paramCollection[5].Value = WhereCondition; paramCollection[6] = new SqlParameter(); paramCollection[6].SqlDbType = SqlDbType.VarChar; paramCollection[6].ParameterName = "@ClientID"; paramCollection[6].Value = ClientID; paramCollection[7] = new SqlParameter(); paramCollection[7].SqlDbType = SqlDbType.VarChar; paramCollection[7].ParameterName = "@ProjectID"; paramCollection[7].Value = ProjectID; paramCollection[8] = new SqlParameter(); paramCollection[8].SqlDbType = SqlDbType.VarChar; paramCollection[8].ParameterName = "@SystemID"; paramCollection[8].Value = SystemID; paramCollection[9] = new SqlParameter(); paramCollection[9].SqlDbType = SqlDbType.VarChar; paramCollection[9].ParameterName = "@selectSecrchOption"; paramCollection[9].Value = selectSecrchOption; dsTransformationData = objDA.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, connectionString); if (dsTransformationData.Tables.Count > 0) { dtTransformationData = dsTransformationData.Tables[0]; } } catch (Exception ex) { errlog.Log("BW", "Error", ex.Message, "GetSolutionOverviewData"); } return(dtTransformationData); }