public static List <ProjectUseCaseStatusArchiveDataModel> GetEntityDetails(Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ProjectUseCaseStatusArchiveSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) +
", " + ToSQLParameter(data, Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.ProjectUseCaseStatusArchiveId);
var result = new List <Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel();
dataItem.ProjectUseCaseStatusArchiveId = Convert.ToInt32(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.ProjectUseCaseStatusArchiveId]);
dataItem.UseCase = Convert.ToString(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.UseCase]);
dataItem.Project = Convert.ToString(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.Project]);
dataItem.ProjectUseCaseStatus = Convert.ToString(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.ProjectUseCaseStatus]);
dataItem.Memo = Convert.ToString(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.Memo]);
//dataItem.KnowledgeDate = Convert.ToDateTime(dbReader[DataColumns.KnowledgeDate]);
dataItem.AcknowledgedBy = Convert.ToString(dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.AcknowledgedBy]);
dataItem.AcknowledgedById = (int?)dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.AcknowledgedById];
dataItem.ProjectUseCaseStatusId = (int?)dbReader[Components.BusinessLayer.DataModel.RequirementAnalysis.ProjectUseCaseStatusArchiveDataModel.DataColumns.ProjectUseCaseStatusId];
/*dataItem.UpdatedDate = Convert.ToDateTime(dbReader[BaseColumns.UpdatedDate]);
* dataItem.UpdatedBy = Convert.ToString(dbReader[BaseColumns.UpdatedBy]);
* dataItem.LastAction = Convert.ToString(dbReader[BaseColumns.LastAction]);
*/
result.Add(dataItem);
}
}
return(result);
}
public static List <UserLoginHistoryDataModel> GetEntityDetails(UserLoginHistoryDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.UserLoginHistorySearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, UserLoginHistoryDataModel.DataColumns.UserLoginHistoryId) +
", " + ToSQLParameter(data, UserLoginHistoryDataModel.DataColumns.UserName) +
", " + ToSQLParameter(data, UserLoginHistoryDataModel.DataColumns.UserId) +
", " + ToSQLParameter(data, UserLoginHistoryDataModel.DataColumns.FromSearchDate) +
", " + ToSQLParameter(data, UserLoginHistoryDataModel.DataColumns.ToSearchDate);
var result = new List <UserLoginHistoryDataModel>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new UserLoginHistoryDataModel();
dataItem.UserLoginHistoryId = (int)dbReader[UserLoginHistoryDataModel.DataColumns.UserLoginHistoryId];
dataItem.UserId = (int)dbReader[UserLoginHistoryDataModel.DataColumns.UserId];
dataItem.UserName = dbReader[UserLoginHistoryDataModel.DataColumns.UserName].ToString();
dataItem.ServerName = dbReader[UserLoginHistoryDataModel.DataColumns.ServerName].ToString();
dataItem.URL = dbReader[UserLoginHistoryDataModel.DataColumns.URL].ToString();
dataItem.DateVisited = (DateTime)dbReader[UserLoginHistoryDataModel.DataColumns.DateVisited];
//SetBaseInfo(dataItem, dbReader);
result.Add(dataItem);
}
}
return(result);
}
public static List <MilestoneXFeatureArchiveDataModel> GetEntityDetails(MilestoneXFeatureArchiveDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.MilestoneXFeatureArchiveSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, MilestoneXFeatureArchiveDataModel.DataColumns.MilestoneXFeatureArchiveId);
var result = new List <MilestoneXFeatureArchiveDataModel>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new MilestoneXFeatureArchiveDataModel();
dataItem.MilestoneXFeatureArchiveId = Convert.ToInt32(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.MilestoneXFeatureArchiveId]);
dataItem.Milestone = Convert.ToString(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.Milestone]);
dataItem.Feature = Convert.ToString(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.Feature]);
dataItem.MilestoneFeatureState = Convert.ToString(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.MilestoneFeatureState]);
dataItem.Memo = Convert.ToString(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.Memo]);
//dataItem.KnowledgeDate = Convert.ToDateTime(dbReader[DataColumns.KnowledgeDate]);
dataItem.AcknowledgedBy = Convert.ToString(dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.AcknowledgedBy]);
dataItem.AcknowledgedById = (int?)dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.AcknowledgedById];
dataItem.MilestoneXFeatureId = (int?)dbReader[MilestoneXFeatureArchiveDataModel.DataColumns.MilestoneXFeatureId];
/*dataItem.UpdatedDate = Convert.ToDateTime(dbReader[BaseColumns.UpdatedDate]);
* dataItem.UpdatedBy = Convert.ToString(dbReader[BaseColumns.UpdatedBy]);
* dataItem.LastAction = Convert.ToString(dbReader[BaseColumns.LastAction]);
*/
result.Add(dataItem);
}
}
return(result);
}
public void SetUp()
{
logicSearch = new SearchMethods();
reader = new DBDataReader();
}
