private DataTable GetData(string name)
{
var data = new MilestoneXFeatureDataModel();
var dt = MilestoneXFeatureDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public override int?Save(string action)
{
var data = new MilestoneXFeatureDataModel();
data.MilestoneXFeatureId = MilestoneXFeatureId;
data.MilestoneId = MilestoneId;
data.FeatureId = FeatureId;
data.MilestoneFeatureStateId = MilestoneFeatureStateId;
data.Memo = Memo;
if (action == "Insert")
{
var dtMilestoneXFeature = MilestoneXFeatureDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtMilestoneXFeature.Rows.Count == 0)
{
MilestoneXFeatureDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
MilestoneXFeatureDataManager.Update(data, SessionVariables.RequestProfile);
}
// not correct ... when doing insert, we didn't get/change the value of MilestoneID ?
return(MilestoneXFeatureId);
}
private DataTable GetData()
{
// TODO: on all export pages
var data = new MilestoneXFeatureDataModel();
var dt = MilestoneXFeatureDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var milestoneXFeaturedata = new MilestoneXFeatureDataModel();
milestoneXFeaturedata.MilestoneXFeatureId = entityKey;
var results = MilestoneXFeatureDataManager.Search(milestoneXFeaturedata, SessionVariables.RequestProfile);
return(results);
}
private DataTable GetMilestoneXFeatureData(int milestoneId)
{
var data = new MilestoneXFeatureDataModel();
data.MilestoneId = milestoneId;
var dt = MilestoneXFeatureDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static void Delete(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.MilestoneXFeatureDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.FeatureId);
DBDML.RunSQL("MilestoneXFeature.Delete", sql, DataStoreKey);
}
public static bool DoesExist(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.MilestoneXFeatureSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId);
var oDT = new DBDataTable("MilestoneXFeature.DoesExist", sql, DataStoreKey);
return(oDT.DBTable.Rows.Count > 0);
}
public static DataTable Search(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.MilestoneXFeatureSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId) +
", " + ToSQLParameter(data, MilestoneXFeatureDataModel.DataColumns.FeatureId);
var oDT = new DBDataTable("MilestoneXFeature.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public void LoadData(int MilestoneXFeatureId, bool showId)
{
var data = new MilestoneXFeatureDataModel();
data.MilestoneXFeatureId = MilestoneXFeatureId;
var oMilestoneXFeatureTable = MilestoneXFeatureDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (oMilestoneXFeatureTable.Rows.Count == 1)
{
var row = oMilestoneXFeatureTable.Rows[0];
if (!showId)
{
txtMilestoneXFeatureId.Text = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId]);
dynAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)SystemEntity.MilestoneXFeature, MilestoneXFeatureId, "MilestoneXFeature");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "MilestoneXFeature");
}
else
{
txtMilestoneXFeatureId.Text = String.Empty;
}
txtFeatureId.Text = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.FeatureId]);
txtMilestoneId.Text = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.MilestoneId]);
txtMilestoneFeatureStateId.Text = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId]);
txtMemo.Text = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.Memo]);
drpMilestoneFeatureStateList.SelectedValue = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId]);
drpMilestoneList.SelectedValue = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.MilestoneId]);
drpFeatureList.SelectedValue = Convert.ToString(row[MilestoneXFeatureDataModel.DataColumns.FeatureId]);
oUpdateInfo.LoadText(oMilestoneXFeatureTable.Rows[0]);
}
else
{
txtMilestoneXFeatureId.Text = String.Empty;
txtMilestoneId.Text = String.Empty;
txtMemo.Text = String.Empty;
txtMilestoneFeatureStateId.Text = String.Empty;
txtFeatureId.Text = String.Empty;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new MilestoneXFeatureDataModel();
data.MilestoneXFeatureId = int.Parse(index);
MilestoneXFeatureDataManager.Delete(data, SessionVariables.RequestProfile);
}
DeleteAndRedirect();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override void Update(Dictionary <string, string> values)
{
var data = new MilestoneXFeatureDataModel();
if (values.ContainsKey(MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId))
{
data.MilestoneXFeatureId = int.Parse(values[MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId].ToString());
}
if (values.ContainsKey(MilestoneXFeatureDataModel.DataColumns.MilestoneId))
{
data.MilestoneId = int.Parse(values[MilestoneXFeatureDataModel.DataColumns.MilestoneId].ToString());
}
if (values.ContainsKey(MilestoneXFeatureDataModel.DataColumns.FeatureId))
{
data.FeatureId = int.Parse(values[MilestoneXFeatureDataModel.DataColumns.FeatureId].ToString());
}
MilestoneXFeatureDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new MilestoneXFeatureDataModel();
UpdatedData = MilestoneXFeatureDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.MilestoneXFeatureId =
Convert.ToInt32(SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId].ToString());
data.MilestoneFeatureStateId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId))
: int.Parse(SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId].ToString());
data.MilestoneId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.MilestoneId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.MilestoneId))
: int.Parse(SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.MilestoneId].ToString());
data.FeatureId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.FeatureId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(MilestoneXFeatureDataModel.DataColumns.FeatureId).ToString())
: int.Parse(SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.FeatureId].ToString());
data.Memo = SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.Memo].ToString();
MilestoneXFeatureDataManager.Update(data, SessionVariables.RequestProfile);
data = new MilestoneXFeatureDataModel();
data.MilestoneXFeatureId = Convert.ToInt32(SelectedData.Rows[i][MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId].ToString());
var dt = MilestoneXFeatureDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
protected override DataTable GetData()
{
try
{
var SuperKey = ApplicationCommon.GetSuperKey();
var SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var milestoneXFeaturedata = new MilestoneXFeatureDataModel();
selectedrows = MilestoneXFeatureDataManager.GetDetails(milestoneXFeaturedata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
milestoneXFeaturedata.MilestoneXFeatureId = entityKey;
var result = MilestoneXFeatureDataManager.GetDetails(milestoneXFeaturedata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
milestoneXFeaturedata.MilestoneXFeatureId = SetId;
var result = MilestoneXFeatureDataManager.GetDetails(milestoneXFeaturedata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
public static List <MilestoneXFeatureDataModel> GetEntityList(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
var oDT = GetDetails(data, requestProfile);
var dataList = new List <MilestoneXFeatureDataModel>();
if (oDT != null)
{
var oData = new MilestoneXFeatureDataModel();
oData.MilestoneXFeatureId = oDT.MilestoneXFeatureId;
oData.Feature = oDT.Feature;
oData.Milestone = oDT.Milestone;
oData.MilestoneFeatureState = oDT.MilestoneFeatureState;
oData.Memo = oDT.Memo;
//SetBaseInfo(oData, oDT);
dataList.Add(oData);
}
return(dataList);
}
public static void Update(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("MilestoneXFeature.Update", sql, DataStoreKey);
}
public static MilestoneXFeatureDataModel GetDetails(MilestoneXFeatureDataModel data, RequestProfile requestProfile)
{
var list = GetEntityList(data, requestProfile);
return(list.FirstOrDefault());
}
public static string ToSQLParameter(MilestoneXFeatureDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId:
if (data.MilestoneXFeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId, data.MilestoneXFeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.MilestoneXFeatureId);
}
break;
case MilestoneXFeatureDataModel.DataColumns.FeatureId:
if (data.FeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneXFeatureDataModel.DataColumns.FeatureId, data.FeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.FeatureId);
}
break;
case MilestoneXFeatureDataModel.DataColumns.MilestoneId:
if (data.MilestoneId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneXFeatureDataModel.DataColumns.MilestoneId, data.MilestoneId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.MilestoneId);
}
break;
case MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId:
if (data.MilestoneFeatureStateId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId, data.MilestoneFeatureStateId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureStateId);
}
break;
case MilestoneXFeatureDataModel.DataColumns.Feature:
if (!string.IsNullOrEmpty(data.Feature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MilestoneXFeatureDataModel.DataColumns.Feature, data.Feature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.Feature);
}
break;
case MilestoneXFeatureDataModel.DataColumns.Milestone:
if (!string.IsNullOrEmpty(data.Milestone))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MilestoneXFeatureDataModel.DataColumns.Milestone, data.Milestone);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.Milestone);
}
break;
case MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureState:
if (!string.IsNullOrEmpty(data.MilestoneFeatureState))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureState, data.MilestoneFeatureState);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.MilestoneFeatureState);
}
break;
case MilestoneXFeatureDataModel.DataColumns.Memo:
if (!string.IsNullOrEmpty(data.Memo))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MilestoneXFeatureDataModel.DataColumns.Memo, data.Memo);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MilestoneXFeatureDataModel.DataColumns.Memo);
}
break;
}
return(returnValue);
}
