private void RemoveByFieldConfigurationMode(int fieldConfigurationModeId) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeId = fieldConfigurationModeId; FieldConfigurationModeXApplicationRoleDataManager.Delete(data, SessionVariables.RequestProfile); }
protected override void ShowData(int FieldConfigurationModeXApplicationRoleId) { base.ShowData(FieldConfigurationModeXApplicationRoleId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = FieldConfigurationModeXApplicationRoleId; var entityList = FieldConfigurationModeXApplicationRoleDataManager.GetEntityList(data, SessionVariables.RequestProfile); if (entityList.Count == 1) { foreach (var entityItem in entityList) { lblFieldConfigurationModeXApplicationRoleId.Text = entityItem.FieldConfigurationModeXApplicationRoleId.ToString(); lblFieldConfigurationMode.Text = entityItem.FieldConfigurationMode; lblApplicationRole.Text = entityItem.ApplicationRole; lblFieldConfigurationModeAccessMode.Text = entityItem.FieldConfigurationModeAccessMode; oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction); oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.FieldConfigurationModeXApplicationRole, FieldConfigurationModeXApplicationRoleId, "FieldConfigurationModeXApplicationRole"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "FieldConfigurationModeXApplicationRole"); } } }
public static int Create(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Create"); var FieldConfigurationModeXApplicationRoleId = DBDML.RunScalarSQL("FieldConfigurationModeXApplicationRole.Insert", sql, DataStoreKey); return(Convert.ToInt32(FieldConfigurationModeXApplicationRoleId)); }
private DataTable GetData(string name) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); var dt = FieldConfigurationModeXApplicationRoleDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new FieldConfigurationModeXApplicationRoleDataModel(); UpdatedData = FieldConfigurationModeXApplicationRoleDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.FieldConfigurationModeXApplicationRoleId = Convert.ToInt32(SelectedData.Rows[i][FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId].ToString()); data.ApplicationRoleId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId).ToString()) : int.Parse(SelectedData.Rows[i][FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId].ToString()); data.FieldConfigurationModeId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId).ToString()) : int.Parse(SelectedData.Rows[i][FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId].ToString()); FieldConfigurationModeXApplicationRoleDataManager.Update(data, SessionVariables.RequestProfile); data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = Convert.ToInt32(SelectedData.Rows[i][FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId].ToString()); var dt = FieldConfigurationModeXApplicationRoleDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
private static string Save(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.FieldConfigurationModeXApplicationRoleInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.FieldConfigurationModeXApplicationRoleUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId) + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId) + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId) + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId); return(sql); }
public static DataTable Search(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { var list = GetEntityList(data, requestProfile); var table = list.ToDataTable(); return(table); }
protected override DataTable GetEntityData(int?entityKey) { var FieldConfigurationModeXApplicationRoledata = new FieldConfigurationModeXApplicationRoleDataModel(); FieldConfigurationModeXApplicationRoledata.FieldConfigurationModeXApplicationRoleId = entityKey; var results = FieldConfigurationModeXApplicationRoleDataManager.Search(FieldConfigurationModeXApplicationRoledata, SessionVariables.RequestProfile); return(results); }
private DataTable GetAssociatedRecords(int fieldConfigurationModeId) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeId = fieldConfigurationModeId; var dt = FieldConfigurationModeXApplicationRoleDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new FieldConfigurationModeXApplicationRoleDataModel(); var dt = FieldConfigurationModeXApplicationRoleDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Update(Dictionary <string, string> values) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = int.Parse(values[FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId].ToString()); data.ApplicationRoleId = int.Parse(values[FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId].ToString()); data.FieldConfigurationModeId = int.Parse(values[FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId].ToString()); FieldConfigurationModeXApplicationRoleDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
private void SaveFieldConfigurationModeXApplicationRole(int fieldConfigurationModeId, int ApplicationRoleId, int fieldConfigurationModeAccessModeId) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeId = fieldConfigurationModeId; data.ApplicationRoleId = ApplicationRoleId; data.FieldConfigurationModeAccessModeId = fieldConfigurationModeAccessModeId; FieldConfigurationModeXApplicationRoleDataManager.Create(data, SessionVariables.RequestProfile); }
public static DataTable SearchByFCModeAccessMode(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.FieldConfigurationModeXApplicationRoleSearchByFCModeAccessModeByFCModeAccessMode " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId) + ", " + ToSQLParameter(data, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode); var oDT = new DBDataTable("FieldConfigurationModeXApplicationRole.Search", sql, DataStoreKey); return(oDT.DBTable); }
public static void Delete(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.FieldConfigurationModeXApplicationRoleDelete "; var parameters = new { AuditId = requestProfile.AuditId , FieldConfigurationModeXApplicationRoleId = data.FieldConfigurationModeXApplicationRoleId , FieldConfigurationModeId = data.FieldConfigurationModeId , ApplicationRoleId = data.ApplicationRoleId , FieldConfigurationModeAccessModeId = data.FieldConfigurationModeAccessModeId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = int.Parse(index); FieldConfigurationModeXApplicationRoleDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public override int?Save(string action) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = FieldConfigurationModeXApplicationRoleId; data.FieldConfigurationModeId = FieldConfigurationModeId; data.ApplicationRoleId = ApplicationRoleId; data.FieldConfigurationModeAccessModeId = FieldConfigurationModeAccessModeId; if (action == "Insert") { FieldConfigurationModeXApplicationRoleDataManager.Create(data, SessionVariables.RequestProfile); } else { FieldConfigurationModeXApplicationRoleDataManager.Update(data, SessionVariables.RequestProfile); } return(data.FieldConfigurationModeXApplicationRoleId); }
public void LoadData(int FieldConfigurationModeXApplicationRoleId, bool showId) { var data = new FieldConfigurationModeXApplicationRoleDataModel(); data.FieldConfigurationModeXApplicationRoleId = FieldConfigurationModeXApplicationRoleId; var oFieldConfigurationModeXApplicationRoleTable = FieldConfigurationModeXApplicationRoleDataManager.GetEntityList(data, SessionVariables.RequestProfile); if (oFieldConfigurationModeXApplicationRoleTable.Count != 1) { return; } var item = oFieldConfigurationModeXApplicationRoleTable[0]; if (!showId) { FieldConfigurationModeXApplicationRoleId = item.FieldConfigurationModeXApplicationRoleId.Value; FieldConfigurationModeId = item.FieldConfigurationModeId; ApplicationRoleId = item.ApplicationRoleId; FieldConfigurationModeAccessModeId = item.FieldConfigurationModeAccessModeId; dynAuditHistory.Visible = true; txtFieldConfigurationModeXApplicationRoleId.Text = item.FieldConfigurationModeXApplicationRoleId.Value.ToString(); // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, FieldConfigurationModeXApplicationRoleId, PrimaryEntityKey); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "FieldConfigurationModeXApplicationRole"); } else { txtFieldConfigurationModeXApplicationRoleId.Text = String.Empty; } //drpApplicationRoleList.SelectedValue = Convert.ToString(row[FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId]); //drpFieldConfigurationModeList.SelectedValue = Convert.ToString(row[FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId]); //oUpdateInfo.LoadText(oFieldConfigurationModeXApplicationRoleTable.Rows[0]); }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var FieldConfigurationModeXApplicationRoledata = new FieldConfigurationModeXApplicationRoleDataModel(); selectedrows = FieldConfigurationModeXApplicationRoleDataManager.GetDetails(FieldConfigurationModeXApplicationRoledata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { FieldConfigurationModeXApplicationRoledata.FieldConfigurationModeXApplicationRoleId = entityKey; var result = FieldConfigurationModeXApplicationRoleDataManager.GetDetails(FieldConfigurationModeXApplicationRoledata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { FieldConfigurationModeXApplicationRoledata.FieldConfigurationModeXApplicationRoleId = SetId; var result = FieldConfigurationModeXApplicationRoleDataManager.GetDetails(FieldConfigurationModeXApplicationRoledata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static FieldConfigurationModeXApplicationRoleDataModel GetDetails(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { var list = GetEntityList(data, requestProfile); return(list.FirstOrDefault()); }
public static List <FieldConfigurationModeXApplicationRoleDataModel> GetEntityList(FieldConfigurationModeXApplicationRoleDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.FieldConfigurationModeXApplicationRoleSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , FieldConfigurationModeXApplicationRoleId = dataQuery.FieldConfigurationModeXApplicationRoleId , Name = dataQuery.FieldConfigurationMode , FieldConfigurationModeId = dataQuery.FieldConfigurationModeId , ApplicationRoleId = dataQuery.ApplicationRoleId , FieldConfigurationModeAccessModeId = dataQuery.FieldConfigurationModeAccessModeId }; List <FieldConfigurationModeXApplicationRoleDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FieldConfigurationModeXApplicationRoleDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static void Update(FieldConfigurationModeXApplicationRoleDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("FieldConfigurationModeXApplicationRole.Update", sql, DataStoreKey); }
public static string ToSQLParameter(FieldConfigurationModeXApplicationRoleDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId: if (data.FieldConfigurationModeXApplicationRoleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId, data.FieldConfigurationModeXApplicationRoleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeXApplicationRoleId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId: if (data.FieldConfigurationModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId: if (data.ApplicationRoleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId, data.ApplicationRoleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRoleId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId: if (data.FieldConfigurationModeAccessModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId, data.FieldConfigurationModeAccessModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessModeId); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode: if (!string.IsNullOrEmpty(data.FieldConfigurationMode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode, data.FieldConfigurationMode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationMode); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole: if (!string.IsNullOrEmpty(data.ApplicationRole)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole, data.ApplicationRole); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.ApplicationRole); } break; case FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode: if (!string.IsNullOrEmpty(data.FieldConfigurationModeAccessMode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode, data.FieldConfigurationModeAccessMode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeXApplicationRoleDataModel.DataColumns.FieldConfigurationModeAccessMode); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }