void GetGroupDetails() { if (Level == 5) { } else if (Level == 4) { LabelErrorMessage.Text = "Can not create more groups, must select account"; return; } else if (Level == 3) { string P = ""; char pad = '0'; Int16 ii = Convert.ToInt16(Level4); ii += 1; P = ii.ToString(); P = P.PadLeft(Level4.Length, pad); COAChartCode = Level1 + Level2 + Level3 + P + Level5; Level = 4; } else if (Level == 2) { string P = ""; char pad = '0'; Int16 ii = Convert.ToInt16(Level3); ii += 1; P = ii.ToString(); P = P.PadLeft(Level3.Length, pad); COAChartCode = Level1 + Level2 + P + Level4 + Level5; Level = 3; } else if (Level == 1) { string P = ""; char pad = '0'; Int16 ii = Convert.ToInt16(Level2); ii += 1; P = ii.ToString(); P = P.PadLeft(Level2.Length, pad); COAChartCode = Level1 + P + Level3 + Level4 + Level5; Level = 2; } TxtNewAccountNo.Text = COAChartCode.ToString(); ChartCat = "T" + Level1.ToString(); }
protected void BtnAddGroup_Click(object sender, EventArgs e) { if (_Typelist.SelectedValue == "0") { LastLevel = "N"; } else { LastLevel = "W"; } Class1 queryResult = new Class1(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_ChartOfAccount_Save"; accountantCls.Cmd.Parameters.Add("@ChartId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyId"]; accountantCls.Cmd.Parameters.Add("@COAChartName", SqlDbType.NVarChar).Value = _LedgerNameText.Text; accountantCls.Cmd.Parameters.Add("@ParentChartID", SqlDbType.NVarChar).Value = ParentChartID.ToString(); accountantCls.Cmd.Parameters.Add("@ChartLevel", SqlDbType.NVarChar).Value = Level; accountantCls.Cmd.Parameters.Add("@COAChartCode", SqlDbType.NVarChar).Value = COAChartCode.ToString(); accountantCls.Cmd.Parameters.Add("@ChartCat", SqlDbType.NVarChar).Value = "T1"; accountantCls.Cmd.Parameters.Add("@LastLevel", SqlDbType.NVarChar).Value = LastLevel; accountantCls.Cmd.Parameters.Add("@AccountType", SqlDbType.NVarChar).Value = _Typelist.SelectedValue; if (ChartId == 0) { accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); } else { accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); } queryResult.ErrorNo = 0; accountantCls.beginTrans(); queryResult.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteNonQuery()); accountantCls.commitTrans(); if (queryResult.RecordId == 0) { queryResult.ErrorNo = -1; queryResult.ErrorDesc = Resources.ResourceMain.ChartAlreadyExists; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } else if (queryResult.RecordId == -1) { queryResult.ErrorNo = -1; queryResult.ErrorDesc = Resources.ResourceMain.EndOfLevel; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } //accountantCls.Cmd.CommandType = CommandType.Text; //accountantCls.Cmd.CommandText = "select COAChartCode From tChartOfAccounts where ChartId = " + queryResult.RecordId; //queryResult.OtherData = accountantCls.Cmd.ExecuteScalar(); LabelErrorMessage.Text = "Saved Successfully"; Clear(); } catch (Exception ex) { accountantCls.rollBackTrans(); queryResult.ErrorDesc = ex.Message; queryResult.ErrorNo = -1; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } }