WEB_CORE/Swift.web/include/AddGL.aspx.cs

using Swift.DAL.ExchangeSystem.LedgerSetup;
using Swift.web.Library;
using System;

namespace Swift.web.include
{
    public partial class AddGL : System.Web.UI.Page
    {
        private LedgerDao _obj = new LedgerDao();
        private readonly SwiftLibrary _sl = new SwiftLibrary();

        protected void Page_Load(object sender, EventArgs e)
        {
            _sl.CheckSession();
            if (!IsPostBack)
            {
                breadCrumb.InnerHtml = "Add Ledger Group";
                frmTitle.InnerHtml = "Add Ledger Group";
                btnUpdate.Visible = false;
                GLCode.Text = GetParentId();
                GetMapName();
                if (!string.IsNullOrEmpty(GetRowId()))
                {
                    breadCrumb.InnerHtml = "Edit Ledger Sub Group";
                    frmTitle.InnerHtml = "Edit Ledger Sub Group";
                    PopulateData();
                }
            }
        }

        private void PopulateData()
        {
            var dr = _obj.GetGLData(GetRowId());
            if (dr == null)
                return;
            GLCode.Text = GetRowId();
            GLMap.SelectedValue = dr["p_id"].ToString();
            GLMap.Enabled = false;
            description.Text = dr["gl_desec"].ToString();
            accountPrifix.Text = dr["acc_Prefix"].ToString();
            ConditionDDl.SelectedValue = "";
            addNewGL.Visible = false;
            btnUpdate.Visible = true;
        }

        protected void addNewGL_Click(object sender, EventArgs e)
        {
            string code = GLCode.Text;
            string desc = description.Text;
            if (desc == "")
            {
                GetStatic.AlertMessage(this, "* fields are required !");
                return;
            }
            string map = GLMap.Text;
            string id = GetRowId();
            string user = GetStatic.GetUser();
            string accPrifix = accountPrifix.Text;
            var dbResult = _obj.InsertLedger(id, user, map, desc, code, accPrifix);
            if (dbResult.ErrorCode == "0")
            {
                GetStatic.AlertMessage(this, dbResult.Msg);
                return;
            }
            else
            {
                GetStatic.AlertMessage(this, dbResult.Msg);
                return;
            }
        }

        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            string desc = description.Text;
            if (desc == "")
            {
                GetStatic.AlertMessage(this, "* fields are required !");
                return;
            }
            string id = GetRowId();
            var dbResult = _obj.UpdateLedger(id, desc, accountPrifix.Text);
            GetStatic.AlertMessage(this, dbResult.Msg);
        }

        private string GetRowId()
        {
            return GetStatic.ReadQueryString("Rowid", "");
        }

        private string GetParentId()
        {
            return GetStatic.ReadQueryString("ParentID", "");
        }

        private string GetId()
        {
            return GetStatic.ReadQueryString("id", "");
        }

        private void GetMapName()
        {
            if (!GetParentId().Contains("r"))
            {
                //string a = "";
                //int length = 1;
                //for (int i = 0; i < length; i++)
                //{
                //    if (i == 0)
                //        a = _sl.GetSingleResult("select P_id from gl_group WITH(NOLOCK)  where gl_code = '" + GetParentId() + "'");
                //    else
                //        a = _sl.GetSingleResult("select P_id from gl_group WITH(NOLOCK)  where gl_code = '" + a + "'");

                //    if (!a.Contains("r"))
                //        length++;
                //}
                _sl.SetDDL(ref GLMap, "select gl_name lable,gl_code reportid from gl_group WITH(NOLOCK)  where gl_code ='" + GetParentId() + "'", "reportId", "lable", "", "");
            }
            else
                _sl.SetDDL(ref GLMap, "SELECT lable,reportid FROM report_format WITH(NOLOCK) WHERE reportid=REPLACE('" + GetParentId() + "','r','')", "reportId", "lable", "", "");
        }
    }
}