public static bool IsDeletable(TaskRunDataModel data, RequestProfile requestProfile)
{
var isDeletable = true;
var ds = GetChildren(data, requestProfile);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count > 0)
{
isDeletable = false;
break;
}
}
}
return(isDeletable);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new TaskRunDataModel();
data.TaskRunId = int.Parse(index);
Framework.Components.TasksAndWorkflow.TaskRunDataManager.Delete(data, SessionVariables.RequestProfile);
}
DeleteAndRedirect();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public void LoadData(int taskRunId, bool showId)
{
// clear UI
Clear();
var dataQuery = new TaskRunDataModel();
dataQuery.TaskRunId = taskRunId;
var items = Framework.Components.TasksAndWorkflow.TaskRunDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
if (items.Count != 1)
{
return;
}
var item = items[0];
TaskRunId = item.TaskRunId;
TaskEntityId = item.TaskEntityId;
TaskScheduleId = item.TaskScheduleId;
//BusinessDate = item.BusinessDate;
StartTime = item.StartTime;
EndTime = item.EndTime;
RunBy = item.RunBy;
if (!showId)
{
txtTaskRunId.Text = item.TaskRunId.ToString();
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.TaskRun, taskRunId, "TaskRun");
}
else
{
txtTaskRunId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var taskRundata = new TaskRunDataModel();
selectedrows = Framework.Components.TasksAndWorkflow.TaskRunDataManager.GetDetails(taskRundata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
taskRundata.TaskRunId = entityKey;
var result = Framework.Components.TasksAndWorkflow.TaskRunDataManager.GetDetails(taskRundata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
taskRundata.TaskRunId = SetId;
var result = Framework.Components.TasksAndWorkflow.TaskRunDataManager.GetDetails(taskRundata, 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 TaskRunDataModel();
UpdatedData = Framework.Components.TasksAndWorkflow.TaskRunDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.TaskRunId =
Convert.ToInt32(SelectedData.Rows[i][TaskRunDataModel.DataColumns.TaskRunId].ToString());
data.TaskEntityId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.TaskEntityId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.TaskEntityId).ToString())
: int.Parse(SelectedData.Rows[i][TaskRunDataModel.DataColumns.TaskEntityId].ToString());
data.TaskScheduleId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.TaskScheduleId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.TaskScheduleId).ToString())
: int.Parse(SelectedData.Rows[i][TaskRunDataModel.DataColumns.TaskScheduleId].ToString());
data.RunBy =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.RunBy))
? CheckAndGetRepeaterTextBoxValue(TaskRunDataModel.DataColumns.RunBy)
: SelectedData.Rows[i][TaskRunDataModel.DataColumns.RunBy].ToString();
Framework.Components.TasksAndWorkflow.TaskRunDataManager.Update(data, SessionVariables.RequestProfile);
data = new TaskRunDataModel();
data.TaskRunId = Convert.ToInt32(SelectedData.Rows[i][TaskRunDataModel.DataColumns.TaskRunId].ToString());
var dt = Framework.Components.TasksAndWorkflow.TaskRunDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public static string ToSQLParameter(TaskRunDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case TaskRunDataModel.DataColumns.TaskRunId:
if (data.TaskRunId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskRunDataModel.DataColumns.TaskRunId, data.TaskRunId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.TaskRunId);
}
break;
case TaskRunDataModel.DataColumns.TaskEntityId:
if (data.TaskEntityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskRunDataModel.DataColumns.TaskEntityId, data.TaskEntityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.TaskEntityId);
}
break;
case TaskRunDataModel.DataColumns.TaskScheduleId:
if (data.TaskScheduleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskRunDataModel.DataColumns.TaskScheduleId, data.TaskScheduleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.TaskScheduleId);
}
break;
case TaskRunDataModel.DataColumns.BusinessDate:
if (data.BusinessDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskRunDataModel.DataColumns.BusinessDate, data.BusinessDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.BusinessDate);
}
break;
case TaskRunDataModel.DataColumns.StartTime:
if (data.StartTime != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskRunDataModel.DataColumns.StartTime, data.StartTime);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.StartTime);
}
break;
case TaskRunDataModel.DataColumns.EndTime:
if (data.EndTime != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskRunDataModel.DataColumns.EndTime, data.EndTime);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.EndTime);
}
break;
case TaskRunDataModel.DataColumns.RunBy:
if (data.RunBy != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskRunDataModel.DataColumns.RunBy, data.RunBy);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskRunDataModel.DataColumns.RunBy);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(TaskRunDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
Framework.Components.DataAccess.DBDML.RunSQL("TaskRun.Update", sql, DataStoreKey);
}
public static TaskRunDataModel GetDetails(TaskRunDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
