private static string Save(TaskXCompetencyDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.TaskXCompetencyInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.TaskXCompetencyUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.CompetencyId); return(sql); }
public static List <TaskXCompetencyDataModel> GetEntityDetails(TaskXCompetencyDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXCompetencySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId); var result = new List <TaskXCompetencyDataModel>(); using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) { var dbReader = reader.DBReader; while (dbReader.Read()) { var dataItem = new TaskXCompetencyDataModel(); dataItem.TaskXCompetencyId = (int)dbReader[TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId]; dataItem.TaskId = (int)dbReader[TaskXCompetencyDataModel.DataColumns.TaskId]; dataItem.CompetencyId = (int)dbReader[TaskXCompetencyDataModel.DataColumns.CompetencyId]; dataItem.Task = (string)dbReader[TaskXCompetencyDataModel.DataColumns.Task]; dataItem.Competency = (string)dbReader[TaskXCompetencyDataModel.DataColumns.Competency]; SetBaseInfo(dataItem, dbReader); result.Add(dataItem); } } return(result); }
protected override void ShowData(int taskXCompetencyId) { base.ShowData(taskXCompetencyId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new TaskXCompetencyDataModel(); data.TaskXCompetencyId = taskXCompetencyId; var items = TaskXCompetencyDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match if (items.Count == 1) { var item = items[0]; lblTaskXCompetencyId.Text = item.TaskXCompetencyId.ToString(); lblTask.Text = item.TaskId.ToString(); lblCompetency.Text = item.Competency.ToString(); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, taskXCompetencyId, "TaskXCompetency"); } }
public static void Delete(TaskXCompetencyDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXCompetencyDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId); Framework.Components.DataAccess.DBDML.RunSQL("TaskXCompetency.Delete", sql, DataStoreKey); }
private DataTable GetAssociatedCompetencies(int taskId) { var data = new TaskXCompetencyDataModel(); data.TaskId = taskId; var dt = TaskXCompetencyDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new TaskXCompetencyDataModel(); var dt = TaskTimeTracker.Components.Module.Competency.TaskXCompetencyDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Clear() { base.Clear(); var data = new TaskXCompetencyDataModel(); TaskXCompetencyId = data.TaskXCompetencyId; TaskId = data.TaskId; CompetencyId = data.CompetencyId; }
public static bool DoesExist(TaskXCompetencyDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TaskXCompetencySearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId); var oDT = new Framework.Components.DataAccess.DBDataTable("TaskXCompetency.DoesExist", sql, DataStoreKey); return(oDT.DBTable.Rows.Count > 0); }
public static DataTable Search(TaskXCompetencyDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.TaskXCompetencySearch " + " " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.TaskId) + ", " + ToSQLParameter(data, TaskXCompetencyDataModel.DataColumns.CompetencyId); var oDT = new Framework.Components.DataAccess.DBDataTable("TaskXCompetency.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 TaskXCompetencyDataModel(); data.TaskXCompetencyId = int.Parse(index); TaskTimeTracker.Components.Module.Competency.TaskXCompetencyDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public override int?Save(string action) { var data = new TaskXCompetencyDataModel(); data.TaskXCompetencyId = TaskXCompetencyId; data.TaskId = TaskId; data.CompetencyId = CompetencyId; if (action == "Insert") { TaskTimeTracker.Components.Module.Competency.TaskXCompetencyDataManager.Create(data, SessionVariables.RequestProfile); } else { TaskTimeTracker.Components.Module.Competency.TaskXCompetencyDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of TaskXCompetencyID ? return(TaskXCompetencyId); }
public void LoadData(int taskXCompetencyId, bool showId) { // clear UI Clear(); // set up parameters var data = new TaskXCompetencyDataModel(); data.TaskXCompetencyId = taskXCompetencyId; // get data var items = TaskTimeTracker.Components.Module.Competency.TaskXCompetencyDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; TaskXCompetencyId = item.TaskXCompetencyId; TaskId = item.TaskId; CompetencyId = item.CompetencyId; if (!showId) { txtTaskXCompetencyId.Text = item.TaskXCompetencyId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, taskXCompetencyId, PrimaryEntityKey); } else { txtTaskXCompetencyId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
public static TaskXCompetencyDataModel GetDetails(TaskXCompetencyDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); return(list.FirstOrDefault()); }
public static string ToSQLParameter(TaskXCompetencyDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId: if (data.TaskXCompetencyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId, data.TaskXCompetencyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXCompetencyDataModel.DataColumns.TaskXCompetencyId); } break; case TaskXCompetencyDataModel.DataColumns.TaskId: if (data.TaskId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXCompetencyDataModel.DataColumns.TaskId, data.TaskId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXCompetencyDataModel.DataColumns.TaskId); } break; case TaskXCompetencyDataModel.DataColumns.CompetencyId: if (data.CompetencyId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TaskXCompetencyDataModel.DataColumns.CompetencyId, data.CompetencyId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXCompetencyDataModel.DataColumns.CompetencyId); } break; case TaskXCompetencyDataModel.DataColumns.Task: if (!string.IsNullOrEmpty(data.Task)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskXCompetencyDataModel.DataColumns.Task, data.Task); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXCompetencyDataModel.DataColumns.Task); } break; case TaskXCompetencyDataModel.DataColumns.Competency: if (!string.IsNullOrEmpty(data.Competency)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TaskXCompetencyDataModel.DataColumns.Competency, data.Competency); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TaskXCompetencyDataModel.DataColumns.Competency); } break; } return(returnValue); }
public static void Update(TaskXCompetencyDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); Framework.Components.DataAccess.DBDML.RunSQL("TaskXCompetency.Update", sql, DataStoreKey); }