public override int?Save(string action)
{
var data = new FeatureXFeatureRuleDataModel();
data.FeatureXFeatureRuleId = FeatureXFeatureRuleId;
data.FeatureId = FeatureId;
data.FeatureRuleId = FeatureRuleId;
data.FeatureRuleStatusId = FeatureRuleStatusId;
if (action == "Insert")
{
var dtFeatureXFeatureRule = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFeatureXFeatureRule.Rows.Count == 0)
{
TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Update(data, SessionVariables.RequestProfile);
}
return(data.FeatureXFeatureRuleId);
}
protected override void ShowData(int FeatureXFeatureRuleId)
{
oDetailButtonPanel.SetId = SetId;
var data = new FeatureXFeatureRuleDataModel();
data.FeatureXFeatureRuleId = FeatureXFeatureRuleId;
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblFeatureXFeatureRuleId.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId]);
lblFeatureRule.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRule]);
lblFeature.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.Feature]);
lblFeatureRuleStatus.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatus]);
oUpdateInfo.LoadText(dt.Rows[0]);
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.FeatureXFeatureRule, FeatureXFeatureRuleId, "FeatureXFeatureRule");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "FeatureXFeatureRule");
}
else
{
Clear();
}
}
private static string Save(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.FeatureXFeatureRuleInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.FeatureXFeatureRuleUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId);
return(sql);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new FeatureXFeatureRuleDataModel();
if (values.ContainsKey(FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId))
{
data.FeatureXFeatureRuleId = int.Parse(values[FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId].ToString());
}
if (values.ContainsKey(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId))
{
data.FeatureRuleId = int.Parse(values[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId].ToString());
}
if (values.ContainsKey(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId))
{
data.FeatureRuleStatusId = int.Parse(values[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId].ToString());
}
if (values.ContainsKey(FeatureXFeatureRuleDataModel.DataColumns.FeatureId))
{
data.FeatureId = int.Parse(values[FeatureXFeatureRuleDataModel.DataColumns.FeatureId].ToString());
}
TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Update(data, SessionVariables.RequestProfile);
InlineEditingList.Data = GetData();
}
public static List <FeatureXFeatureRuleDataModel> GetEntityDetails(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FeatureXFeatureRuleSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId);
var result = new List <FeatureXFeatureRuleDataModel>();
using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new FeatureXFeatureRuleDataModel();
dataItem.FeatureXFeatureRuleId = (int?)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId];
dataItem.FeatureId = (int?)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureId];
dataItem.FeatureRuleId = (int?)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId];
dataItem.FeatureRuleStatusId = (int?)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId];
dataItem.Feature = (string)dbReader[FeatureXFeatureRuleDataModel.DataColumns.Feature];
dataItem.FeatureRule = (string)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureRule];
dataItem.FeatureRuleStatus = (string)dbReader[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatus];
SetBaseInfo(dataItem, dbReader);
result.Add(dataItem);
}
}
return(result);
}
private DataTable GetFeatureXFeatureRuleData(int featureId)
{
var data = new FeatureXFeatureRuleDataModel();
data.FeatureId = featureId;
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new FeatureXFeatureRuleDataModel();
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var featureXFeatureRuledata = new FeatureXFeatureRuleDataModel();
featureXFeatureRuledata.FeatureXFeatureRuleId = entityKey;
var results = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Search(featureXFeatureRuledata, SessionVariables.RequestProfile);
return(results);
}
public static void Delete(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FeatureXFeatureRuleDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId);
DBDML.RunSQL("FeatureXFeatureRule.Delete", sql, DataStoreKey);
}
public static DataTable DoesExist(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FeatureXFeatureRuleSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId);
var oDT = new DBDataTable("FeatureXFeatureRule.DoesExist", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable Search(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var mergeddt = new DataTable();
if (data.FeatureRuleStatusIds != null && data.FeatureRuleStatusIds.Length >= 1)
{
for (int i = 0; i < data.FeatureRuleStatusIds.Length; i++)
{
var sql = "EXEC dbo.FeatureXFeatureRuleSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureId) +
", @FeatureRuleStatusId = " + data.FeatureRuleStatusIds[i] +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId);
var oDT = new DBDataTable("FeatureXFeatureRule.Search", sql, DataStoreKey);
var dt = new DataTable();
dt = oDT.DBTable;
if (mergeddt.Rows.Count == 0)
{
mergeddt = dt.Clone();
}
foreach (DataRow row in dt.Rows)
{
mergeddt.ImportRow(row);
}
}
return(mergeddt);
}
else
{
// formulate SQL
var sql = "EXEC dbo.FeatureXFeatureRuleSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId) +
", " + ToSQLParameter(data, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId);
var oDT = new DBDataTable("FeatureXFeatureRule.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 FeatureXFeatureRuleDataModel();
data.FeatureXFeatureRuleId = int.Parse(index);
TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Delete(data, SessionVariables.RequestProfile);
}
DeleteAndRedirect();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public void LoadData(int FeatureXFeatureRuleId, bool showId)
{
var data = new FeatureXFeatureRuleDataModel();
data.FeatureXFeatureRuleId = FeatureXFeatureRuleId;
var oFeatureXFeatureRuleTable = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (oFeatureXFeatureRuleTable.Rows.Count == 1)
{
var row = oFeatureXFeatureRuleTable.Rows[0];
if (!showId)
{
txtFeatureXFeatureRuleId.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId]);
dynAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.FeatureXFeatureRule, FeatureXFeatureRuleId, "FeatureXFeatureRule");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "FeatureXFeatureRule");
}
else
{
txtFeatureXFeatureRuleId.Text = String.Empty;
}
txtFeatureRuleId.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId]);
txtFeatureId.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureId]);
txtFeatureRuleStatusId.Text = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId]);
drpFeatureRuleStatusList.SelectedValue = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId]);
drpFeatureList.SelectedValue = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureId]);
drpFeatureRuleList.SelectedValue = Convert.ToString(row[FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId]);
}
else
{
txtFeatureXFeatureRuleId.Text = String.Empty;
txtFeatureId.Text = String.Empty;
txtFeatureRuleStatusId.Text = String.Empty;
txtFeatureRuleId.Text = String.Empty;
}
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var featureXFeatureRuledata = new FeatureXFeatureRuleDataModel();
selectedrows = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.GetDetails(featureXFeatureRuledata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
featureXFeatureRuledata.FeatureXFeatureRuleId = entityKey;
var result = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.GetDetails(featureXFeatureRuledata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
featureXFeatureRuledata.FeatureXFeatureRuleId = SetId;
var result = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.GetDetails(featureXFeatureRuledata, 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 FeatureXFeatureRuleDataModel();
UpdatedData = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.FeatureXFeatureRuleId =
Convert.ToInt32(SelectedData.Rows[i][FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId].ToString());
data.FeatureId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureId))
: int.Parse(SelectedData.Rows[i][FeatureXFeatureRuleDataModel.DataColumns.FeatureId].ToString());
data.FeatureRuleId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId))
: int.Parse(SelectedData.Rows[i][FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId].ToString());
data.FeatureRuleStatusId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId).ToString())
: int.Parse(SelectedData.Rows[i][FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId].ToString());
TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Update(data, SessionVariables.RequestProfile);
data = new FeatureXFeatureRuleDataModel();
data.FeatureXFeatureRuleId = Convert.ToInt32(SelectedData.Rows[i][FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId].ToString());
var dt = TaskTimeTracker.Components.BusinessLayer.Feature.FeatureXFeatureRuleDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public static FeatureXFeatureRuleDataModel GetDetails(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile);
return(list.FirstOrDefault());
}
public static string ToSQLParameter(FeatureXFeatureRuleDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId:
if (data.FeatureXFeatureRuleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId, data.FeatureXFeatureRuleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureXFeatureRuleId);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId:
if (data.FeatureRuleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId, data.FeatureRuleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleId);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.FeatureId:
if (data.FeatureId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXFeatureRuleDataModel.DataColumns.FeatureId, data.FeatureId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureId);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId:
if (data.FeatureRuleStatusId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId, data.FeatureRuleStatusId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatusId);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.FeatureRule:
if (!string.IsNullOrEmpty(data.FeatureRule))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FeatureXFeatureRuleDataModel.DataColumns.FeatureRule, data.FeatureRule);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureRule);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.Feature:
if (!string.IsNullOrEmpty(data.Feature))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FeatureXFeatureRuleDataModel.DataColumns.Feature, data.Feature);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.Feature);
}
break;
case FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatus:
if (!string.IsNullOrEmpty(data.FeatureRuleStatus))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatus, data.FeatureRuleStatus);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FeatureXFeatureRuleDataModel.DataColumns.FeatureRuleStatus);
}
break;
}
return(returnValue);
}
public static void Update(FeatureXFeatureRuleDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("FeatureXFeatureRule.Update", sql, DataStoreKey);
}
