private void frmSearch_Load(object sender, EventArgs e) { String sItem = ""; // Bind datatable to listview lvwGrid.Items.Clear(); lvwGrid.Columns.Clear(); // Create header columns for (int iCol = 0; iCol < 3; iCol++) { System.Windows.Forms.ColumnHeader ch = new System.Windows.Forms.ColumnHeader(); switch (iCol) { case 0: ch.Text = clsGeneral.fnGetControlCaption(this, "lvwGrid-Field"); break; case 1: ch.Text = clsGeneral.fnGetControlCaption(this, "lvwGrid-Operation"); break; case 2: ch.Text = clsGeneral.fnGetControlCaption(this, "lvwGrid-Value"); break; } lvwGrid.Columns.Add(ch); } Database objDatabase = new Database(); oConnection = (Object)objDatabase.oConnection; // Instantiate BE class MainBE objBE = new MainBE(); // Fill BE class properties objBE.oConnection = oConnection; objBE.sItem = GlobalBE.sOpenedItem; // Instantiate Business class StudioByte.StudioMoney.Main.Business.Main objBusiness = new StudioByte.StudioMoney.Main.Business.Main(); // Fill Business class properties objBusiness.ObjMainBE = objBE; // Fill field combobox uceField.Items.Add(0, clsGeneral.fnGetControlCaption(this, "uceField")); switch (GlobalBE.sOpenedItem) { case "utsMainBank": { sItem = "-Bank"; break; } } foreach (DataRow dr in objBusiness.fnGetFields().Rows) { uceField.Items.Add(dr["W_NOBJECT"].ToString(), clsGeneral.fnGetControlCaption("frmMain", "lbl" + dr["W_SOBJECT"].ToString().Substring(3) + sItem)); } uceField.SelectedIndex = 0; // Fill operation combobox uceOperation.Items.Add(0, clsGeneral.fnGetControlCaption(this, "uceOperation")); uceOperation.Items.Add(1, clsGeneral.fnGetControlCaption(this, "uceOperation.Equals")); uceOperation.Items.Add(2, clsGeneral.fnGetControlCaption(this, "uceOperation.Content")); uceOperation.Items.Add(3, clsGeneral.fnGetControlCaption(this, "uceOperation.Greater")); uceOperation.Items.Add(4, clsGeneral.fnGetControlCaption(this, "uceOperation.Smaller")); uceOperation.Items.Add(5, clsGeneral.fnGetControlCaption(this, "uceOperation.Different")); uceOperation.Items.Add(6, clsGeneral.fnGetControlCaption(this, "uceOperation.Beginning")); uceOperation.Items.Add(7, clsGeneral.fnGetControlCaption(this, "uceOperation.Finishing")); uceOperation.SelectedIndex = 0; lvwGrid.Columns[lvwGrid.Columns.Count - 1].Width = -2; }
private void ubtDelete_Click(object sender, EventArgs e) { try { clsSounds.fnPlay("Click"); usbStatus.Panels[0].Text = clsGeneral.fnGetControlCaption(this, "usbStatus.Deleting"); usbStatus.Refresh(); if (lvwGrid.SelectedItems.Count > 0) { // Play defined sound clsSounds.fnPlay("Attention"); if (MessageBox.Show(clsGeneral.fnGetControlCaption(this, "msgDelete.Confirm"), clsGeneral.fnGetControlCaption(this, "msgDelete.Header"), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Database objDatabase = new Database(); oConnection = (Object)objDatabase.oConnection; // Instantiate BE class BankBE objBE = new BankBE(); // Fill BE class properties objBE.oConnection = oConnection; objBE.nBank = Int32.Parse(lvwGrid.SelectedItems[0].Text); // Instantiate Business class Bank objBusiness = new Bank(); // Fill Business class properties objBusiness.ObjBankBE = objBE; // Fill Grid // Try delete record // If there wasn't an error if (objBusiness.fnDeleteBank() == 0) { // Get selected index on datatable and listview to delete int nSelectedIndex = lvwGrid.SelectedItems[0].Index; int nSelectedRecord = nSelectedIndex + (nRecordsOnPage * (nCurrentPage - 1)); // Get DataTable records DataRowCollection rc = dtGrid.Rows; // Delete record from datatable rc[nSelectedRecord].Delete(); dtGrid.AcceptChanges(); // Remove record from listview lvwGrid.Items.Remove(lvwGrid.SelectedItems[0]); // If there aren't record on listview if (lvwGrid.Items.Count == 0) { // Return to previous page fnPaginateGrid(Navigation.Previous); } else { // Stand on same page fnPaginateGrid(Navigation.Same); } // If there are record on listview if (lvwGrid.Items.Count > 0) { // Select next record on listview lvwGrid.Items[nSelectedIndex - 1].Selected = true; lvwGrid.Select(); lvwGrid.Focus(); lvwGrid_Click(null, null); } else { // Clean all fields on screen ubtNew_Click(null, null); } clsSounds.fnPlay("Deleted"); } } else { lvwGrid.Items[lvwGrid.SelectedItems[0].Index].Selected = true; lvwGrid.Select(); lvwGrid.Focus(); } } else { // Play defined sound clsSounds.fnPlay("Error"); clsGeneral.fnMessageBox(clsGeneral.fnGetControlCaption(this, "msgDelete.NoRecord"), clsGeneral.fnGetControlCaption(this, "msgDelete.Header"), MessageBoxButtons.OK, MessageBoxIcon.Error); } usbStatus.Panels[0].Text = clsGeneral.fnGetControlCaption(this, "usbStatus.Ready"); } catch (Exception ex) { // Play defined sound clsSounds.fnPlay("Error"); // Show exception in a message box clsGeneral.fnException(this, ex); } }
private void ubtSave_Click(object sender, EventArgs e) { try { clsSounds.fnPlay("Click"); usbStatus.Panels[0].Text = clsGeneral.fnGetControlCaption(this, "usbStatus.Saving"); usbStatus.Refresh(); int nSelectedRecord = 0; int nSelectedIndex = 0; // Case edit item if (lvwGrid.SelectedItems.Count > 0) { // Get selected index on datatable and listview to delete nSelectedIndex = lvwGrid.SelectedItems[0].Index; nSelectedRecord = nSelectedIndex + (nRecordsOnPage * (nCurrentPage - 1)); } switch (sOpenedMenuItem) { case "CadastreBank": { frmCadastreBank _frmCadastreBank = (frmCadastreBank)this._form; if (fnValidateEmpty(_frmCadastreBank.txtCode, _frmCadastreBank.txtDescription) == true) { Database objDatabase = new Database(); oConnection = (Object)objDatabase.oConnection; // Instantiate BE class BankBE objBE = new BankBE(); // Fill BE class properties objBE.oConnection = oConnection; objBE.nBank = Int32.Parse(_frmCadastreBank.txtCode.Text); objBE.sBank = _frmCadastreBank.txtDescription.Text; // Instantiate Business class Bank objBusiness = new Bank(); // Fill Business class properties objBusiness.ObjBankBE = objBE; // Fill Grid // Try delete record // If there wasn't an error Int32 nResult = objBusiness.fnSaveBank(); if (nResult > 1) { // Get datatable records switch (nResult) { // Added case 3: { DataRow dr = dtGrid.NewRow(); dr[0] = objBE.nBank; dr[1] = objBE.sBank; // Add record to datatable dtGrid.Rows.Add(dr); // Go to last page fnPaginateGrid(Navigation.Last); // Select last register - added register lvwGrid.Items[lvwGrid.Items.Count - 1].Selected = true; lvwGrid.Select(); clsSounds.fnPlay("Added"); break; } // Updated case 2: { DataRow dr = dtGrid.Rows[nSelectedRecord]; // Update datatable dr[0] = objBE.nBank; dr[1] = objBE.sBank; // Update record on datatable dtGrid.AcceptChanges(); // Update listview lvwGrid.Items[nSelectedIndex].SubItems[1].Text = objBE.sBank; // Select updated record lvwGrid.Items[nSelectedIndex].Selected = true; lvwGrid.Select(); clsSounds.fnPlay("Updated"); break; } // Error default: { // Play defined sound clsSounds.fnPlay("Error"); clsGeneral.fnMessageBox(clsGeneral.fnGetControlCaption(this, "msgSave.Error"), clsGeneral.fnGetControlCaption(this, "msgSave.Header"), MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } } } break; } } usbStatus.Panels[0].Text = clsGeneral.fnGetControlCaption(this, "usbStatus.Ready"); } catch (Exception ex) { // Play defined sound clsSounds.fnPlay("Error"); // Show exception in a message box clsGeneral.fnException(this, ex); } }
public void fnGridPopulate(params object[] args) { try { String sCaption = ""; String sParameters = ""; for (int i = 1; i < args.GetLength(0) + 1; i++) { if (i == 1) { sCaption = (String)args[i - 1]; } else { sParameters += (String)args[i - 1]; } } switch (sCaption.Substring(3, sCaption.Length - 3)) { case "CadastreBank": Database objDatabase = new Database(); oConnection = (Object)objDatabase.oConnection; // Instantiate BE class BankBE objBE = new BankBE(); // Fill BE class properties objBE.oConnection = oConnection; if (sParameters != "") { objBE.sSearchCommand = sParameters; } // Instantiate Business class Bank objBusiness = new Bank(); // Fill Business class properties objBusiness.ObjBankBE = objBE; // Fill Grid // Create datatable with same structure of returned datatable by fill grid function if (sParameters == "") { dtGrid = objBusiness.fnGetBank(); } else { dtGrid = objBusiness.fnSearchBank(); } fnPaginateGrid(Navigation.First); break; } } catch (Exception ex) { // Play defined sound clsSounds.fnPlay("Error"); // Show exception in a message box clsGeneral.fnException(this, ex); } }