Ejemplo n.º 1
0
        public IQueryable <Division> FindBy(System.Linq.Expressions.Expression <Func <Division, bool> > predicate)
        {
            DivisionDAL           dalObject = new DivisionDAL();
            IQueryable <Division> results   = dalObject.FindBy(predicate);

            return(results);
        }
Ejemplo n.º 2
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     if (!string.IsNullOrEmpty(hdDivisionID.Value))
     {
         DivisionDAL oDivisionDAL = new DivisionDAL();
         Result      oResult      = (Result)oDivisionDAL.Detete(hdDivisionID.Value);
         if (oResult.Status)
         {
             this.LoadList();
             ClearTextValue();
             hdDivisionID.Value = "";
             ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
         }
         else
         {
             if (oResult.Message.Equals(Constants.TABLE_MAIN))
             {
                 ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
             }
             else
             {
                 ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
             }
         }
     }
     else
     {
         ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
     }
 }
Ejemplo n.º 3
0
        public IQueryable <Division> GetAll()
        {
            DivisionDAL           dalObject = new DivisionDAL();
            IQueryable <Division> results   = dalObject.GetAll();

            return(results);
        }
Ejemplo n.º 4
0
    public void LoadList()
    {
        Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];

        if (oConfig != null)
        {
            Division    oDivision    = new Division();
            DivisionDAL oDivisionDAL = new DivisionDAL();
            Result      oResult      = oDivisionDAL.LoadUnapprovedList(oConfig.UserName, false);

            if (oResult.Status)
            {
                DataTable dtTmpDivisionList = (DataTable)oResult.Return;
                if (dtTmpDivisionList.Rows.Count > 0)
                {
                    dtTmpDivisionList.Columns.Remove("MakerID");

                    gvDivisionList.DataSource = dtTmpDivisionList;
                    gvDivisionList.DataBind();

                    Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpDivisionList;
                }
                else
                {
                    gvDivisionList.DataSource = null;
                    gvDivisionList.DataBind();
                }
            }
            else
            {
                ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
            }
        }
    }
Ejemplo n.º 5
0
        public DivisionDTO GetDivision(DivisionDTO division)
        {
            var divisions = DivisionDAL.GetDivision(Map <Division>(division));

            if (divisions == null)
            {
                return(null);
            }

            return(Map <DivisionDTO>(divisions));
        }
Ejemplo n.º 6
0
        public List <DivisionDTO> GetDivisions()
        {
            var divisions = DivisionDAL.GetDivisions();

            if (divisions == null)
            {
                return(null);
            }

            return(Map <List <DivisionDTO> >(divisions));
        }
Ejemplo n.º 7
0
    private void LoadDataByID(string sDivisionID)
    {
        Division    oDivision    = new Division(sDivisionID);
        DivisionDAL oDivisionDAL = new DivisionDAL();
        Result      oResult      = new Result();

        oResult = oDivisionDAL.LoadByID(oDivision);
        if (oResult.Status)
        {
            oDivision = (Division)oResult.Return;

            txtDivisionID.Text     = oDivision.DivisionID.Trim();
            txtDivisionID.ReadOnly = true;
            txtDivisionName.Text   = oDivision.DivisionName;
            txtBdBankCode.Text     = oDivision.BBCode;
            txtAddress.Text        = oDivision.Address;
            txtZipCode.Text        = oDivision.ZipCode;
            txtPhoneNumber.Text    = oDivision.Phone;
            txtEmailID.Text        = oDivision.Email;
            txtFaxNumber.Text      = oDivision.Fax;
            txtSWIFTBIC.Text       = oDivision.SWIFTBIC;
            if (string.IsNullOrEmpty(hdDataType.Value))
            {
                //When Loading from Approver End
                UserDetails userDetails = ucUserDet.UserDetail;
                userDetails.MakerID  = oDivision.UserDetails.MakerID;
                userDetails.MakeDate = oDivision.UserDetails.MakeDate;
                ucUserDet.UserDetail = userDetails;
            }
            else if (hdDataType.Value.Equals("T"))
            {
                //When loading from temp table
                UserDetails userDetails = ucUserDet.UserDetail;
                userDetails.CheckDate      = oDivision.UserDetails.CheckDate;
                userDetails.CheckerID      = oDivision.UserDetails.CheckerID;
                userDetails.CheckDate      = oDivision.UserDetails.CheckDate;
                userDetails.CheckerComment = oDivision.UserDetails.CheckerComment;
                ucUserDet.UserDetail       = userDetails;
            }

            DDListUtil.Assign(ddlBranchCode, oDivision.Branch.BranchID);
            DDListUtil.Assign(ddlToMonth, oDivision.FiscalToMonth.ToString());
            DDListUtil.Assign(ddlFromMonth, oDivision.FiscalFormMonth.ToString());
            DDListUtil.Assign(ddlCountryName, oDivision.Country.ToString());

            hdDivisionID.Value = sDivisionID;
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
        }
    }
Ejemplo n.º 8
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        Division    oDivision    = new Division();
        DivisionDAL oDivisionDAL = new DivisionDAL();

        oDivision.DivisionID = Request[txtDivisionID.UniqueID].Trim().ToUpper();
        txtDivisionID.Text   = Request[txtDivisionID.UniqueID].Trim().ToUpper();
        if (!string.IsNullOrEmpty(ddlBranchCode.SelectedItem.Value))
        {
            oDivision.Branch.BranchID = ddlBranchCode.SelectedItem.Value;
        }
        oDivision.DivisionName = txtDivisionName.Text;
        oDivision.BBCode       = txtBdBankCode.Text;
        oDivision.Address      = txtAddress.Text;
        oDivision.ZipCode      = txtZipCode.Text;
        oDivision.Phone        = txtPhoneNumber.Text;
        if (!string.IsNullOrEmpty(ddlCountryName.SelectedItem.Value))
        {
            oDivision.Country = ddlCountryName.SelectedItem.Value;
        }
        oDivision.Email    = txtEmailID.Text;
        oDivision.Fax      = txtFaxNumber.Text;
        oDivision.SWIFTBIC = txtSWIFTBIC.Text;
        if (!string.IsNullOrEmpty(ddlFromMonth.SelectedItem.Value))
        {
            oDivision.FiscalFormMonth = Convert.ToInt16(ddlFromMonth.SelectedItem.Value);
        }
        if (!string.IsNullOrEmpty(ddlToMonth.SelectedItem.Value))
        {
            oDivision.FiscalToMonth = Convert.ToInt16(ddlToMonth.SelectedItem.Value);
        }

        oDivision.UserDetails          = ucUserDet.UserDetail;
        oDivision.UserDetails.MakeDate = DateTime.Now;
        ucUserDet.ResetData();

        Result oResult = (Result)oDivisionDAL.Save(oDivision);

        if (oResult.Status)
        {
            this.LoadList();
            ClearTextValue();
            hdDivisionID.Value = "";

            ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
        }
    }
Ejemplo n.º 9
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            CustomerType oCustomerType = new CustomerType();
            Result       oResult       = new Result();

            if (Type.Equals("BankSearch"))
            {
                BankDAL oBDAL = new BankDAL();
                oResult = oBDAL.AppSearchList(txtID.Text, txtName.Text);
            }
            else if (Type.Equals("DivisionSearch"))
            {
                DivisionDAL oDivisionDAL = new DivisionDAL();
                oResult = oDivisionDAL.AppSearchList(txtID.Text, txtName.Text);
            }
            else if (Type.Equals("CurrencySearch"))
            {
                CurrencyDAL oCurrencyDAL = new CurrencyDAL();
                oResult = oCurrencyDAL.AppSearchList(txtID.Text, txtName.Text);
            }
            else if (Type.Equals("BranchSearch"))
            {
                BranchDAL oBranchDAL = new BranchDAL();
                oResult = oBranchDAL.AppSearchList(txtID.Text, txtName.Text);
            }

            ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true);
            if (oResult.Status)
            {
                DataTable dtTmpCustomerTypeList = (DataTable)oResult.Return;
                if (dtTmpCustomerTypeList.Rows.Count > 0)
                {
                    gvSearchList.DataSource = dtTmpCustomerTypeList;
                    gvSearchList.DataBind();
                }
                else
                {
                    gvSearchList.DataSource = null;
                    gvSearchList.DataBind();
                }
                Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpCustomerTypeList;
            }

            ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true);
        }
Ejemplo n.º 10
0
    protected void btnApprove_Click(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(hdDivisionID.Value))
        {
            Division    oDivision    = new Division(hdDivisionID.Value);
            DivisionDAL oDivisionDAL = new DivisionDAL();
            oDivision.UserDetails = ucUserDet.UserDetail;

            Result oResult = (Result)oDivisionDAL.Approve(oDivision);
            if (oResult.Status)
            {
                ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
            }
            else
            {
                ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
            }
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
        }
    }
Ejemplo n.º 11
0
        public void Add(Division entity)
        {
            DivisionDAL dalObject = new DivisionDAL();

            dalObject.Add(entity);
        }
Ejemplo n.º 12
0
    public void SearchAction()
    {
        string sType = Request.QueryString["pType"];

        gvData.DataSource = null;
        gvData.DataBind();

        if (!string.IsNullOrEmpty(sType))
        {
            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();

            if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BRANCH).PadLeft(5, '0')))
            {
                #region BRANCH
                lgText.InnerHtml = "Branch Approval Queue List";
                BranchDAL       oBranchDAL = new BranchDAL();
                TemplateBuilder tbGvData   = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Branch' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBranchDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Branch ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Branch Name";
                            this.gvData.HeaderRow.Cells[3].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion BRANCH
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BD_BANKADDRESS).PadLeft(5, '0')))
            {
                #region Bangladesh Bank Address
                lgText.InnerHtml = "Bangladesh Bank Address Approval Queue List";

                BBAddressDAL    oBBAddressDAL = new BBAddressDAL();
                TemplateBuilder tbGvData      = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Bangladesh Bank Address' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBBAddressDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet Address";
                            this.gvData.HeaderRow.Cells[3].Text = "Commission Claim Address";
                            this.gvData.HeaderRow.Cells[4].Text = "Interest Claim Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim Address";
                            this.gvData.HeaderRow.Cells[6].Text = "Reinvestment Address";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion Bangladesh Bank Address
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY).PadLeft(5, '0')))
            {
                #region Currency
                lgText.InnerHtml = "Currency Approval Queue List";
                CurrencyDAL     oCurrencyDAL = new CurrencyDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Currency' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCurrencyDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Currency Symbol";
                            this.gvData.HeaderRow.Cells[4].Text = "Currency Description";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Currency
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY_WISE_ACCOUNT_MAPPING).PadLeft(5, '0')))
            {
                #region Currency Wise Account Mapping
                lgText.InnerHtml = "Currency Wise Account Mapping Approval Queue List";
                CurrencyWiseAccountMappingDAL oCurrencyWiseAccountMappingDAL = new CurrencyWiseAccountMappingDAL();
                TemplateBuilder tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Currency Wise Account Mapping ' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCurrencyWiseAccountMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            // for adding seperator....
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(3);
                            alAddSeperatorIndex.Add(4);
                            alAddSeperatorIndex.Add(5);
                            alAddSeperatorIndex.Add(6);
                            alAddSeperatorIndex.Add(7);

                            dtTmpList.Columns.Remove("SuspenseAccName");
                            dtTmpList.Columns.Remove("ForeignExchangeAccName");
                            dtTmpList.Columns.Remove("BranchFxAccName");
                            dtTmpList.Columns.Remove("BranchExFxAccName");
                            dtTmpList.Columns.Remove("BangladesgBankAccName");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Suspense Acc";
                            this.gvData.HeaderRow.Cells[4].Text = "Foreign Exchange Acc";
                            this.gvData.HeaderRow.Cells[5].Text = "Branch Fx Acc";
                            this.gvData.HeaderRow.Cells[6].Text = "Branch Ex Fx Acc";
                            this.gvData.HeaderRow.Cells[7].Text = "Bangladesg Bank Acc";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion Currency Wise Account Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_DETAIL).PadLeft(5, '0')))
            {
                #region Customer Detail
                lgText.InnerHtml = "Customer Detail Approval Queue List";
                CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL();
                TemplateBuilder    tbGvData            = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Detail' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerDetailsDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Name";
                            this.gvData.HeaderRow.Cells[3].Text = "Date of Birth";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Phone";
                            this.gvData.HeaderRow.Cells[6].Text = "Email";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Detail
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE).PadLeft(5, '0')))
            {
                #region Customer Type
                lgText.InnerHtml = "Customer Type Approval Queue List";
                CustomerTypeDAL oCustomerTypeDAL = new CustomerTypeDAL();
                TemplateBuilder tbGvData         = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Type' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerTypeDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Type Description";
                            this.gvData.HeaderRow.Cells[3].Text = "Max Members";
                            this.gvData.HeaderRow.Cells[4].Text = "Is Organization";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Type
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE_WISE_SP_LIMIT).PadLeft(5, '0')))
            {
                #region Customer Type wise SP Type Maping
                lgText.InnerHtml = "Customer Type wise SP Type Maping Approval Queue List";

                CustomerTypeWiseSPLimitDAL oCustomerTypeWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
                TemplateBuilder            tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Type wise Sp Type Maping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerTypeWiseSPLimitDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Type";
                            this.gvData.HeaderRow.Cells[3].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[4].Text = "Minimum Limit";
                            this.gvData.HeaderRow.Cells[5].Text = "Maximum Limit";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Type wise SP Type Maping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.DIVISION).PadLeft(5, '0')))
            {
                #region Area Approval
                lgText.InnerHtml = "Area Approval Queue List";
                DivisionDAL     oDivisionDAL = new DivisionDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Area' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oDivisionDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("BranchID");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Area ID";
                            this.gvData.HeaderRow.Cells[2].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Area Name";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Area Approval
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_CERTIFICATE).PadLeft(5, '0')))
            {
                #region Script Mapping Certificate
                lgText.InnerHtml = "Script Mapping Certificate Approval Queue List";
                ScripMappingDAL oScripMappingDAL = new ScripMappingDAL();
                TemplateBuilder tbGvData         = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Script Mapping Certificate' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oScripMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList = DDListUtil.MapTableWithXML(dtTmpList, "ScriptFormatMapping", "ReportType", "SP", 2);

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Denomination";
                            this.gvData.HeaderRow.Cells[3].Text = "Script Format";
                            this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker Date";
                        }
                    }
                }
                #endregion Script Mapping Certificate
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_POLICY).PadLeft(5, '0')))
            {
                #region SP Policy
                lgText.InnerHtml = "SP Policy Approval Queue List";
                SPPolicyDAL     oSPPolicyDAL = new SPPolicyDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'SP Policy' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPPolicyDAL.LoadUnapprovedList(null, true);
                if (oResult != null)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("CheckerID");
                            dtTmpList.Columns.Remove("CheckDate");
                            dtTmpList.Columns.Remove("CheckerComment");
                            dtTmpList.Columns.Remove("PolicyEffectDate");
                            dtTmpList.Columns.Remove("IsSPDurationInMonth");
                            dtTmpList.Columns.Remove("SPInterestType");
                            dtTmpList.Columns.Remove("InterestTypeAfterIntPayment");
                            dtTmpList.Columns.Remove("PreMaturityInterestType");
                            dtTmpList.Columns.Remove("PreMatIntTypeAfterIntPayment");
                            dtTmpList.Columns.Remove("IsNomineePerScripRequired");
                            dtTmpList.Columns.Remove("IsBondHolderRequired");
                            dtTmpList.Columns.Remove("IsFoeignAddressRequired");
                            dtTmpList.Columns.Remove("SupportedSex");
                            dtTmpList.Columns.Remove("PartiallyEncashable");
                            dtTmpList.Columns.Remove("ReinvestmentSuported");
                            dtTmpList.Columns.Remove("InterestReinvestable");
                            dtTmpList.Columns.Remove("PartiallyEncashedReinvestable");
                            dtTmpList.Columns.Remove("MaxNoOfReinvestment");
                            dtTmpList.Columns.Remove("NonOrgCommission");
                            dtTmpList.Columns.Remove("NonOrgCommissionType");
                            dtTmpList.Columns.Remove("OrgCommission");
                            dtTmpList.Columns.Remove("OrgCommissionType");
                            dtTmpList.Columns.Remove("Levi");
                            dtTmpList.Columns.Remove("LeviType");
                            dtTmpList.Columns.Remove("IncomeTax");
                            dtTmpList.Columns.Remove("IncomeTaxType");
                            dtTmpList.Columns.Remove("IncomeTaxApplyAmount");
                            dtTmpList.Columns.Remove("IncomeTaxYearlyYN");
                            dtTmpList.Columns.Remove("IsOrganizationLeviTax");
                            dtTmpList.Columns.Remove("InterestRemuneration");
                            dtTmpList.Columns.Remove("InterestRemunerationType");
                            dtTmpList.Columns.Remove("Remuneration");
                            dtTmpList.Columns.Remove("RemunerationType");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Policy ID";
                            this.gvData.HeaderRow.Cells[2].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[3].Text = "SP Duration";
                            this.gvData.HeaderRow.Cells[4].Text = "No Of Coupons";
                            this.gvData.HeaderRow.Cells[5].Text = "Minimum Age";
                            this.gvData.HeaderRow.Cells[6].Text = "Maximum Age";
                            this.gvData.HeaderRow.Cells[7].Text = "Is Approved";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion SP Policy
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_REPORT).PadLeft(5, '0')))
            {
                #region Report Mapping
                lgText.InnerHtml = "Report Mapping Approval Queue List";
                SPReportMappingDAL oSPReportMappingDAL = new SPReportMappingDAL();
                TemplateBuilder    tbGvData            = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Report Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPReportMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            DataTable dtMappedData = null;

                            dtMappedData = DDListUtil.MapTableWithXML(dtTmpList, "ReportFormatMapping", "ReportType", "SS", 1);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "CC", 2);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "IC", 3);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "EC", 4);

                            gvData.DataSource = dtMappedData;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtMappedData;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet";
                            this.gvData.HeaderRow.Cells[3].Text = "Commission Claim";
                            this.gvData.HeaderRow.Cells[4].Text = "Interest Claim ";
                            this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker Date";
                        }
                    }
                }
                #endregion Report Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_TYPE).PadLeft(5, '0')))
            {
                #region Sanchaya Patra Type
                lgText.InnerHtml = "Sanchaya Patra Type Approval Queue List";
                SPTypeDAL       oSPTypeDAL = new SPTypeDAL();
                TemplateBuilder tbGvData   = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Sanchaya Patra Type' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPTypeDAL.LoadTmpDataTableList();
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Type Description";
                            this.gvData.HeaderRow.Cells[3].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Make Date";
                        }
                    }
                }
                #endregion Sanchaya Patra Type
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_WISEA_CCOUNT).PadLeft(5, '0')))
            {
                #region Sanchaya Patra wise Account Mapping
                lgText.InnerHtml = "Sanchaya Patra wise Account Mapping Approval Queue List";
                SPTypeWiseAccountMappingDAL oSPTypeWiseAccountMappingDAL = new SPTypeWiseAccountMappingDAL();
                TemplateBuilder             tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Sanchaya Patra wise Account Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPTypeWiseAccountMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            // for adding seperator....
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(2);
                            alAddSeperatorIndex.Add(3);
                            alAddSeperatorIndex.Add(4);
                            alAddSeperatorIndex.Add(5);
                            alAddSeperatorIndex.Add(6);
                            alAddSeperatorIndex.Add(7);

                            dtTmpList.Columns.Remove("StockInHandAccName");
                            dtTmpList.Columns.Remove("LiabilityOnStockAccName");
                            dtTmpList.Columns.Remove("HoldingAccName");
                            dtTmpList.Columns.Remove("AccruedInterestAccName");
                            dtTmpList.Columns.Remove("AdvAgainstInterestAccName");
                            dtTmpList.Columns.Remove("AdvAgainstPrincipalAccName");
                            dtTmpList.Columns.Remove("CheckerID");
                            dtTmpList.Columns.Remove("CheckDate");
                            dtTmpList.Columns.Remove("CheckerComment");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SPType ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Stock In Hand Acc";
                            this.gvData.HeaderRow.Cells[3].Text = "Liability On  Stock Acc";
                            this.gvData.HeaderRow.Cells[4].Text = "Holding Acc";
                            this.gvData.HeaderRow.Cells[5].Text = "Accrued Interest Acc";
                            this.gvData.HeaderRow.Cells[6].Text = "AdvAgainst Interest Acc";
                            this.gvData.HeaderRow.Cells[7].Text = "Adv Against Principal Acc";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion Sanchaya Patra wise Account Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SYSTEM_CONFIG).PadLeft(5, '0')))
            {
                #region System Configuration
                lgText.InnerHtml = "System Configuration Approval Queue List";
                SystemConfigurationDAL oSCDAL   = new SystemConfigurationDAL();
                TemplateBuilder        tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'System Configuration' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSCDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("Dr_Code");
                            dtTmpList.Columns.Remove("Cr_Code");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Data File";
                            this.gvData.HeaderRow.Cells[2].Text = "Originator ID";
                            this.gvData.HeaderRow.Cells[3].Text = "Row Type Header";
                            this.gvData.HeaderRow.Cells[4].Text = "Row Type Footer";
                            this.gvData.HeaderRow.Cells[5].Text = "Dr Transaction Code";
                            this.gvData.HeaderRow.Cells[6].Text = "Cr Transaction Code";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion System Configuration
            }

            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.COMMON_MAPPING).PadLeft(5, '0')))
            {
                #region Common Mapping
                lgText.InnerHtml = "Common Mapping Approval Queue List";
                CommonMappingDAL oCmAL    = new CommonMappingDAL();
                TemplateBuilder  tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Common Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCmAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(3);

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                        }
                    }
                }
                #endregion Common Mapping
            }

            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BANK).PadLeft(5, '0')))
            {
                #region Common Mapping
                lgText.InnerHtml = "Bank Setup Approval Queue List";
                BankDAL         oBankDAL = new BankDAL();
                TemplateBuilder tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Bank Setup' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBankDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            this.gvData.HeaderRow.Cells[1].Text = "Bank ID";
                            this.gvData.HeaderRow.Cells[2].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Bank Name";
                            this.gvData.HeaderRow.Cells[4].Text = "Branch ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Address";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Make Date";

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
                        }
                    }
                }
                #endregion Common Mapping
            }
        }
    }
Ejemplo n.º 13
0
 public void DeleteDivisions(DivisionDTO divisions)
 {
     DivisionDAL.DeleteDivisions(Map <Division>(divisions));
 }
Ejemplo n.º 14
0
 /// <summary>
 /// Default Constructor
 /// </summary>
 public DivisionService()
 {
     divisionDAL = new DivisionDAL();
 }
Ejemplo n.º 15
0
        public void Edit(Division entity)
        {
            DivisionDAL dalObject = new DivisionDAL();

            dalObject.Edit(entity);
        }
Ejemplo n.º 16
0
        public void Delete(int id)
        {
            DivisionDAL dalObject = new DivisionDAL();

            dalObject.Delete(id);
        }
Ejemplo n.º 17
0
 public void AddDivisions(List <DivisionDTO> divisions)
 {
     DivisionDAL.AddDivisions(Map <List <Division> >(divisions));
 }
Ejemplo n.º 18
0
 public void  UpdateDivisions(DivisionDTO divisions)
 {
     DivisionDAL.UpdateDivisions(Map <Division>(divisions));
 }
 public DivisionBLL()
 {
     this.divisionDAL = new DivisionDAL();
 }