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");
}
}
