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