public static List <ActivityXDeliverableArtifactDataModel> GetEntityList(ActivityXDeliverableArtifactDataModel data, RequestProfile requestProfile)
{
var oDT = GetDetails(data, requestProfile);
var dataList = new List <ActivityXDeliverableArtifactDataModel>();
if (oDT != null)
{
var oData = new ActivityXDeliverableArtifactDataModel();
oData.ActivityXDeliverableArtifactId = oDT.ActivityXDeliverableArtifactId;
oData.Activity = oDT.Activity;
oData.DeliverableArtifact = oDT.DeliverableArtifact;
oData.DeliverableArtifactStatus = oDT.DeliverableArtifactStatus;
//SetBaseInfo(oData, oDT);
dataList.Add(oData);
}
return(dataList);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var activityXDeliverableArtifactdata = new ActivityXDeliverableArtifactDataModel();
selectedrows = ActivityXDeliverableArtifactDataManager.GetDetails(activityXDeliverableArtifactdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
activityXDeliverableArtifactdata.ActivityXDeliverableArtifactId = entityKey;
var result = ActivityXDeliverableArtifactDataManager.GetDetails(activityXDeliverableArtifactdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
activityXDeliverableArtifactdata.ActivityXDeliverableArtifactId = SetId;
var result = ActivityXDeliverableArtifactDataManager.GetDetails(activityXDeliverableArtifactdata, 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 ActivityXDeliverableArtifactDataModel();
UpdatedData = ActivityXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.ActivityXDeliverableArtifactId =
Convert.ToInt32(SelectedData.Rows[i][ActivityXDeliverableArtifactDataModel.DataColumns.ActivityXDeliverableArtifactId].ToString());
data.ActivityId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId))
: int.Parse(SelectedData.Rows[i][ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId].ToString());
data.DeliverableArtifactId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId))
: int.Parse(SelectedData.Rows[i][ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId].ToString());
data.DeliverableArtifactStatusId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId).ToString())
: int.Parse(SelectedData.Rows[i][ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId].ToString());
ActivityXDeliverableArtifactDataManager.Update(data, SessionVariables.RequestProfile);
data = new ActivityXDeliverableArtifactDataModel();
data.ActivityXDeliverableArtifactId = Convert.ToInt32(SelectedData.Rows[i][ActivityXDeliverableArtifactDataModel.DataColumns.ActivityXDeliverableArtifactId].ToString());
var dt = ActivityXDeliverableArtifactDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public static void Update(ActivityXDeliverableArtifactDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("ActivityXDeliverableArtifact.Update", sql, DataStoreKey);
}
public static ActivityXDeliverableArtifactDataModel GetDetails(ActivityXDeliverableArtifactDataModel data, RequestProfile requestProfile)
{
var list = GetEntityList(data, requestProfile);
return(list.FirstOrDefault());
}
public static string ToSQLParameter(ActivityXDeliverableArtifactDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ActivityXDeliverableArtifactDataModel.DataColumns.ActivityXDeliverableArtifactId:
if (data.ActivityXDeliverableArtifactId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityXDeliverableArtifactDataModel.DataColumns.ActivityXDeliverableArtifactId, data.ActivityXDeliverableArtifactId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.ActivityXDeliverableArtifactId);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId:
if (data.DeliverableArtifactId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId, data.DeliverableArtifactId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactId);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId:
if (data.ActivityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId, data.ActivityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.ActivityId);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId:
if (data.DeliverableArtifactStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId, data.DeliverableArtifactStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatusId);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact:
if (!string.IsNullOrEmpty(data.DeliverableArtifact))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact, data.DeliverableArtifact);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifact);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.Activity:
if (!string.IsNullOrEmpty(data.Activity))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ActivityXDeliverableArtifactDataModel.DataColumns.Activity, data.Activity);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.Activity);
}
break;
case ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus:
if (!string.IsNullOrEmpty(data.DeliverableArtifactStatus))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus, data.DeliverableArtifactStatus);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityXDeliverableArtifactDataModel.DataColumns.DeliverableArtifactStatus);
}
break;
}
return(returnValue);
}
