public override int?Save(string action)
{
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = ApplicationOperationId;
data.Name = Name;
data.Description = Description;
data.SortOrder = SortOrder;
data.ApplicationId = ApplicationId;
data.SystemEntityTypeId = SystemEntityTypeId;
data.OperationValue = OperationValue;
if (action == "Insert")
{
var dtApplicationOperation = Framework.Components.ApplicationUser.ApplicationOperationDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtApplicationOperation.Rows.Count == 0)
{
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Update(data, SessionVariables.RequestProfile);
}
// not correct ... when doing insert, we didn't get/change the value of ClientID ?
return(data.ApplicationOperationId);
}
public static List <ApplicationOperationDataModel> GetEntityDetails(ApplicationOperationDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.ApplicationOperationSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = dataQuery.Application
, ApplicationMode = requestProfile.ApplicationModeId
, ReturnAuditInfo = returnAuditInfo
, ApplicationOperationId = dataQuery.ApplicationOperationId
, Name = dataQuery.Name
, SystemEntityId = dataQuery.SystemEntityType
};
List <ApplicationOperationDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <ApplicationOperationDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var data = new ApplicationOperationDataModel();
var list = GetEntityDetails(data, requestProfile);
return(list.ToDataTable());
}
private static string CreateOrUpdate(ApplicationOperationDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.ApplicationOperationInsert ";
break;
case "Update":
sql += "dbo.ApplicationOperationUpdate ";
break;
default:
break;
}
sql = sql + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.ApplicationOperationId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Description) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder) +
", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.OperationValue);
return(sql);
}
protected override void ShowData(int applicationoperationid)
{
oDetailButtonPanel.SetId = SetId;
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = applicationoperationid;
var dt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblApplicationOperationId.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.ApplicationOperationId]);
lblName.Text = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
lblDescription.Text = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
lblSortOrder.Text = Convert.ToString(row[StandardDataModel.StandardDataColumns.SortOrder]);
lblApplicationId.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.Application]);
lblSystemEntityTypeId.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.SystemEntityType]);
lblOperationValue.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.OperationValue]);
oUpdateInfo.LoadText(dt.Rows[0]);
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.ApplicationOperation, applicationoperationid, "ApplicationOperation");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationOperation");
}
else
{
Clear();
}
}
//public static DataTable Search(ApplicationOperationDataModel data, RequestProfile requestProfile)
//{
// // formulate SQL
// var sql = "EXEC dbo.ApplicationOperationSearch " +
// " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
// //", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) +
// ", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.ApplicationOperationId) +
// ", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.ApplicationId) +
// ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name) +
// ", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.SystemEntityId);
// var oDT = new DataAccess.DBDataTable("ApplicationOperation.Search", sql, DataStoreKey);
// return oDT.DBTable;
//}
public static DataTable Search(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
var table = list.ToDataTable();
return(table);
}
private DataTable GetApplicationOperationData(int applicationId)
{
var data = new ApplicationOperationDataModel();
var dt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var applicationOperationdata = new ApplicationOperationDataModel();
applicationOperationdata.ApplicationOperationId = entityKey;
var results = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(applicationOperationdata, SessionVariables.RequestProfile);
return(results);
}
public static DataTable DoesExist(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new ApplicationOperationDataModel();
doesExistRequest.SystemEntityTypeId = data.SystemEntityTypeId;
doesExistRequest.Name = data.Name;
return(Search(doesExistRequest, requestProfile));
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new ApplicationOperationDataModel();
var dt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private DataTable GetData(string name)
{
var data = new ApplicationOperationDataModel();
data.Name = name;
var dt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new ApplicationOperationDataModel();
// copies properties from values dictionary object to data object
PropertyMapper.CopyProperties(data, values);
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
private static DataSet GetChildren(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationOperationChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationOperationDataModel.DataColumns.ApplicationOperationId);
var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static bool DoesExist(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new ApplicationOperationDataModel();
doesExistRequest.SystemEntityTypeId = data.SystemEntityTypeId;
doesExistRequest.Name = data.Name;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
public static void Delete(ApplicationOperationDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.ApplicationOperationDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationOperationId = dataQuery.ApplicationOperationId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var notDeletableIds = new List <int>();
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = int.Parse(index);
if (!Framework.Components.ApplicationUser.ApplicationOperationDataManager.IsDeletable(data, SessionVariables.RequestProfile))
{
notDeletableIds.Add(Convert.ToInt32(data.ApplicationOperationId));
}
}
if (notDeletableIds.Count == 0)
{
foreach (string index in deleteIndexList)
{
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = int.Parse(index);
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.ApplicationOperation, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("ApplicationOperationEntityRoute", new { Action = "Default", SetId = true }), false);
}
else
{
var msg = String.Empty;
foreach (var id in notDeletableIds)
{
if (!string.IsNullOrEmpty(msg))
{
msg += ", <br/>";
}
msg += "ApplicationOperationId: " + id + " has detail records";
}
Response.Write(msg);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new ApplicationOperationDataModel();
UpdatedData = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.ApplicationOperationId =
Convert.ToInt32(SelectedData.Rows[i][ApplicationOperationDataModel.DataColumns.ApplicationOperationId].ToString());
data.Name = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Name))
? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Name).ToString()
: SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Name].ToString();
data.Description =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description))
? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description).ToString()
: SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Description].ToString();
data.OperationValue =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ApplicationOperationDataModel.DataColumns.OperationValue))
? CheckAndGetRepeaterTextBoxValue(ApplicationOperationDataModel.DataColumns.OperationValue).ToString()
: SelectedData.Rows[i][ApplicationOperationDataModel.DataColumns.OperationValue].ToString();
data.SortOrder =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder))
? int.Parse(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder).ToString())
: int.Parse(SelectedData.Rows[i][StandardDataModel.StandardDataColumns.SortOrder].ToString());
data.SystemEntityTypeId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ApplicationOperationDataModel.DataColumns.SystemEntityTypeId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ApplicationOperationDataModel.DataColumns.SystemEntityTypeId).ToString())
: int.Parse(SelectedData.Rows[i][ApplicationOperationDataModel.DataColumns.SystemEntityTypeId].ToString());
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Update(data, SessionVariables.RequestProfile);
data = new ApplicationOperationDataModel();
data.ApplicationOperationId = Convert.ToInt32(SelectedData.Rows[i][ApplicationOperationDataModel.DataColumns.ApplicationOperationId].ToString());
var dt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public void LoadData(int applicationoperationid, bool showId)
{
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = applicationoperationid;
var oApplicationTable = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (oApplicationTable.Rows.Count == 1)
{
var row = oApplicationTable.Rows[0];
if (!showId)
{
txtApplicationOperationId.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.ApplicationOperationId]);
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.ApplicationOperation, applicationoperationid, "ApplicationOperation");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationOperation");
}
else
{
txtApplicationOperationId.Text = String.Empty;
}
txtDescription.InnerText = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
txtName.Text = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
txtSortOrder.Text = Convert.ToString(row[StandardDataModel.StandardDataColumns.SortOrder]);
txtApplicationId.Text = Convert.ToString(row[BaseDataModel.BaseDataColumns.ApplicationId]);
txtSystemEntityTypeId.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.SystemEntityTypeId]);
txtOperationValue.Text = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.OperationValue]);
drpApplicationList.SelectedValue = Convert.ToString(row[BaseDataModel.BaseDataColumns.ApplicationId]);
drpSystemEntityTypeList.SelectedValue = Convert.ToString(row[ApplicationOperationDataModel.DataColumns.SystemEntityTypeId]);
oUpdateInfo.LoadText(row);
}
else
{
txtApplicationId.Text = String.Empty;
txtDescription.InnerText = String.Empty;
txtName.Text = String.Empty;
txtSortOrder.Text = String.Empty;
txtApplicationId.Text = String.Empty;
txtSystemEntityTypeId.Text = String.Empty;
txtOperationValue.Text = String.Empty;
drpSystemEntityTypeList.SelectedValue = "-1";
drpApplicationList.SelectedValue = "-1";
}
}
public static bool IsDeletable(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var isDeletable = true;
var ds = GetChildren(data, requestProfile);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count > 0)
{
isDeletable = false;
break;
}
}
}
return(isDeletable);
}
/// <summary>
/// 1. the left side should not have any of the values that are on the right side
// and simlar right should not have any that is on left
/// </summary>
private void CleanUp()
{
var ApplicationRoleId = int.Parse(drpParent.SelectedItem.Value);
var CurrentAssignment = Framework.Components.ApplicationUser.ApplicationOperationXApplicationRoleDataManager.GetByApplicationRole(ApplicationRoleId, SessionVariables.RequestProfile);
foreach (DataRow row in CurrentAssignment.Rows)
{
var item = new ListItem();
var data = new ApplicationOperationDataModel();
data.ApplicationOperationId = int.Parse(row["ApplicationOperationId"].ToString());
var ApplicationRoleTable = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(data, SessionVariables.RequestProfile);
var row1 = ApplicationRoleTable.Rows[0];
item.Value = row["ApplicationOperationId"].ToString();
item.Text = row1["Name"].ToString();
lstSource.Items.Remove(item);
}
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var applicationOperationdata = new ApplicationOperationDataModel();
selectedrows = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(applicationOperationdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
applicationOperationdata.ApplicationOperationId = entityKey;
var result = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(applicationOperationdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
applicationOperationdata.ApplicationOperationId = SetId;
var result = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(applicationOperationdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
public static string ToSQLParameter(ApplicationOperationDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ApplicationOperationDataModel.DataColumns.ApplicationOperationId:
if (data.ApplicationOperationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.ApplicationOperationId, data.ApplicationOperationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.ApplicationOperationId);
}
break;
case BaseDataModel.BaseDataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, BaseDataModel.BaseDataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, BaseDataModel.BaseDataColumns.ApplicationId);
}
break;
case ApplicationOperationDataModel.DataColumns.SystemEntityTypeId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.SystemEntityTypeId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityTypeId);
}
break;
case ApplicationOperationDataModel.DataColumns.SystemEntityId:
if (data.SystemEntityTypeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationOperationDataModel.DataColumns.SystemEntityId, data.SystemEntityTypeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityId);
}
break;
case StandardDataModel.StandardDataColumns.SortOrder:
if (data.SortOrder != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, StandardDataModel.StandardDataColumns.SortOrder, data.SortOrder);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.SortOrder);
}
break;
case ApplicationOperationDataModel.DataColumns.OperationValue:
if (!string.IsNullOrEmpty(data.OperationValue))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.OperationValue, data.OperationValue);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.OperationValue);
}
break;
case ApplicationOperationDataModel.DataColumns.Application:
if (!string.IsNullOrEmpty(data.Application))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.Application, data.Application);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.Application);
}
break;
case ApplicationOperationDataModel.DataColumns.SystemEntityType:
if (!string.IsNullOrEmpty(data.SystemEntityType))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationOperationDataModel.DataColumns.SystemEntityType, data.SystemEntityType);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationOperationDataModel.DataColumns.SystemEntityType);
}
break;
case StandardDataModel.StandardDataColumns.Name:
if (!string.IsNullOrEmpty(data.Name))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StandardDataModel.StandardDataColumns.Name, data.Name);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.Name);
}
break;
case StandardDataModel.StandardDataColumns.Description:
if (!string.IsNullOrEmpty(data.Description))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StandardDataModel.StandardDataColumns.Description, data.Description);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StandardDataModel.StandardDataColumns.Description);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DataAccess.DBDML.RunSQL("ApplicationOperation.Update", sql, DataStoreKey);
}
protected override void OnInit(EventArgs e)
{
try
{
var superKey = "";
var newId = Framework.Components.Core.SystemEntityTypeDataManager.GetNextSequence("ApplicationOperation", (int)Framework.Components.DataAccess.SystemEntity.ApplicationOperation, SessionVariables.RequestProfile);
var ApplicationOperationdata = new ApplicationOperationDataModel();
var systemdevdata = new SystemDevNumbersDataModel();
systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId;
var dtnumbers = Framework.Components.Core.SystemDevNumbersDataManager.Search(systemdevdata, SessionVariables.RequestProfile);
var rangefrom =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString());
var rangeto =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString());
if (Request.QueryString["SuperKey"] != null)
{
superKey = Request.QueryString["SuperKey"].ToString();
var data = new SuperKeyDetailDataModel();
data.SuperKeyId = Convert.ToInt32(superKey);
data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.ApplicationOperation;
var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]);
ApplicationOperationdata.ApplicationOperationId = key;
var ApplicationOperationdt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(ApplicationOperationdata, SessionVariables.RequestProfile);
if (ApplicationOperationdt.Rows.Count == 1)
{
var row = ApplicationOperationdt.Rows[0];
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
ApplicationOperationdata.ApplicationOperationId = GetNextValidId(rangefrom);
}
ApplicationOperationdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
ApplicationOperationdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
ApplicationOperationdata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Create(ApplicationOperationdata, SessionVariables.RequestProfile);
}
}
}
}
else if (Request.QueryString["SetId"] != null)
{
var key = int.Parse(Request.QueryString["SetId"]);
ApplicationOperationdata.ApplicationOperationId = key;
var ApplicationOperationdt = Framework.Components.ApplicationUser.ApplicationOperationDataManager.GetDetails(ApplicationOperationdata, SessionVariables.RequestProfile);
if (ApplicationOperationdt.Rows.Count == 1)
{
var row = ApplicationOperationdt.Rows[0];
var newApplicationOperationdata = new ApplicationOperationDataModel();
if (Request.QueryString["Mode"].ToString().Equals("Test"))
{
newApplicationOperationdata.ApplicationOperationId = newId = (int)GetNextValidId(rangefrom);
}
newApplicationOperationdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
newApplicationOperationdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
newApplicationOperationdata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
UpdatedFKDepenedencies(key, newId);
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Delete(ApplicationOperationdata, SessionVariables.RequestProfile);
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Create(newApplicationOperationdata, SessionVariables.RequestProfile);
}
}
else if (Request.QueryString["Mode"].ToString().Equals("Renumber"))
{
var seed = int.Parse(Request.QueryString["Seed"].ToString());
//ApplicationVariables.Seed;
var increment = int.Parse(Request.QueryString["Increment"].ToString());
//ApplicationVariables.Increment;
Framework.Components.ApplicationUser.ApplicationOperationDataManager.Renumber(seed, increment, SessionVariables.RequestProfile);
}
base.OnInit(e);
Response.Redirect("Default.aspx?Added=true", false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public static ApplicationOperationDataModel GetDetails(ApplicationOperationDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
