private void listAccountGroup(int lvl) { try { grdList.Rows.Clear(); AccountGroupDB agdb = new AccountGroupDB(); List <accountgroup> agroup = agdb.getAccountGroupDetails(lvl); int i = 1; foreach (accountgroup cg in agroup) { grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["LineNo"].Value = i; grdList.Rows[grdList.RowCount - 1].Cells["GroupCode"].Value = cg.GroupCode; grdList.Rows[grdList.RowCount - 1].Cells["GroupDescription"].Value = cg.GroupDescription; grdList.Rows[grdList.RowCount - 1].Cells["CreateTime"].Value = cg.CreateTime; grdList.Rows[grdList.RowCount - 1].Cells["Creator"].Value = cg.CreateUser; i++; } } catch (Exception ex) { MessageBox.Show("Error in Account Group Listing"); } try { enableBottomButtons(); pnlList.Visible = true; btnNew.Visible = false; } catch (Exception ex) { } }
public string getGroupCode() { string gc = ""; AccountGroupDB adb = new AccountGroupDB(); List <accountgroup> LCGroup = adb.getAccountGroupDetails(lvl); SortedSet <string> set = new SortedSet <string>(); try { foreach (accountgroup cg in LCGroup) { set.Add(cg.GroupCode); } gc = set.Max; } catch (Exception ex) { } if (Convert.ToInt32(gc) == 0) { gc = "10";// group coe start with 10 } return((Convert.ToInt32(gc) + 1).ToString()); }
private void initVariables() { try { if (getuserPrivilegeStatus() == 1) { //user is only a viewer listOption = 6; } AccountGroupDB.fillAccountGroupValueCombo(cmbGroup1Select, 1); AccountGroupDB.fillAccountGroupValueCombo(cmbGroup2Select, 2); AccountGroupDB.fillAccountGroupValueCombo(cmbGroup3Select, 3); AccountGroupDB.fillAccountGroupValueCombo(cmbGroup4Select, 4); AccountGroupDB.fillAccountGroupValueCombo(cmbGroup5Select, 5); userString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2; setButtonVisibility("init"); } catch (Exception) { } }
private void btnSave_Click(object sender, EventArgs e) { Boolean status = true; try { AccountGroupDB agdb = new AccountGroupDB(); accountgroup ag = new accountgroup(); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btnSave.Text; try { if (!System.Text.RegularExpressions.Regex.IsMatch(txtGroupCode.Text, @"^[0-9]+$")) { MessageBox.Show("Group Code accepts only numeric characters"); return; } else { ag.GroupCode = txtGroupCode.Text; } if (!System.Text.RegularExpressions.Regex.IsMatch(txtGroupDescription.Text, @"^[\sa-zA-Z0-9]+$")) { MessageBox.Show("GroupDescription accepts only alphanumeric characters"); return; } else { ag.GroupDescription = txtGroupDescription.Text; } ag.GroupLevel = Convert.ToInt32(cmbSelectLevel.SelectedItem.ToString().Trim()); } catch (Exception ex) { MessageBox.Show("Validation failed"); return; } if (btnText.Equals("Save")) { if (agdb.validateCustomerGroup(ag)) { if (agdb.insertAccountGroup(ag)) { MessageBox.Show("Account Code Added"); closeAllPanels(); listAccountGroup(lvl); pnlAddNew.Visible = false; pnlBottomButtons.Visible = true; } else { status = false; } } else { MessageBox.Show("Validation failed"); } if (!status) { MessageBox.Show("Failed to Insert Customer Code"); } } else if (btnText.Equals("update")) { if (agdb.validateCustomerGroup(ag)) { if (agdb.updateCustomerGroup(ag)) { MessageBox.Show("Account Code Added"); closeAllPanels(); listAccountGroup(lvl); pnlAddNew.Visible = false; pnlBottomButtons.Visible = true; } else { status = false; } } else { MessageBox.Show("Validation failed"); } if (!status) { MessageBox.Show("Failed to Insert Stock Code"); } } else { MessageBox.Show("btnSave error."); } } catch (Exception ex) { MessageBox.Show("Errorr in saving"); } }