/// <summary> ///Function to get all the values from VoucherType Table /// </summary> /// <returns></returns> public List <DataTable> VoucherTypeViewAll() { List <DataTable> listObj = new List <DataTable>(); try { listObj = spVoucherType.VoucherTypeViewAll(); } catch (Exception ex) { MessageBox.Show("VT13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill Voucher no combobox /// </summary> public void VoucherComboFill() { try { VoucherTypeSP SpVoucherType = new VoucherTypeSP(); DataTable dtbl = new DataTable(); dtbl = SpVoucherType.VoucherTypeViewAll(); DataRow dr = dtbl.NewRow(); dr[0] = 0; dr[1] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbVoucherType.DataSource = dtbl; cmbVoucherType.ValueMember = "voucherTypeId"; cmbVoucherType.DisplayMember = "voucherTypeName"; cmbVoucherType.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show("RRP4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }