public static List <UseCaseXUseCaseStepDataModel> GetEntityDetails(UseCaseXUseCaseStepDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.UseCaseXUseCaseStepSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, UseCaseId = dataQuery.UseCaseId
, UseCaseStepId = dataQuery.UseCaseStepId
, UseCaseWorkFlowCategoryId = dataQuery.UseCaseWorkFlowCategoryId
, UseCaseXUseCaseStepId = dataQuery.UseCaseXUseCaseStepId
};
List <UseCaseXUseCaseStepDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <UseCaseXUseCaseStepDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public void LoadData(int useCaseXUseCaseStepId, bool showId)
{
//Clear();
var dataQuery = new UseCaseXUseCaseStepDataModel();
dataQuery.UseCaseXUseCaseStepId = useCaseXUseCaseStepId;
var items = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
if (items.Count != 1)
{
return;
}
var item = items[0];
UseCaseXUseCaseStepId = item.UseCaseXUseCaseStepId;
UseCaseId = item.UseCaseId;
UseCaseStepId = item.UseCaseStepId;
UseCaseWorkFlowCategoryId = item.UseCaseWorkFlowCategoryId;
if (!showId)
{
txtUseCaseXUseCaseStepId.Text = item.UseCaseXUseCaseStepId.ToString();
oHistoryList.Setup(PrimaryEntity, useCaseXUseCaseStepId, PrimaryEntityKey);
}
else
{
txtUseCaseXUseCaseStepId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
protected override void ShowData(int useCaseXUseCaseStepId)
{
oDetailButtonPanel.SetId = SetId;
var data = new UseCaseXUseCaseStepDataModel();
data.UseCaseXUseCaseStepId = useCaseXUseCaseStepId;
var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblUseCaseXUseCaseStepId.Text = Convert.ToString(row[UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId]);
lblUseCaseStep.Text = Convert.ToString(row[UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStep]);
lblUseCase.Text = Convert.ToString(row[UseCaseXUseCaseStepDataModel.DataColumns.UseCase]);
lblUseCaseWorkFlowCategory.Text = Convert.ToString(row[UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategory]);
oUpdateInfo.LoadText(dt.Rows[0]);
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.UseCaseXUseCaseStep, useCaseXUseCaseStepId, "UseCaseXUseCaseStep");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "UseCaseXUseCaseStep");
}
else
{
Clear();
}
}
private static string CreateOrUpdate(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.UseCaseXUseCaseStepInsert " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.UseCaseXUseCaseStepUpdate " + "\r\n" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId);
return(sql);
}
protected override DataTable GetEntityData(int?entityKey)
{
var useCaseXUseCaseStepdata = new UseCaseXUseCaseStepDataModel();
useCaseXUseCaseStepdata.UseCaseXUseCaseStepId = entityKey;
var results = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(useCaseXUseCaseStepdata, SessionVariables.RequestProfile);
return(results);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new UseCaseXUseCaseStepDataModel();
var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private DataTable GetUseCaseXUseCaseStepData(int useCaseId)
{
var data = new UseCaseXUseCaseStepDataModel();
data.UseCaseId = useCaseId;
var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static void Delete(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.UseCaseXUseCaseStepDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId);
Framework.Components.DataAccess.DBDML.RunSQL("UseCaseXUseCaseStep.Delete", sql, DataStoreKey);
}
public static bool DoesExist(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.UseCaseXUseCaseStepSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId);
var oDT = new Framework.Components.DataAccess.DBDataTable("UseCaseXUseCaseStep.DoesExist", sql, DataStoreKey);
return(oDT.DBTable.Rows.Count > 0);
}
protected override void Clear()
{
base.Clear();
var data = new UseCaseXUseCaseStepDataModel();
UseCaseXUseCaseStepId = data.UseCaseXUseCaseStepId;
UseCaseId = data.UseCaseId;
UseCaseStepId = data.UseCaseStepId;
UseCaseWorkFlowCategoryId = data.UseCaseWorkFlowCategoryId;
}
protected override void Update(Dictionary <string, string> values)
{
var data = new UseCaseXUseCaseStepDataModel();
// copies properties from values dictionary object to data object
PropertyMapper.CopyProperties(data, values);
TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
public static DataTable Search(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.UseCaseXUseCaseStepSearch " +
" " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId) +
", " + ToSQLParameter(data, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId);
var oDT = new Framework.Components.DataAccess.DBDataTable("UseCaseXUseCaseStep.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public override int?Save(string action)
{
var data = new UseCaseXUseCaseStepDataModel();
data.UseCaseXUseCaseStepId = UseCaseXUseCaseStepId;
data.UseCaseId = UseCaseId;
data.UseCaseStepId = UseCaseStepId;
data.UseCaseWorkFlowCategoryId = UseCaseWorkFlowCategoryId;
if (action == "Insert")
{
TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Update(data, SessionVariables.RequestProfile);
}
return(UseCaseXUseCaseStepId);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new UseCaseXUseCaseStepDataModel();
data.UseCaseXUseCaseStepId = int.Parse(index);
TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.UseCaseXUseCaseStep, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("UseCaseXUseCaseStepEntityRoute", new { Action = "Default", SetId = true }), false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private DataTable GetUseCaseXUseCaseStepData(int useCaseXUseCaseStepId)
{
//var data = new UseCaseXUseCaseStepDataModel();
//data.UseCaseXUseCaseStepId = useCaseXUseCaseStepId;
//var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStep.Search(data, AuditId);
//var fdt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStep.GetList(AuditId);
//var resultdt = fdt.Clone();
//foreach (DataRow row in dt.Rows)
//{
// var rows = fdt.Select(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId + " = " + row[UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId]);
// resultdt.ImportRow(rows[0]);
//}
//return resultdt;
var data = new UseCaseXUseCaseStepDataModel();
data.UseCaseStepId = useCaseXUseCaseStepId;
var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var useCaseXUseCaseStepdata = new UseCaseXUseCaseStepDataModel();
selectedrows = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.GetDetails(useCaseXUseCaseStepdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
useCaseXUseCaseStepdata.UseCaseXUseCaseStepId = entityKey;
var result = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.GetDetails(useCaseXUseCaseStepdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else if (SetId != 0)
{
useCaseXUseCaseStepdata.UseCaseXUseCaseStepId = SetId;
var result = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.GetDetails(useCaseXUseCaseStepdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new UseCaseXUseCaseStepDataModel();
UpdatedData = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.UseCaseXUseCaseStepId =
Convert.ToInt32(SelectedData.Rows[i][UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId].ToString());
data.UseCaseStepId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId).ToString())
: int.Parse(SelectedData.Rows[i][UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId].ToString());
data.UseCaseId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId).ToString())
: int.Parse(SelectedData.Rows[i][UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId].ToString());
data.UseCaseWorkFlowCategoryId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId).ToString())
: int.Parse(SelectedData.Rows[i][UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId].ToString());
TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Update(data, SessionVariables.RequestProfile);
data = new UseCaseXUseCaseStepDataModel();
data.UseCaseXUseCaseStepId = Convert.ToInt32(SelectedData.Rows[i][UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId].ToString());
var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCaseXUseCaseStepDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public static string ToSQLParameter(UseCaseXUseCaseStepDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId:
if (data.UseCaseXUseCaseStepId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId, data.UseCaseXUseCaseStepId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseXUseCaseStepId);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId:
if (data.UseCaseStepId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId, data.UseCaseStepId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStepId);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId:
if (data.UseCaseId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId, data.UseCaseId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseId);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId:
if (data.UseCaseWorkFlowCategoryId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId, data.UseCaseWorkFlowCategoryId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategoryId);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStep:
if (data.UseCaseStep != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStep, data.UseCaseStep);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseStep);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCase:
if (data.UseCase != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseXUseCaseStepDataModel.DataColumns.UseCase, data.UseCase);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCase);
}
break;
case UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategory:
if (data.UseCaseWorkFlowCategory != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategory, data.UseCaseWorkFlowCategory);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCaseXUseCaseStepDataModel.DataColumns.UseCaseWorkFlowCategory);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static UseCaseXUseCaseStepDataModel GetDetails(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
public static void Update(UseCaseXUseCaseStepDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
Framework.Components.DataAccess.DBDML.RunSQL("UseCaseXUseCaseStep.Update", sql, DataStoreKey);
}
