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