public static List <TaskXDeliverableArtifactDataModel> GetEntityDetails(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXDeliverableArtifactSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId); var result = new List <TaskXDeliverableArtifactDataModel>(); using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) { var dbReader = reader.DBReader; while (dbReader.Read()) { var dataItem = new TaskXDeliverableArtifactDataModel(); dataItem.TaskXDeliverableArtifactId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId]; dataItem.TaskId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.TaskId]; dataItem.DeliverableArtifactId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId]; dataItem.DeliverableArtifactStatusId = (int)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId]; dataItem.Task = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.Task]; dataItem.DeliverableArtifact = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact]; dataItem.DeliverableArtifactStatus = (string)dbReader[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus]; SetBaseInfo(dataItem, dbReader); result.Add(dataItem); } } return(result); }
private static string Save(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.TaskXDeliverableArtifactInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.TaskXDeliverableArtifactUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId); return(sql); }
private void RemoveByStatus(int statusId) { var data = new TaskXDeliverableArtifactDataModel(); data.DeliverableArtifactStatusId = statusId; TaskXDeliverableArtifactDataManager.Delete(data, SessionVariables.RequestProfile); }
protected override void ShowData(int taskXDeliverableArtifactId) { base.ShowData(taskXDeliverableArtifactId); oDetailButtonPanel.SetId = SetId; Clear(); var dataQuery = new TaskXDeliverableArtifactDataModel(); dataQuery.TaskXDeliverableArtifactId = taskXDeliverableArtifactId; var entityList = TaskXDeliverableArtifactDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile); if (entityList.Count == 1) { foreach (var entityItem in entityList) { lblTaskXDeliverableArtifactId.Text = entityItem.TaskXDeliverableArtifactId.ToString(); lblTask.Text = entityItem.Task.ToString(); lblDeliverableArtifacts.Text = entityItem.DeliverableArtifact.ToString(); lblDeliverableArtifactStatus.Text = entityItem.DeliverableArtifactStatus.ToString(); oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction); oHistoryList.Setup((int)SystemEntity.TaskXDeliverableArtifact, taskXDeliverableArtifactId, "TaskXDeliverableArtifact"); } } }
private DataTable GetData(string name) { var data = new TaskXDeliverableArtifactDataModel(); var dt = TaskXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private DataTable GetData() { // TODO: on all export pages var data = new TaskXDeliverableArtifactDataModel(); var dt = TaskXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Update(Dictionary <string, string> values) { var data = new TaskXDeliverableArtifactDataModel(); PropertyMapper.CopyProperties(data, values); TaskXDeliverableArtifactDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
protected override DataTable GetEntityData(int?entityKey) { var TaskXDeliverableArtifactdata = new TaskXDeliverableArtifactDataModel(); TaskXDeliverableArtifactdata.TaskXDeliverableArtifactId = entityKey; var results = TaskXDeliverableArtifactDataManager.Search(TaskXDeliverableArtifactdata, SessionVariables.RequestProfile); return(results); }
public static DataTable GetDetails(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXDeliverableArtifactSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId); var oDT = new DBDataTable("TaskXDeliverableArtifact.Details", sql, DataStoreKey); return(oDT.DBTable); }
private void SaveTaskXDeliverableArtifact(int taskId, int deliverableArtifactId, int statuslId) { //Components.BusinessLayer.TaskXDeliverableArtifact.DeleteByTask(taskId, AuditId); var data = new TaskXDeliverableArtifactDataModel(); data.TaskId = taskId; data.DeliverableArtifactId = deliverableArtifactId; data.DeliverableArtifactStatusId = statuslId; TaskXDeliverableArtifactDataManager.Create(data, SessionVariables.RequestProfile); }
public static void Delete(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXDeliverableArtifactDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId); DBDML.RunSQL("TaskXDeliverableArtifact.Delete", sql, DataStoreKey); }
protected void InsertData() { var data = new TaskXDeliverableArtifactDataModel(); data.TaskXDeliverableArtifactId = myGenericControl.TaskXDeliverableArtifactId; data.TaskId = myGenericControl.TaskId; data.DeliverableArtifactStatusId = myGenericControl.DeliverableArtifactStatusId; data.DeliverableArtifactId = myGenericControl.DeliverableArtifactsId; TaskXDeliverableArtifactDataManager.Create(data, SessionVariables.RequestProfile); }
public static DataTable Search(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.TaskXDeliverableArtifactSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId) + ", " + ToSQLParameter(data, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId); var oDT = new DBDataTable("TaskXDeliverableArtifact.Search", sql, DataStoreKey); return(oDT.DBTable); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new TaskXDeliverableArtifactDataModel(); data.TaskXDeliverableArtifactId = int.Parse(index); TaskXDeliverableArtifactDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int TaskXDeliverableArtifactId, bool showId) { var data = new TaskXDeliverableArtifactDataModel(); data.TaskXDeliverableArtifactId = TaskXDeliverableArtifactId; var oTaskXDeliverableArtifactTable = TaskXDeliverableArtifactDataManager.GetDetails(data, SessionVariables.RequestProfile); if (oTaskXDeliverableArtifactTable.Rows.Count == 1) { var row = oTaskXDeliverableArtifactTable.Rows[0]; if (!showId) { txtTaskXDeliverableArtifactId.Text = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId]); dynAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup((int)SystemEntity.TaskXDeliverableArtifact, TaskXDeliverableArtifactId, "TaskXDeliverableArtifact"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "TaskXDeliverableArtifact"); } else { txtTaskXDeliverableArtifactId.Text = String.Empty; } txtDeliverableArtifactsId.Text = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId]); txtTaskId.Text = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.TaskId]); txtDeliverableArtifactStatusId.Text = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId]); drpDeliverableArtifactStatusList.SelectedValue = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId]); drpTaskList.SelectedValue = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.TaskId]); drpDeliverableArtifactsList.SelectedValue = Convert.ToString(row[TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId]); } else { txtTaskXDeliverableArtifactId.Text = String.Empty; txtTaskId.Text = String.Empty; txtDeliverableArtifactStatusId.Text = String.Empty; txtDeliverableArtifactsId.Text = String.Empty; } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var taskXDeliverableArtifactdata = new TaskXDeliverableArtifactDataModel(); selectedrows = TaskXDeliverableArtifactDataManager.GetDetails(taskXDeliverableArtifactdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { taskXDeliverableArtifactdata.TaskXDeliverableArtifactId = entityKey; var result = TaskXDeliverableArtifactDataManager.GetDetails(taskXDeliverableArtifactdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { taskXDeliverableArtifactdata.TaskXDeliverableArtifactId = SetId; var result = TaskXDeliverableArtifactDataManager.GetDetails(taskXDeliverableArtifactdata, 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 TaskXDeliverableArtifactDataModel(); UpdatedData = TaskXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.TaskXDeliverableArtifactId = Convert.ToInt32(SelectedData.Rows[i][TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId].ToString()); data.TaskId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.TaskId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.TaskId)) : int.Parse(SelectedData.Rows[i][TaskXDeliverableArtifactDataModel.DataColumns.TaskId].ToString()); data.DeliverableArtifactId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId)) : int.Parse(SelectedData.Rows[i][TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId].ToString()); data.DeliverableArtifactStatusId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId).ToString()) : int.Parse(SelectedData.Rows[i][TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId].ToString()); TaskXDeliverableArtifactDataManager.Update(data, SessionVariables.RequestProfile); data = new TaskXDeliverableArtifactDataModel(); data.TaskXDeliverableArtifactId = Convert.ToInt32(SelectedData.Rows[i][TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId].ToString()); var dt = TaskXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
public static TaskXDeliverableArtifactDataModel GetDetails(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }
public static void Update(TaskXDeliverableArtifactDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("TaskXDeliverableArtifact.Update", sql, DataStoreKey); }
public static string ToSQLParameter(TaskXDeliverableArtifactDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId: if (data.TaskXDeliverableArtifactId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId, data.TaskXDeliverableArtifactId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.TaskXDeliverableArtifactId); } break; case TaskXDeliverableArtifactDataModel.DataColumns.TaskId: if (data.TaskId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXDeliverableArtifactDataModel.DataColumns.TaskId, data.TaskId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.TaskId); } break; case TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId: if (data.DeliverableArtifactId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId, data.DeliverableArtifactId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId); } break; case TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId: if (data.DeliverableArtifactStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId, data.DeliverableArtifactStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId); } break; case TaskXDeliverableArtifactDataModel.DataColumns.Task: if (!string.IsNullOrEmpty(data.Task)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskXDeliverableArtifactDataModel.DataColumns.Task, data.Task); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.Task); } break; case TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact: if (!string.IsNullOrEmpty(data.DeliverableArtifact)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact, data.DeliverableArtifact); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact); } break; case TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus: if (!string.IsNullOrEmpty(data.DeliverableArtifactStatus)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact, data.DeliverableArtifactStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus); } break; } return(returnValue); }