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