private void LoadMainGrid() { fGrid.BeginUpdate(); iGRow _row = null; _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; int group_index = 1; string group_name = "New Account Information"; // var _date = new fnn.DropDownCalenderX(); _date.start_date = new DateTime(2015, 1, 1); _date.end_date = sdata.CURR_DATE; _date.selected_date = sdata.CURR_DATE; _row = CreateNewRow("Date", "start_date", typeof(string), group_index, group_name); // _row.Cells["desc"].TypeFlags = iGCellTypeFlags.ComboPreferValue | iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["desc"].FormatString = "{0:D}";// {0:d} for short date string _row.Cells["desc"].DropDownControl = _date; _row.Cells["desc"].Value = null; // _row = CreateNewRow("Bank Name", "bank", typeof(string), group_index, group_name); _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; _row = CreateNewRow("(+F1) Account Name", "exp_account", typeof(string), group_index, group_name); _row = CreateNewRow("Account Type", "category", typeof(string), group_index, group_name); _row.Cells[1].Enabled = iGBool.False; // // _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("Amount", "amount", typeof(decimal), group_index, group_name); _row.Cells[1].FormatString = "{0:N0}"; // _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; _row = CreateNewRow("Enter \n Particulars", "desc", typeof(string), group_index, group_name); _row.Height = 60; _row.Cells["desc"].TextFormatFlags = iGStringFormatFlags.WordWrap; _row.Cells["name"].TextAlign = iGContentAlignment.MiddleRight; // _row = fGrid.Rows.Add(); _row.Height = 5; _row.BackColor = Color.Lavender; _row.Selectable = false; fGrid.EndUpdate(); }
private void fGrid_AfterCommitEdit(object sender, iGAfterCommitEditEventArgs e) { var _key = fGrid.Rows[e.RowIndex].Key; switch (_key) { case "date": { DateTime?_date = System.Convert.ToDateTime(fGrid.Rows[e.RowIndex].Cells[1].Value); fGrid.Rows["curr_amount"].Cells[1].Value = null; fGrid.Rows["curr_exch_rate"].Cells[1].Value = null; using (var xd = new xing()) { int _acc_id = (fGrid.Rows["currency"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag.ToInt32(); float _exch_rate = accn.GetFS_ConversionRate(xd, fn.GetFSID(_date.Value), _acc_id); int _acc_bal = accn.GetFS_ForeignCurrencyBalance(xd, fn.GetFSID(_date.Value), _acc_id); fGrid.Rows["curr_exch_rate"].Cells[1].Value = _exch_rate; if (_acc_bal > 0) { fGrid.Rows["curr_amount"].Cells[1].Value = _acc_bal; } xd.CommitTransaction(); } break; } case "currency": { if (fGrid.Rows[e.RowIndex].Cells[1].Value == null) { fGrid.Rows["curr_amount"].Cells[1].Value = null; fGrid.Rows["curr_exch_rate"].Cells[1].Value = null; // fGrid.Rows["exch_amount"].Cells[1].Value = null; fGrid.Rows["exch_rate"].Cells[1].Value = null; fGrid.Rows["ug_amount"].Cells[1].Value = null; fGrid.Rows["gain"].Cells[1].Value = null; fGrid.Rows["loss"].Cells[1].Value = null; fGrid.Rows["date"].Cells[1].Value = null; fGrid.Rows["date"].Cells[1].AuxValue = null; fGrid.Rows["date"].Cells[1].Enabled = iGBool.False; fGrid.Rows["exch_amount"].Cells[0].Value = "Amount Exchanged"; } else { fGrid.Rows["curr_amount"].Cells[1].Value = null; fGrid.Rows["curr_exch_rate"].Cells[1].Value = null; // fGrid.Rows["exch_amount"].Cells[1].Value = null; fGrid.Rows["exch_rate"].Cells[1].Value = null; fGrid.Rows["ug_amount"].Cells[1].Value = null; fGrid.Rows["gain"].Cells[1].Value = null; fGrid.Rows["loss"].Cells[1].Value = null; fGrid.Rows["date"].Cells[1].Value = null; fGrid.Rows["date"].Cells[1].AuxValue = null; fGrid.Rows["date"].Cells[1].Enabled = iGBool.True; fGrid.Rows["exch_amount"].Cells[0].Value = string.Format("{0} Exchanged", fGrid.Rows["currency"].Cells[1].Text); // using (var xd = new xing()) { int _acc_id = (fGrid.Rows["currency"].Cells[1].AuxValue as fnn.iGComboItemEX).Tag.ToInt32(); object _obj = xd.ExecuteScalarObject(string.Format("select last_exchange_date from acc_foreign_currency_tb where sys_account_id={0}", _acc_id)); if (_obj == null) { _obj = xd.ExecuteScalarObject(string.Format("select TOP 1 fs_date from acc_foreign_currency_mvt_tb where sys_account_id={0} order by fs_id", _acc_id)); } DateTime?_start_date = System.Convert.ToDateTime(_obj); var _date = new fnn.DropDownCalenderX(); if (_start_date != null) { _date.start_date = _start_date.Value; _date.end_date = sdata.CURR_DATE; _date.selected_date = sdata.CURR_DATE; } else { _date.start_date = sdata.CURR_DATE; _date.end_date = sdata.CURR_DATE; _date.selected_date = sdata.CURR_DATE; } fGrid.Rows["date"].Cells["desc"].DropDownControl = _date; } } break; } case "exch_amount": case "exch_rate": { fGrid.Rows["gain"].Cells[1].Value = null; fGrid.Rows["loss"].Cells[1].Value = null; fGrid.Rows["ug_amount"].Cells[1].Value = null; if (_key == "exch_amount") { if ((fGrid.Rows["exch_amount"].Cells[1].Value.ToInt32() > fGrid.Rows["curr_amount"].Cells[1].Value.ToInt32()) | (fGrid.Rows["exch_amount"].Cells[1].Value.ToInt32() <= 0)) { MessageBox.Show("The Amount You Have Entered INVALID", "Invalid Value Error", MessageBoxButtons.OK, MessageBoxIcon.Error); fGrid.Focus(); fGrid.Rows[e.RowIndex].Cells[1].Value = null; fGrid.Rows[e.RowIndex].Cells[1].Selected = true; fGrid.Rows["exch_rate"].Cells[1].Value = null; return; } } if (_key == "exch_rate") { int _c = (fGrid.Rows["exch_rate"].Cells[1].Value.ToFloat() - fGrid.Rows["curr_exch_rate"].Cells[1].Value.ToFloat()).ToInt32(); if (Math.Abs(_c) > (fGrid.Rows["curr_exch_rate"].Cells[1].Value.ToFloat() * 0.75).ToInt32()) { MessageBox.Show("The Exchange Rate You Entered Is Probably Wrong", "Wrong Exchange Rate Error"); fGrid.Focus(); fGrid.Rows[e.RowIndex].Cells[1].Value = null; fGrid.Rows[e.RowIndex].Cells[1].Selected = true; return; } } if (fGrid.Rows["exch_amount"].Cells[1].Value != null & fGrid.Rows["exch_rate"].Cells[1].Value != null) { fGrid.Rows["ug_amount"].Cells[1].Value = (fGrid.Rows["exch_amount"].Cells[1].Value.ToInt32() * fGrid.Rows["exch_rate"].Cells[1].Value.ToFloat()).ToInt32(); var _diff = (fGrid.Rows["ug_amount"].Cells[1].Value.ToInt32() - ((fGrid.Rows["exch_amount"].Cells[1].Value.ToInt32() * fGrid.Rows["curr_exch_rate"].Cells[1].Value.ToFloat()).ToInt32())); if (_diff > 0) { fGrid.Rows["gain"].Cells[1].Value = _diff; } else { if (_diff != 0) { fGrid.Rows["loss"].Cells[1].Value = Math.Abs(_diff); } } } break; } } if (e.RowIndex != fGrid.Rows.Count - 1) { if (fGrid.Rows[e.RowIndex].Cells["desc"].Value == null) { return; } for (int k = e.RowIndex + 1; k < fGrid.Rows.Count; k++) { if (fGrid.Rows[k].Type == iGRowType.AutoGroupRow) { fGrid.Rows[k].Expanded = true; continue; } if (!fGrid.Rows[k].Visible) { continue; } if (fGrid.Rows[k].Cells[1].Enabled == iGBool.False) { continue; } if (fGrid.Rows[k].Cells[1].ReadOnly == iGBool.True) { continue; } if (string.IsNullOrEmpty(fGrid.Rows[k].Key)) { continue; } if ((e.RowIndex + 3) < fGrid.Rows.Count) { fGrid.Rows[(e.RowIndex + 3)].EnsureVisible(); } fGrid.SetCurCell(k, e.ColIndex); break; } } }
private void LoadMainGrid() { fGrid.BeginUpdate(); iGRow _row = null; _row = fGrid.Rows.Add(); _row.Height = 7; _row.BackColor = Color.Lavender; _row.Selectable = false; int group_index = 1; string group_name = "New Account Information"; _row = CreateNewRow("Pledge Account", "pledge_acc", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Cells[1].Value = string.IsNullOrEmpty(m_pledge_settings.pledge_name) ? datam.DATA_ACCOUNTS[m_pledge_settings.account_id].account_name : m_pledge_settings.pledge_name; _row.Cells[1].Enabled = iGBool.False; _row.Height += 4; _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("(+ F1) Member Name", "owner", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Height += 4; // _row = CreateNewRow("(+ F2) Pledge Account", "account", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Height += 4; _row.Visible = false; // // _row = CreateNewRow("Name", "other_name", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Height += 3; _row.Visible = false; // _row = CreateNewRow("Phone", "other_phone", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Height += 3; _row.Visible = false; // _row = fGrid.Rows.Add(); _row.Height = 7; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("Pledged Amount", "pl_amount", typeof(decimal), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Cells[1].FormatString = "{0:N0}"; _row.Height += 4; _row.ForeColor = Color.Maroon; // _row = fGrid.Rows.Add(); _row.Height = 7; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("Church Group", "churh_group", typeof(string), group_index, group_name); _row.Cells[0].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Font = new Font("verdana", 15, FontStyle.Regular); _row.Height += 4; _row.Cells[1].Enabled = iGBool.False; _row.Visible = false; _row = fGrid.Rows.Add(); _row.Height = 7; _row.BackColor = Color.Lavender; _row.Selectable = false; _row.Visible = false; // var _dropdown = new fnn.DropDownCalenderX(); _dropdown.start_date = m_pledge_settings.start_date; _dropdown.selected_date = sdata.CURR_DATE; _dropdown.end_date = sdata.CURR_DATE; _row = CreateNewRow("Add To Pledge Date", "start_date", typeof(string), group_index, group_name); _row.Cells["desc"].TypeFlags = iGCellTypeFlags.ComboPreferValue | iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["desc"].FormatString = "{0:D}";// {0:d} for short date string _row.Cells["desc"].DropDownControl = _dropdown; _row.Cells["desc"].Value = null; // _row = CreateNewRow("Collect Date (Optional)", "collect_date", typeof(string), group_index, group_name); _row.Font = new Font("georgia", 13, FontStyle.Regular); _row.Cells["desc"].TypeFlags = iGCellTypeFlags.ComboPreferValue | iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["desc"].FormatString = "{0:D}";// {0:d} for short date string _row.Cells["desc"].Value = sdata.CURR_DATE; _row.Cells["desc"].DropDownControl = new fnn.DropDownCalendar(); _row.Cells["name"].TypeFlags = iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["name"].ReadOnly = iGBool.False; _row.Cells["name"].ForeColor = Color.DarkSlateGray; _row.Cells["name"].Selectable = iGBool.False; _row.Cells["name"].TextAlign = iGContentAlignment.MiddleRight; _row.Cells[1].Enabled = iGBool.False; _row.Visible = false; fGrid.EndUpdate(); }
private void LoadMainGrid() { fGrid.BeginUpdate(); iGRow _row = null; _row = fGrid.Rows.Add(); _row.Height = 5; _row.BackColor = Color.Lavender; _row.Selectable = false; int group_index = 1; string group_name = "New Account Information"; // _row = CreateNewRow("Select Currency", "currency", typeof(string), group_index, group_name); _row.Cells[0].ForeColor = Color.Maroon; var _nlist = accn.GetChildAccounts("UNBANKED_FOREIGN", em.account_typeS.ActualAccount); var icombo = fnn.CreateCombo(); foreach (var k in _nlist) { icombo.Items.Add(new fnn.iGComboItemEX() { Value = k.account_name, Tag = k.account_id }); } _row.Cells[1].DropDownControl = icombo; _row.Cells[1].Value = null; // var _date = new fnn.DropDownCalenderX(); _date.start_date = sdata.CURR_DATE; _date.end_date = sdata.CURR_DATE; _date.selected_date = sdata.CURR_DATE; _row = CreateNewRow("Exchange Date", "date", typeof(string), group_index, group_name); _row.Cells["desc"].TypeFlags = iGCellTypeFlags.ComboPreferValue | iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["desc"].FormatString = "{0:D}";// {0:d} for short date string _row.Cells["desc"].DropDownControl = _date; _row.Cells["desc"].Value = null; _row.Cells["desc"].Enabled = iGBool.False; // _row = fGrid.Rows.Add(); _row.Height = 5; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("Current Amount", "curr_amount", typeof(string), group_index, group_name); _row.Cells[1].FormatString = "{0:N0}"; _row.Cells[1].Enabled = iGBool.False; _row = CreateNewRow("Current Exch Rate", "curr_exch_rate", typeof(float), group_index, group_name); _row.Cells[1].Enabled = iGBool.False; // _row = fGrid.Rows.Add(); _row.Height = 5; _row.BackColor = Color.Lavender; _row.Selectable = false; _row = CreateNewRow("Amount Exchanged", "exch_amount", typeof(int), group_index, group_name); _row.Cells[0].ForeColor = Color.Maroon; _row = CreateNewRow("Exchange Rate", "exch_rate", typeof(float), group_index, group_name); _row.Cells[0].ForeColor = Color.Maroon; // _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; _row = CreateNewRow("Ugx Amount", "ug_amount", typeof(float), group_index, group_name); _row.Cells[1].FormatString = "{0:N0}"; _row.Cells[1].ReadOnly = iGBool.True; _row.Cells[1].ForeColor = Color.DarkBlue; // _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("Exchange Gain", "gain", typeof(int), group_index, group_name); _row.Cells[1].FormatString = "{0:N0}"; _row.Cells[1].Enabled = iGBool.False; _row.Cells[0].ForeColor = Color.DarkGreen; _row = CreateNewRow("Exchange Loss", "loss", typeof(int), group_index, group_name); _row.Cells[1].FormatString = "{0:N0}"; _row.Cells[1].Enabled = iGBool.False; _row.Cells[0].ForeColor = Color.Red; // _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; // fGrid.EndUpdate(); }
private void LoadMainGrid() { fGrid.BeginUpdate(); iGRow _row = null; _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; int group_index = 1; string group_name = "New Account Information"; // var _date = new fnn.DropDownCalenderX(); _date.start_date = new DateTime(2015, 1, 1); // _date.start_date = sdata.CURR_DATE; _date.end_date = sdata.CURR_DATE; _date.selected_date = sdata.CURR_DATE; // _row = CreateNewRow("Transfer Date", "transfer_date", typeof(string), group_index, group_name); _row.Cells["desc"].TypeFlags = iGCellTypeFlags.ComboPreferValue | iGCellTypeFlags.NoTextEdit | iGCellTypeFlags.HasEllipsisButton; _row.Cells["desc"].FormatString = "{0:D}";// {0:d} for short date string _row.Cells["desc"].DropDownControl = _date; _row.Cells["desc"].Value = null; // // _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; // _row = CreateNewRow("From Account", "account_from", typeof(string), group_index, group_name); _row.Cells[1].ForeColor = Color.DarkBlue; _row.Cells[0].ForeColor = Color.Maroon; m_SourceAccounts = fnn.CreateCombo(); m_SourceAccounts.MaxVisibleRowCount = 6; _row.Cells[1].DropDownControl = m_SourceAccounts; _row.Cells[1].Value = null; _row.Cells[1].Enabled = iGBool.False; // _row = CreateNewRow("Account Balance", "account_balance", typeof(decimal), group_index, group_name); _row.Cells[1].Enabled = iGBool.False; _row.Cells[0].ForeColor = Color.Gray; _row.Cells[1].FormatString = "{0:N0}"; // _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; _row.Height += 2; // _row = CreateNewRow("To Account", "account_to", typeof(string), group_index, group_name); _row.Cells[1].ForeColor = Color.DarkBlue; _row.Cells[0].ForeColor = Color.Green; m_DestinationAccounts = fnn.CreateCombo(); m_DestinationAccounts.MaxVisibleRowCount = 6; _row.Cells[1].DropDownControl = m_DestinationAccounts; _row.Cells[1].Value = null; _row.Cells[1].Enabled = iGBool.False; // _row = CreateNewRow("Transfered Amount", "transfer_amount", typeof(decimal), group_index, group_name); _row.Cells[1].Enabled = iGBool.False; _row.Cells[1].FormatString = "{0:N0}"; // _row = fGrid.Rows.Add(); _row.Height = 4; _row.BackColor = Color.Lavender; _row.Selectable = false; _row.Height += 2; // _row = CreateNewRow("Transfer \n Reason", "reason", typeof(string), group_index, group_name); _row.Height = 60; _row.Cells["desc"].TextFormatFlags = iGStringFormatFlags.WordWrap; _row.Cells["name"].TextAlign = iGContentAlignment.MiddleRight; // _row = fGrid.Rows.Add(); _row.Height = 3; _row.BackColor = Color.Lavender; _row.Selectable = false; // fGrid.EndUpdate(); }