/// <summary> /// Gets the exemption details. /// </summary> /// <param name="eventId">The event id.</param> /// <returns>DataSet contains Exemption Details</returns> public static F29650ExemptionData GetExemptionDetails(int eventId) { F29650ExemptionData exemptionDetails = new F29650ExemptionData(); Hashtable ht = new Hashtable(); ht.Add("@EventID", eventId); Utility.LoadDataSet(exemptionDetails.GetExemption, "f29650_pcget_Exemption", ht); return(exemptionDetails); }
/// <summary> /// Load Exemption Type ComboBox /// </summary> private void LoadExemptionCombo() { if (this.keyId > 0) { //// DB call for Get ExcemptionType this.exemptionTypeTable = this.form29650Controller.WorkItem.GetExemptionType(this.keyId); //// Add new column "ComboValue"(combination of ExemptionID and ExemptionCode) to get unique row this.exemptionTypeTable.ListExemptionType.Columns.Add("ComboValue", typeof(string), "ExemptionID +'|'+ExemptionCode"); //// Load ExemptionType combobox this.ExemptionTypeComboBox.DataSource = this.exemptionTypeTable.ListExemptionType; this.ExemptionTypeComboBox.DisplayMember = this.exemptionTypeTable.ListExemptionType.ExemptionCodeColumn.ColumnName; this.ExemptionTypeComboBox.ValueMember = "ComboValue"; this.ExemptionTypeComboBox.SelectedIndex = -1; } }
/// <summary> /// Loads the frozen value details. /// </summary> private void LoadExemptionDetails() { if (this.keyId > 0) { // DB call for f29650_pcget_FrozenValues(EventId) this.exemptionTable = this.form29650Controller.WorkItem.GetExemptionDetails(this.keyId); } // Set retrived values on appropriate controls this.SetControlValues(); if ((this.ExemptionTypeComboBox.SelectedValue != null) && !string.IsNullOrEmpty(this.ExemptionTypeComboBox.Text.Trim())) { this.tempExemptionId = this.ExemptionTypeComboBox.SelectedValue.ToString(); } }