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