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