Example #1
0
 private void FillTree()
 {
     try
     {
         Entities.Finance.AccountHeadMaster account = new Entities.Finance.AccountHeadMaster();
         TreeNode tree = new TreeNode();
         tree = account.GetTree(CPublic.GetCompanyID());
         moduleTree.Nodes.Add(tree);
         moduleTree.CollapseAll();
     }
     catch (Exception)
     {
     }
 }
Example #2
0
 protected void moduleTree_SelectedNodeChanged(object sender, EventArgs e)
 {
     try
     {
         if (moduleTree.SelectedNode.ChildNodes.Count > 0)
         {
             Reset();
         }
         else
         {
             Entities.Finance.AccountHeadMaster Account = new Entities.Finance.AccountHeadMaster();
             try
             {
                 dynamic Accounttree = Entities.Finance.AccountHeadMaster.GetGroupData(Convert.ToInt32(moduleTree.SelectedValue));
                 txtAccountHeadName.Text        = Accounttree.Name;
                 txtAddress.Text                = Accounttree.Address;
                 txtAmountSQL.Text              = Accounttree.AmountSQL;
                 txtContactPerson.Text          = Accounttree.ContactPerson;
                 txtDataID.Text                 = Accounttree.SQLID;
                 txtDataName.Text               = Accounttree.SQLName;
                 txtDescription.Text            = Accounttree.Description;
                 txtEmail.Text                  = Accounttree.Email;
                 hdItemId.Value                 = Convert.ToString(Accounttree.ID);
                 txtPhoneNumber.Text            = Accounttree.Phone;
                 txtRefenerenceTable.Text       = Accounttree.SQLTable;
                 txtTransactionSQL.Text         = Accounttree.TransactionSQL;
                 txtOpeningDate.Text            = Convert.ToString(Accounttree.OpeningDate);
                 txtOpeningBalance.Text         = Convert.ToString(Accounttree.OpeningBalance);
                 ddlAccountNature.SelectedValue = Convert.ToString(Accounttree.AccountNature);
                 ddlAccountType.SelectedValue   = Convert.ToString(Accounttree.AccountType);
                 ddlCategory.SelectedValue      = Convert.ToString(Accounttree.Category);
                 ddlIsDebit.SelectedValue       = Convert.ToString(Accounttree.IsDebit);
                 ddlParentGroup.SelectedValue   = Convert.ToString(Accounttree.AccountGroupId);
                 ddlReverseHead.SelectedValue   = Convert.ToString(Accounttree.ReverseHeadId);
                 ddlStatus.SelectedValue        = Convert.ToString(Accounttree.status);
                 txtDataSQL.Text                = Convert.ToString(Accounttree.DataSQL);
                 lblID.Text        = "[" + Convert.ToString(Accounttree.ID) + "]";
                 btnSave.InnerHtml = "Update";
             }
             catch (Exception ex)
             {
             }
         }
     }
     catch (Exception ex)
     {
     }
 }
Example #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                //Gets the voucher type from url and loads it into hiddenfield
                if (Request.QueryString["VOUCHER"] != null)
                {
                    hdnVoucherType.Value = Request.QueryString["VOUCHER"].ToString();
                    if (Request.QueryString["ID"] != null)
                    {
                        hdnGroupID.Value = Request.QueryString["ID"].ToString();
                    }
                }
                //If Only ID is Given in the URL
                else if (Request.QueryString["ID"] != null)
                {
                    hdnGroupID.Value = Request.QueryString["ID"].ToString();
                    DataSet VoucherData = new DataSet();
                    VoucherData          = Entities.Finance.VoucherEntry.GetDataset(Convert.ToInt32(hdnGroupID.Value));
                    hdnVoucherType.Value = VoucherData.Tables[0].Rows[0]["Fve_VoucherType"].ToString();
                }
                else
                {
                    //If null stores is at JNL voucher type //Default
                    hdnVoucherType.Value = "8";
                }
                DataTable dt = new DataTable();
                Entities.Finance.AccountHeadMaster account = new Entities.Finance.AccountHeadMaster();
                //Datatable to load credit head
                dt = account.GetAccountHeadsVoucher(Convert.ToInt32(hdnVoucherType.Value), 1, CPublic.GetCompanyID());
                ddlCreditHead.Items.Add(new ListItem("--select--", "0"));
                if (dt != null)
                {
                    foreach (DataRow item in dt.Rows)
                    {
                        //Creates a new list item
                        ListItem items = new ListItem(item["name"].ToString(), item["parent"].ToString() + "|" + item["ID"].ToString());
                        ddlCreditHead.Items.Add(items);
                    }
                }
                //Datatable to load the debit heads
                dt = account.GetAccountHeadsVoucher(Convert.ToInt32(hdnVoucherType.Value), 0, CPublic.GetCompanyID());
                ddlDebitDummyHead.Items.Add(new ListItem("--select--", "0"));
                ddlDebithead1.Items.Add(new ListItem("--select--", "0"));
                ddlDebithead2.Items.Add(new ListItem("--select--", "0"));
                ddlDebithead3.Items.Add(new ListItem("--select--", "0"));
                ddlDebithead4.Items.Add(new ListItem("--select--", "0"));
                if (dt != null)
                {
                    foreach (DataRow item in dt.Rows)
                    {
                        //Creates a new list item and appends it to the debit dropdownlist and clone dropdownlist
                        ListItem items = new ListItem(item["name"].ToString(), item["parent"].ToString() + "|" + item["ID"].ToString());
                        ddlDebitDummyHead.Items.Add(items);
                        ddlDebithead1.Items.Add(items);
                        ddlDebithead2.Items.Add(items);
                        ddlDebithead3.Items.Add(items);
                        ddlDebithead4.Items.Add(items);
                    }
                }
                Entities.Finance.VoucherEntry voucher = new Entities.Finance.VoucherEntry();
                //Datatable Loads the Job and appends to all JOb drop downlist
                dt = voucher.GetJobs(CPublic.GetCompanyID());
                ddlJobs1.Items.Add(new ListItem("--select--", "0"));
                ddlJobs2.Items.Add(new ListItem("--select--", "0"));
                ddlJobs3.Items.Add(new ListItem("--select--", "0"));
                ddlJobs4.Items.Add(new ListItem("--select--", "0"));
                ddlDebitDummyJob.Items.Add(new ListItem("--select--", "0"));
                ddlCreditJob.Items.Add(new ListItem("--select--", "0"));
                if (dt != null)
                {
                    foreach (DataRow item in dt.Rows)
                    {
                        ListItem items = new ListItem(item["Job_Name"].ToString(), item["Job_Id"].ToString());
                        ddlJobs1.Items.Add(items);
                        ddlJobs2.Items.Add(items);
                        ddlJobs3.Items.Add(items);
                        ddlJobs4.Items.Add(items);
                        ddlDebitDummyJob.Items.Add(items);
                        ddlCreditJob.Items.Add(items);
                    }
                }

                //Datatable to load cost center and appends to the cost center dropdownlist
                dt = voucher.LoadCostCenter();
                ddlDebitDummyCost.Items.Add(new ListItem("--select--", "0"));
                ddlDebitCost1.Items.Add(new ListItem("--select--", "0"));
                ddlDebitCost2.Items.Add(new ListItem("--select--", "0"));
                ddlDebitCost3.Items.Add(new ListItem("--select--", "0"));
                ddlDebitCost4.Items.Add(new ListItem("--select--", "0"));
                ddlCreditCost.Items.Add(new ListItem("--select--", "0"));
                if (dt != null)
                {
                    foreach (DataRow item in dt.Rows)
                    {
                        ListItem items = new ListItem(item["name"].ToString(), item["id"].ToString());
                        ddlDebitDummyCost.Items.Add(items);
                        ddlDebitCost1.Items.Add(items);
                        ddlDebitCost2.Items.Add(items);
                        ddlDebitCost3.Items.Add(items);
                        ddlDebitCost4.Items.Add(items);
                        ddlCreditCost.Items.Add(items);
                    }
                }
                DataSet ds = new DataSet();
                //Gets the Url Parameter and changes title and voucher number according to url parameter
                ds = voucher.GetVoucherNo(Convert.ToInt32(hdnVoucherType.Value));
                VoucherNumber.InnerText  = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString() + ":" + ds.Tables[0].Rows[0]["Number"].ToString();
                lblTitle.InnerText       = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString();
                hdnVoucherTypeName.Value = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString();
                //Loads the voucher types in the changetype dropdown list
                ddlChangeType.LoadVoucherTypes(CPublic.GetCompanyID());
                if (hdnGroupID.Value != "0")
                {
                }
            }
            catch (Exception ex)
            {
            }
        }
Example #4
0
 protected void btnSaveConfirmed_Click(object sender, EventArgs e)
 {
     try
     {
         Entities.Finance.AccountHeadMaster Account = new Entities.Finance.AccountHeadMaster();
         Account.ID             = Convert.ToInt32(hdItemId.Value);
         Account.Name           = txtAccountHeadName.Text;
         Account.status         = Convert.ToInt32(ddlStatus.SelectedValue);
         Account.Description    = txtDescription.Text;
         Account.IsDebit        = Convert.ToInt32(ddlIsDebit.SelectedValue);
         Account.ParentId       = 0;
         Account.CreatedBy      = CPublic.GetuserID();
         Account.Category       = Convert.ToInt32(ddlCategory.SelectedValue);
         Account.DataSQL        = txtDataSQL.Text;
         Account.SQLID          = txtDataID.Text;
         Account.SQLName        = txtDataName.Text;
         Account.SQLTable       = txtRefenerenceTable.Text;
         Account.TransactionSQL = txtTransactionSQL.Text;
         Account.AmountSQL      = txtAmountSQL.Text;
         Account.Phone          = txtPhoneNumber.Text;
         Account.Email          = txtEmail.Text;
         if (txtOpeningBalance.Text == "")
         {
             Account.OpeningBalance = 0;
         }
         else
         {
             Account.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text);
         }
         if (txtOpeningDate.Text == "")
         {
             Account.OpeningDate = DateTime.UtcNow;
         }
         else
         {
             Account.OpeningDate = Convert.ToDateTime(txtOpeningDate.Text);
         }
         Account.CompanyID      = CPublic.GetCompanyID();
         Account.ModifiedBy     = CPublic.GetuserID();
         Account.AccountNature  = Convert.ToInt32(ddlAccountNature.SelectedValue);
         Account.AccountType    = Convert.ToInt32(ddlAccountType.SelectedValue);
         Account.Address        = txtAddress.Text;
         Account.ContactPerson  = txtContactPerson.Text;
         Account.AccountGroupId = Convert.ToInt32(ddlParentGroup.SelectedValue);
         Account.ReverseHeadId  = Convert.ToInt32(ddlReverseHead.SelectedValue);
         OutputMessage Result = null;
         if (Account.ID == 0)
         {
             Result = Account.Save();
             if (Result.Success)
             {
                 Reset();
                 ddlReverseHead.LoadAccountHeads(CPublic.GetCompanyID());
                 ClientScript.RegisterStartupScript(this.GetType(), "message", "successAlert('" + Result.Message + "');window.setTimeout(function(){window.location.href = '/Finance/AccountHeadMaster';}, 3000);", true);
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('" + Result.Message + "')", true);
             }
         }
         else
         {
             Result = Account.Update();
             if (Result.Success)
             {
                 Reset();
                 ClientScript.RegisterStartupScript(this.GetType(), "message", "successAlert('" + Result.Message + "');window.setTimeout(function(){window.location.href = '/Finance/AccountHeadMaster';}, 3000);", true);
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('" + Result.Message + "')", true);
             }
         }
     }
     catch (Exception ex)
     {
     }
 }