Exemple #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Load_DefaultDepartment();
                //hplPrintVouchar.Visible = false;
                //tr_TotalRow.Visible = false;
                ltrTitle.Text = singularTitle;
                //hplHeaderBack.Text = "Back to " + prularTitle;
                //lbtnAddVouchar.Text = doWhat + singularTitle;

                if (moduleId != 1)
                {
                    //hplHeaderBack.NavigateUrl = "~/FinApp/Transactions.aspx?mod=" + moduleId.ToString();
                }


                if (Request.QueryString["gid"] != null)
                {
                    //pnlActions.Visible = false;
                    if (Request.QueryString["update"] != null)
                    {
                        if (Request.QueryString["update"] == "1")
                        {
                            //pnlActions.Visible = true;
                        }
                    }
                }
                else
                {
                    //tr_lbtnDelete.Visible = false;
                }


                try
                {
                    tr_cfield1.Visible     = false;
                    tr_cfield2.Visible     = false;
                    tr_cfield3.Visible     = false;
                    tr_cfield4.Visible     = false;
                    tr_branchField.Visible = false;

                    iBiz.FinPro.Modules.fin_Modules bAppModule = new iBiz.FinPro.Modules.fin_Modules();
                    iBiz.FinPro.Modules.fin_Modules.objfin_Modules objModule = new iBiz.FinPro.Modules.fin_Modules.objfin_Modules();

                    objModule = bAppModule.Select(moduleId);

                    if (objModule != null)
                    {
                        if (!string.IsNullOrEmpty(objModule.CField1))
                        {
                            ltrCField1Title.Text = objModule.CField1;
                            tr_cfield1.Visible   = true;
                        }

                        if (!string.IsNullOrEmpty(objModule.CField2))
                        {
                            ltrCField2Title.Text = objModule.CField2;
                            tr_cfield2.Visible   = true;
                        }

                        if (!string.IsNullOrEmpty(objModule.CField3))
                        {
                            ltrCField3Title.Text = objModule.CField3;
                            tr_cfield3.Visible   = true;
                        }

                        if (!string.IsNullOrEmpty(objModule.CField4))
                        {
                            ltrCField4Title.Text = objModule.CField4;
                            tr_cfield4.Visible   = true;
                        }

                        if (moduleId == 4)
                        {
                            Load_Branches();
                            tr_branchField.Visible = true;
                        }
                    }
                }
                catch (Exception)
                {
                    throw;
                }


                Load_Items(false, false);
            }
        }
Exemple #2
0
        protected void Load_Items(bool addMore, bool doReset)
        {
            int moduleParameterId = 0;

            if (!string.IsNullOrEmpty(ddlBranch.SelectedValue))
            {
                moduleParameterId = Convert.ToInt32(ddlBranch.SelectedValue);
            }

            if (doReset)
            {
                rptVoucherItems.DataSourceID = null;
                rptVoucherItems.DataBind();
            }



            if (Request.QueryString["gid"] != null && addMore == false)
            {
                int groupId = Convert.ToInt32(Request.QueryString["gid"]);
                iBiz.FinPro.Transactions.Transact        bTrans    = new iBiz.FinPro.Transactions.Transact();
                iBiz.FinPro.Transactions.Groups          bTransG   = new iBiz.FinPro.Transactions.Groups();
                iBiz.FinPro.Transactions.Groups.objGroup objTransG = new iBiz.FinPro.Transactions.Groups.objGroup();
                objTransG = bTransG.Select(groupId);

                if (objTransG != null)
                {
                    //if (objTransG.transGroupIsOfficial != isOfficial)
                    //{
                    //    Response.Redirect("~/", false);
                    //}

                    //tbDescription.Text = objTransG.transGroupTitle;
                    //radVoucharDate.SelectedDate = objTransG.transGroupCreatedOn;
                    //tbRefId.Text = objTransG.transGroupRefId;
                    //tbCustomValue1.Text = objTransG.transCField1;
                    //tbCustomValue2.Text = objTransG.transCField2;
                    //tbCustomValue3.Text = objTransG.transCField3;
                    //tbCustomValue4.Text = objTransG.transCField4;

                    rptVoucherItems.DataSource = bTrans.Select_Grp(groupId, Convert.ToBoolean(isOfficial));
                    rptVoucherItems.DataBind();

                    //hplPrintVouchar.Visible = true;
                    //hplPrintVouchar.NavigateUrl = hplPrintVouchar.NavigateUrl + "?id=" + objTransG.transGroupID.ToString();

                    //tr_lbtnUpdate.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;
                    //tr_lbtnDelete.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;
                    //lbtnAddRow.Visible = objTransG.transGroupApprovedBy.HasValue ? false : true;

                    //tr_TotalRow.Visible = true;

                    //ltrTotalCredit.Text = Comma_Amount(objTransG.Get_Total_Credit());
                    //ltrTotalDebit.Text = Comma_Amount(objTransG.Get_Total_Debit());
                }
            }


            DataTable dt = new DataTable();

            dt.Columns.Add("additionalTransId");
            dt.Columns.Add("itemNo");
            dt.Columns.Add("chkShowOff");
            dt.Columns.Add("transID");
            dt.Columns.Add("drAccountId");
            dt.Columns.Add("crAccountId");
            dt.Columns.Add("deptId");
            dt.Columns.Add("description");
            dt.Columns.Add("amount");

            int iNo = 0;

            foreach (RepeaterItem item in rptVoucherItems.Items)
            {
                foreach (Control ctrlItem in item.Controls)
                {
                    if (ctrlItem is HiddenField)
                    {
                        if (ctrlItem.ClientID.ToLower().Contains("hfitemno"))
                        {
                            iNo++;
                            string      itemNo, showOff, transId, drAccountId, crAccountId, deptId, description, amount;
                            HiddenField hfINo             = (HiddenField)ctrlItem;
                            RadComboBox ddlDebitAccounts  = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDebitAccounts"));
                            RadComboBox ddlCreditAccounts = (RadComboBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlCreditAccount"));

                            DropDownList ddlDepts      = (DropDownList)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "ddlDept"));
                            TextBox      tbDescription = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbDescription"));
                            TextBox      tbAmount      = (TextBox)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "tbAmount"));
                            HiddenField  hfTransId     = (HiddenField)Form.FindControl(hfINo.UniqueID.Replace("hfItemNo", "hfTransID"));

                            itemNo = hfINo.Value;
                            //showOff = Convert.ToInt32(chkShowOff.Checked).ToString();
                            showOff = "1";
                            transId = hfTransId.Value;
                            //accountId = ddlAccounts.SelectedValue;
                            drAccountId = ddlDebitAccounts.SelectedValue;
                            crAccountId = ddlCreditAccounts.SelectedValue;
                            deptId      = ddlDepts.SelectedValue;
                            description = tbDescription.Text;
                            amount      = tbAmount.Text.Length > 0 ? tbAmount.Text.Replace(",", "") : "";
                            dt.Rows.Add(null, itemNo, showOff, transId, drAccountId, crAccountId, deptId, description, Comma_Amount(amount));
                        }
                    }
                }
            }

            //get Preset Accounts

            iBiz.FinPro.Modules.fin_Modules bModules = new iBiz.FinPro.Modules.fin_Modules();

            IDataReader idr;

            if (isOfficial == 0)
            {
                idr = bModules.Get_Preselected_Items(moduleId, moduleParameterId, false);
            }
            else
            {
                idr = bModules.Get_Preselected_Items(moduleId, moduleParameterId, true);
            }


            if (idr != null && !addMore && string.IsNullOrEmpty(Request.QueryString["gid"]))
            {
                while (idr.Read())
                {
                    int additionalTransId = Convert.ToInt32(idr["additionalTransId"]);
                    int selectedAccountId = Convert.ToInt32(idr["autoTransAccountId"]);

                    string transDescription = idr["autoTransNarration"].ToString();
                    dt.Rows.Add(additionalTransId, iNo + 1, 1, 0, selectedAccountId, 0, transDescription, "", "");
                }
            }


            if (addMore || rptVoucherItems.Items.Count == 0)
            {
                dt.Rows.Add(null, iNo + 1, 1, 0, 0, 0, "", "", "");
                dt.Rows.Add(null, iNo + 2, 1, 0, 0, 0, "", "", "");

                hfTotalItems.Value = Convert.ToString(iNo + 2);
            }
            else
            {
                hfTotalItems.Value = Convert.ToString(iNo);
            }


            rptVoucherItems.DataSource = dt;
            rptVoucherItems.DataBind();
        }