protected override void PopulateControl() { base.PopulateControl(); this.packSellingCompany.DataSource = Common.SellingCompany.FetchAll(); this.packType.DataSource = Packtype.FetchAll(); this.packOutputMethod.DataSource = OutputQueue.FetchAll(); //Gets merge fields list var mergeFields = new List <KeyValuePair <string, byte> >(); var packTypeList = Packtype.FetchAll(); foreach (var packTypeObject in packTypeList) { var mergeFieldListFromView = Query.Create() .Select("COLUMN_NAME") .From(QuerySources.PackMergeFields) .WhereRaw("(TABLE_NAME = '" + packTypeObject.StoredProc + "' and COLUMN_NAME not like 'PR_ID%')", null) .OrderBy("COLUMN_NAME", true) .Run(); foreach (var field in mergeFieldListFromView) { mergeFields.Add(new KeyValuePair <string, byte>(field.Values.First().ToString(), packTypeObject.Type)); } } this.AllMergeFields.DataSource = mergeFields; if (this.Id.FieldValue == "") { this.packRetainAttachments.FieldValue = true; this.DataSource.ActPqKeep = 1; this.packSellingCompany.FieldValue = this.CurrentSession.User.SellingCompanyId; } else { this.packSellingCompany.FieldValue = this.DataSource.PackSellingCompanyIdId; Packtype objPackType = Packtype.FetchAll().Where(s => s.Type == this.DataSource.PackType).FirstOrDefault(); if (objPackType != null) { this.packType.FieldValue = objPackType.Type.ToString(); this.packType.DisplayMember = objPackType.Desc; } this.packType.IsReadOnly = ConfigurableBoolean.True; //this.packDeliveryFailure.FieldValue = false; //this.packDeliveryDelay.FieldValue = false; //this.packDeliverySuccess.FieldValue = false; if (!string.IsNullOrEmpty(this.DataSource.DsnOptions)) { var dsnOptions = this.DataSource.DsnOptions.Split(','); foreach (string val in dsnOptions) { getDSNOptionsVal(val); } } } }