public ChartofAccountDAL() { List <ZColumn> _MasterColumnsList = new List <ZColumn>(); _MasterColumnsList.Add(new ZColumn { Name = "Id", FieldName = "Id", Required = false, ReadOnly = true, ColumnType = "int" }); _MasterColumnsList.Add(new ZColumn { Name = "Code", FieldName = "Code", Required = true, ReadOnly = false, ColumnType = "string" }); _MasterColumnsList.Add(new ZColumn { Name = "Name", FieldName = "Name", Required = true, ReadOnly = false, ColumnType = "string" }); _MasterColumnsList.Add(new ZColumn { Name = "Description", FieldName = "Description", Required = false, ReadOnly = false, ColumnType = "string" }); _MasterColumnsList.Add(new ZColumn { Name = "AccountTypeId", FieldName = "AccountTypeId", Required = true, ReadOnly = false, ColumnType = "int", DataSource = "AccountTypesAll", ValueMember = "Id", DisplayMember = "Name" }); _MasterColumnsList.Add(new ZColumn { Name = "Active", FieldName = "Active", Required = true, ReadOnly = false, ColumnType = "bool", DefaultValue = "true" }); SourceTables.Add(new ZTable { TableName = "tblChartOfAccounts", ParameterFieldName = "Id", ColumnList = _MasterColumnsList }); }
/// <summary> /// Builds a list of relatable table names /// </summary> private void BuildRelatedTableNames() { SessionHandler sh = new SessionHandler(Session); int patientId = sh.GetPatientId(); // only allow child tables which are direct children of Patients Patient patient = new Patient(); string parTableName = patient.TableName; string parKeyName = Patient.PatientId; int parKey = patientId; // get a list of relateable tables var relatedRecordsTables = GetRelatedTables(); // get a list of records and their counts (children of patients table) var tablesAndCounts = from table in relatedRecordsTables let tableName = table.Key let tableLabel = table.Value let doLookupCount = BOL.BusinessObject.GetParentTablename(tableName) == parTableName && BOL.BusinessObject.GetParentKeyName(tableName) == parKeyName let recordCount = doLookupCount ? BOL.BusinessObject.Count(tableName, new Dictionary <string, object> { { parKeyName, parKey } }) : 0 let normalizedCount = recordCount + (DestTableName == tableName ? -1 : 0) // only allow tables with records where !doLookupCount || normalizedCount > 0 select new { TableName = tableName, TableLabel = tableLabel + " (" + (doLookupCount ? normalizedCount.ToString() : "N/A") + ")" }; SourceTables.DataSource = tablesAndCounts; SourceTables.DataBind(); }
public BranchesDAL() { List <ZColumn> _MasterColumnsList = new List <ZColumn>(); _MasterColumnsList.Add(new ZColumn { Name = "Id", FieldName = "Id", Required = false, ReadOnly = true, ColumnType = "int" }); _MasterColumnsList.Add(new ZColumn { Name = "Code", FieldName = "Code", Required = true, ReadOnly = false, ColumnType = "string" }); _MasterColumnsList.Add(new ZColumn { Name = "Name", FieldName = "Name", Required = true, ReadOnly = false, ColumnType = "string" }); _MasterColumnsList.Add(new ZColumn { Name = "Active", FieldName = "Active", Required = true, ReadOnly = false, ColumnType = "bool", DefaultValue = "true" }); SourceTables.Add(new ZTable { TableName = "tblBranches", ParameterFieldName = "Id", ColumnList = _MasterColumnsList }); }