Example #1
0
 public static ACC_Check GetACC_RowStatusByRowStatusID(int RowStatusID)
 {
     ACC_Check aCC_Check = new ACC_Check();
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     aCC_Check = sqlACC_CheckProvider.GetACC_CheckByRowStatusID(RowStatusID);
     return aCC_Check;
 }
Example #2
0
 public static ACC_Check GetACC_CheckByCheckID(int CheckID)
 {
     ACC_Check aCC_Check = new ACC_Check();
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     aCC_Check = sqlACC_CheckProvider.GetACC_CheckByCheckID(CheckID);
     return aCC_Check;
 }
Example #3
0
    public int CheckBounchByCheckID(ACC_Check aCC_Check)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("ACC_CheckBounchByCheckID", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@JournalMasterID", SqlDbType.Int).Direction = ParameterDirection.Output;
            cmd.Parameters.Add("@CheckID", SqlDbType.Int).Value = aCC_Check.CheckID;
            cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = aCC_Check.AddedBy;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return (int)cmd.Parameters["@JournalMasterID"].Value;
        }
    }
Example #4
0
    protected void btnBounch_Click(object sender, EventArgs e)
    {
        Button btnBounch = new Button();
        btnBounch = (Button)sender;
        int id;
        id = Convert.ToInt32(btnBounch.CommandArgument);

        ACC_Check check = new ACC_Check();
        check.CheckID = id;
        check.AddedBy = Profile.card_id; ;

        int newlyAddedJournalMasterID = ACC_CheckManager.CheckBounchByCheckID(check);
        //DataSet dsCheck = new DataSet();
        //dsCheck= ACC_CheckManager.GetACC_CheckByCheckID(id, true);

        //Now we have to wite the operation for the data Entry
        search();
    }
Example #5
0
    protected void btnTransactionCompleted_Click(object sender, EventArgs e)
    {
        Button btnBounch = new Button();
        btnBounch = (Button)sender;
        int id;
        id = Convert.ToInt32(btnBounch.CommandArgument);
        string bankID = "0";
        foreach (GridViewRow gr in gvACC_Check.Rows)
        {
            Label lblCheckID = (Label)gr.FindControl("lblCheckID");
            if (lblCheckID.Text == id.ToString())
            {
                DropDownList ddlCUCBank = (DropDownList)gr.FindControl("ddlCUCBank");
                bankID = ddlCUCBank.SelectedValue;
            }
        }
        if (bankID == "0")
        {
            //ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Plase select the bank...')", true);
            lblMessage.Visible = true;
            lblMessage.Text = "Plase select the bank...<br/>";
        }
        else
        {
            ACC_Check check = new ACC_Check();
            check.CheckID = id;
            check.ExtraField1 = bankID;
            check.AddedBy = Profile.card_id; ;

            int newlyAddedJournalMasterID = ACC_CheckManager.CheckTransactinoCompletedByCheckID(check);
            lblMessage.Visible = false;

        }

        search();

        //Now we have to wite the operation for the data Entry
    }
Example #6
0
 protected void btnUpdate_Click(object sender, EventArgs e)
 {
     ACC_Check aCC_Check = new ACC_Check ();
     aCC_Check.CheckID=  int.Parse(Request.QueryString["ID"].ToString());
     aCC_Check.CheckNo=  txtCheckNo.Text;
     aCC_Check.BankAccountNo=  txtBankAccountNo.Text;
     aCC_Check.BankID=  int.Parse(ddlBankID.SelectedValue);
     aCC_Check.BranchNOtherDetails=  txtBranchNOtherDetails.Text;
     aCC_Check.Remarks=  txtRemarks.Text;
     aCC_Check.IsCashCheck=  bool.Parse( radIsCashCheck.SelectedValue);
     aCC_Check.ExtraField1=  txtExtraField1.Text;
     aCC_Check.ExtraField2=  txtExtraField2.Text;
     aCC_Check.ExtraField3=  txtExtraField3.Text;
     aCC_Check.ExtraField4=  txtExtraField4.Text;
     aCC_Check.ExtraField5=  txtExtraField5.Text;
     aCC_Check.AddedBy=  Profile.card_id;
     aCC_Check.AddedDate=  DateTime.Now;
     aCC_Check.UpdatedBy=  Profile.card_id;
     aCC_Check.UpdateDate=  DateTime.Now;
     aCC_Check.RowStatusID=  int.Parse(ddlRowStatusID.SelectedValue);
     bool  resutl =ACC_CheckManager.UpdateACC_Check(aCC_Check);
     Response.Redirect("AdminDisplayACC_Check.aspx");
 }
Example #7
0
    public bool UpdateACC_Check(ACC_Check aCC_Check)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("UpdateACC_Check", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@CheckID", SqlDbType.Int).Value = aCC_Check.CheckID;
            cmd.Parameters.Add("@CheckNo", SqlDbType.NVarChar).Value = aCC_Check.CheckNo;
            cmd.Parameters.Add("@BankAccountNo", SqlDbType.NVarChar).Value = aCC_Check.BankAccountNo;
            cmd.Parameters.Add("@BankID", SqlDbType.Int).Value = aCC_Check.BankID;
            cmd.Parameters.Add("@BranchNOtherDetails", SqlDbType.NText).Value = aCC_Check.BranchNOtherDetails;
            cmd.Parameters.Add("@Remarks", SqlDbType.NText).Value = aCC_Check.Remarks;
            cmd.Parameters.Add("@IsCashCheck", SqlDbType.Bit).Value = aCC_Check.IsCashCheck;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_Check.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_Check.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_Check.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = aCC_Check.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = aCC_Check.ExtraField5;
            cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_Check.UpdatedBy;
            cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_Check.UpdateDate;
            cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_Check.RowStatusID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
Example #8
0
    public ACC_Check GetACC_CheckFromReader(IDataReader reader)
    {
        try
        {
            ACC_Check aCC_Check = new ACC_Check
                (

                     DataAccessObject.IsNULL<int>(reader["CheckID"]),
                     DataAccessObject.IsNULL<string>(reader["CheckNo"]),
                     DataAccessObject.IsNULL<string>(reader["BankAccountNo"]),
                     DataAccessObject.IsNULL<int>(reader["BankID"]),
                     DataAccessObject.IsNULL<string>(reader["BranchNOtherDetails"]),
                     DataAccessObject.IsNULL<string>(reader["Remarks"]),
                     DataAccessObject.IsNULL<bool>(reader["IsCashCheck"]),
                     DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
                     DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
                     DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
                     DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
                     DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
                     DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
                     DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
                     DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
                     DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
                     DataAccessObject.IsNULL<int>(reader["RowStatusID"])
                );
             return aCC_Check;
        }
        catch(Exception ex)
        {
            return null;
        }
    }
Example #9
0
 private void showACC_CheckData()
 {
     ACC_Check aCC_Check  = new ACC_Check ();
      	aCC_Check = ACC_CheckManager.GetACC_CheckByCheckID(Int32.Parse(Request.QueryString["ID"]));
      	txtCheckNo.Text =aCC_Check.CheckNo.ToString();
      	txtBankAccountNo.Text =aCC_Check.BankAccountNo.ToString();
      	ddlBankID.SelectedValue  =aCC_Check.BankID.ToString();
      	txtBranchNOtherDetails.Text =aCC_Check.BranchNOtherDetails.ToString();
      	txtRemarks.Text =aCC_Check.Remarks.ToString();
      	 radIsCashCheck.SelectedValue  =aCC_Check.IsCashCheck.ToString();
      	txtExtraField1.Text =aCC_Check.ExtraField1.ToString();
      	txtExtraField2.Text =aCC_Check.ExtraField2.ToString();
      	txtExtraField3.Text =aCC_Check.ExtraField3.ToString();
      	txtExtraField4.Text =aCC_Check.ExtraField4.ToString();
      	txtExtraField5.Text =aCC_Check.ExtraField5.ToString();
      	ddlRowStatusID.SelectedValue  =aCC_Check.RowStatusID.ToString();
 }
Example #10
0
    protected void btnMoney_Click(object sender, EventArgs e)
    {
        if (ddlAccountForMoney.SelectedIndex == 0)
        {
            ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('Please select the Account for Money entry.')", true);
            return;
        }
        try
        {

            List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
            if (Session["doubleEntry"] != null)
            {
                doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];
            }
            int journalID = 0;
            journalID = doubleEntry.Count;

            List<ACC_Check> checks = new List<ACC_Check>();
            if (Session["checks"] != null)
            {
                checks = (List<ACC_Check>)Session["checks"];
            }
            if (ddlAccountForMoney.SelectedValue == "42")
            {
                //If check info is given then we need to save that check
                ACC_Check aCC_Check = new ACC_Check();
                aCC_Check.CheckID = checks.Count;
                aCC_Check.CheckNo = txtCheckNo.Text;
                aCC_Check.BankAccountNo = txtAccountNo.Text;
                aCC_Check.BankID = int.Parse(ddlBank.SelectedValue);
                aCC_Check.BranchNOtherDetails = txtBranchInfo.Text;
                aCC_Check.Remarks = txtAmountMoney.Text; ;
                aCC_Check.IsCashCheck = chkCashCheck.Checked;
                aCC_Check.ExtraField1 = !chkCashCheck.Checked ? ddlBankAccountID.SelectedValue : "";
                aCC_Check.ExtraField2 = hfHeadIDMoney.Value;
                aCC_Check.ExtraField3 = "";
                aCC_Check.ExtraField4 = ddlCheckFrom.SelectedValue;
                aCC_Check.ExtraField5 = txtCheckDate.Text;
                aCC_Check.AddedBy = Profile.card_id;
                aCC_Check.AddedDate = DateTime.Now;
                aCC_Check.UpdatedBy = Profile.card_id;
                aCC_Check.UpdateDate = DateTime.Now;
                aCC_Check.RowStatusID = 1;//temporary we are using this to keep info about the
                checks.Add(aCC_Check);
                Session["checks"] = checks;
                //hfcheckIDs.Value += ACC_CheckManager.InsertACC_Check(aCC_Check).ToString()+",";
            }

            List<ACC_CUCCheck> aCC_CUCCheckList = new List<ACC_CUCCheck>();
            if (Session["cucCheck"] != null)
            {
                aCC_CUCCheckList = (List<ACC_CUCCheck>)Session["cucCheck"];
            }
            if (ddlAccountForMoney.SelectedValue == "2" )
            {
                ACC_CUCCheck aCC_CUCCheck = new ACC_CUCCheck();
                //	aCC_CUCCheck.CUCCheckID=  int.Parse(ddlCUCCheckID.SelectedValue);
                aCC_CUCCheck.CUCCheckName = ddlAccountingUserMoney.SelectedItem.Text;
                aCC_CUCCheck.CUCCheckNo = ddlAccountingUserMoney.SelectedItem.Text;
                aCC_CUCCheck.BankAccountID = int.Parse(ddlAccountingUserMoney.SelectedValue);
                aCC_CUCCheck.CheckDate = DateTime.Parse(txtCUCCheckDate.Text);
                aCC_CUCCheck.PaytoHeadID = int.Parse(hfHeadIDMoney.Value);
                aCC_CUCCheck.JournalID = journalID;
                aCC_CUCCheck.Amount = decimal.Parse(txtAmountMoney.Text);
                aCC_CUCCheck.ExtraField1 = "";
                aCC_CUCCheck.ExtraField2 = "";
                aCC_CUCCheck.ExtraField3 = "";
                aCC_CUCCheck.ExtraField4 = "";
                aCC_CUCCheck.ExtraField5 = "";
                aCC_CUCCheck.AddedBy = Profile.card_id;
                aCC_CUCCheck.AddedDate = DateTime.Now;
                aCC_CUCCheck.UpdatedBy = Profile.card_id;
                aCC_CUCCheck.UpdatedDate = DateTime.Now;
                aCC_CUCCheck.RowStatusID = 1;//Temporary Inserted In DB
                //hfCUCCheck.Value = ACC_CUCCheckManager.InsertACC_CUCCheck(aCC_CUCCheck).ToString();
                aCC_CUCCheckList.Add(aCC_CUCCheck);
                Session["cucCheck"] = aCC_CUCCheckList;
            }

            if (txtStudentCodeMoney.Visible != false)
            {
                if (IsUser(txtStudentCodeMoney.Text))
                {
                    ACC_Journal aCC_Journal = new ACC_Journal();
                    aCC_Journal.JournalID = doubleEntry.Count;

                    aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
                    aCC_Journal.HeadName = lblHeadNameMoney.Text;
                    aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmountMoney.Text : "0");
                    aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmountMoney.Text : "0");
                    aCC_Journal.JournalMasterID = int.Parse("1");
                    aCC_Journal.JournalVoucherNo = ddlAccountForMoney.SelectedValue == "42" ? txtCheckNo.Text : "";
                    aCC_Journal.UserID = txtStudentCodeMoney.Text;
                    aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
                    aCC_Journal.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
                    aCC_Journal.AddedBy = Profile.card_id;
                    aCC_Journal.AddedDate = DateTime.Now;
                    aCC_Journal.UpdatedBy = Profile.card_id;
                    aCC_Journal.UpdateDate = DateTime.Now;
                    aCC_Journal.RowStatusID = 1;
                    aCC_Journal.IsNotCheck = ddlAccountForMoney.SelectedValue == "42" ? false : true;
                    doubleEntry.Add(aCC_Journal);
                    Session["doubleEntry"] = doubleEntry;
                    loadJournal();

                    loadSubmitButton();
                }
                else
                {
                    lblUserMoney.Text = "User is not exist";
                    ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "Message", "alert('User is not exist')", true);
                }
            }
            else
            {

                ACC_Journal aCC_Journal = new ACC_Journal();
                aCC_Journal.JournalID = doubleEntry.Count;
                aCC_Journal.HeadID = int.Parse(hfHeadIDMoney.Value);
                aCC_Journal.HeadName = lblHeadNameMoney.Text;
                aCC_Journal.Debit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Cr" ? txtAmountMoney.Text : "0");
                aCC_Journal.Credit = decimal.Parse(ddlDebitOrCredit.SelectedValue == "Dr" ? txtAmountMoney.Text : "0");
                aCC_Journal.JournalMasterID = int.Parse("1");
                aCC_Journal.JournalVoucherNo = ddlAccountForMoney.SelectedValue == "42" ? txtCheckNo.Text : "";//temporay we are using to manage the check #
                aCC_Journal.UserID = ddlAccountingUserMoney.SelectedValue;
                aCC_Journal.AccountID = int.Parse(ddlAccountForMoney.SelectedValue);
                aCC_Journal.UserTypeID = int.Parse(ddlUserTypeIDMoney.SelectedValue);
                aCC_Journal.AddedBy = Profile.card_id;
                aCC_Journal.AddedDate = DateTime.Now;
                aCC_Journal.UpdatedBy = Profile.card_id;
                aCC_Journal.UpdateDate = DateTime.Now;
                aCC_Journal.RowStatusID = 1;
                aCC_Journal.IsNotCheck = ddlAccountForMoney.SelectedValue == "42" ? false : true;

                doubleEntry.Add(aCC_Journal);
                Session["doubleEntry"] = doubleEntry;
                loadJournal();

                loadSubmitButton();
            }

            ClearAllControllMoney();
        }

        catch (Exception ex)
        {
        }
    }
Example #11
0
    protected void btnJournalEntry_Click(object sender, EventArgs e)
    {
        int fulltimesalryJournalID = 0;
        int FeesMasterJournalID = 0;

        List<ACC_Journal> doubleEntry = new List<ACC_Journal>();
        doubleEntry = (List<ACC_Journal>)Session["doubleEntry"];

        List<ACC_Check> checks = new List<ACC_Check>();
        if (Session["checks"] != null) checks = (List<ACC_Check>)Session["checks"];

        List<ACC_CUCCheck> cucChecks = new List<ACC_CUCCheck>();
        if (Session["cucCheck"] != null) cucChecks = (List<ACC_CUCCheck>)Session["cucCheck"];

        ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
        aCC_JournalMaster.JournalMasterName = "";
        aCC_JournalMaster.AddedBy = Profile.card_id;
        aCC_JournalMaster.AddedDate = DateTime.Now;
        aCC_JournalMaster.UpdatedBy = Profile.card_id;
        aCC_JournalMaster.UpdateDate = DateTime.Now;
        aCC_JournalMaster.RowStatusID = 1;
        aCC_JournalMaster.JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);

        if (doubleEntry != null)
        {
            foreach (ACC_Journal eachJournal in doubleEntry)
            {
                int temp = eachJournal.HeadID;
                string checkno = eachJournal.JournalVoucherNo;

                eachJournal.JournalVoucherNo = Request.QueryString["IsAdmissionFees"] != null ? Request.QueryString["IsAdmissionFees"] : "";
                eachJournal.JournalMasterID = aCC_JournalMaster.JournalMasterID;
                eachJournal.JournalID = ACC_JournalManager.InsertACC_Journal(eachJournal);

                if (eachJournal.AccountID == 17)//fulltime salary
                {
                    fulltimesalryJournalID = eachJournal.JournalID;
                }

                 if (eachJournal.SubBasicAccountID == 20)//student Fees
                {
                    FeesMasterJournalID = eachJournal.JournalID;
                }

                if (checkno != "")
                {
                    foreach (ACC_Check check in checks)
                    {
                        if (checkno == check.CheckNo)
                        {
                            //teamporary we have used the login that
                            //we will keep in the JournalVoucherNo the checkno
                            //then
                            //in the insert script we will update the JournalVoucherNo with the CheckID

                            check.ExtraField3 = eachJournal.JournalID.ToString();
                            ACC_CheckManager.InsertACC_Check(check);
                        }
                    }
                }
                else
                {
                    foreach (ACC_CUCCheck cucCheck in cucChecks)
                    {
                        if (temp == cucCheck.PaytoHeadID)
                        {
                            //cucCheck.PaytoHeadID = eachJournal.JournalID;
                            cucCheck.JournalID = eachJournal.JournalID;
                            ACC_CUCCheckManager.InsertACC_CUCCheck(cucCheck);
                        }
                    }
                }

            }
        }
        if (Session["cucCheck"] != null) Session.Remove("cucCheck");
        if (Session["doubleEntry"] != null) Session.Remove("doubleEntry");
        if (Session["checks"] != null) Session.Remove("checks");

        try
        {
            if (Request.QueryString["CheckID"] != null)
            {
                ACC_Check aCC_Check = new ACC_Check();
                aCC_Check = ACC_CheckManager.GetACC_CheckByCheckID(int.Parse(Request.QueryString["CheckID"]));
                aCC_Check.UpdatedBy = Profile.card_id;
                aCC_Check.UpdateDate = DateTime.Now;
                aCC_Check.RowStatusID = 11;
                bool resutl = ACC_CheckManager.UpdateACC_Check(aCC_Check);
            }
        }
        catch (Exception ex)
        {

        }

        try
        {
            if (Request.QueryString["EmployPayRoleSalaryID"] != null)
            {
                ACC_EmployPayRoleSalary employPayroleSalary = new ACC_EmployPayRoleSalary();

                if (Session["employPayRoleSalary"] != null)
                {
                    employPayroleSalary = (ACC_EmployPayRoleSalary)Session["employPayRoleSalary"];
                    employPayroleSalary.ExtraField6 += ", " + aCC_JournalMaster.JournalMasterID.ToString();
                    employPayroleSalary.ExtraField7 = fulltimesalryJournalID.ToString();
                }
                Session.Remove("employPayRoleSalary");

                bool result = ACC_EmployPayRoleSalaryManager.UpdateEmployPayRoleSalary(employPayroleSalary);
            }
        }
        catch (Exception ex)
        { }

        try
        {
            if (Request.QueryString["FeesID"] != null)
            {
                STD_Fees sTD_FeesUpdate = new STD_Fees();

                sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(int.Parse(Request.QueryString["FeesID"]));
                sTD_FeesUpdate.IsPaid = true;
                sTD_FeesUpdate.SubmitedDate = DateTime.Today.ToString();
                sTD_FeesUpdate.UpdatedBy = Profile.card_id;
                sTD_FeesUpdate.UpdateDate = DateTime.Now;
                sTD_FeesUpdate.RowStatusID = int.Parse("1");
                sTD_FeesUpdate.Remarks = Request.QueryString["Remarks"];
                bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);

                STD_FeesMaster feesMaster = new STD_FeesMaster();
                feesMaster = STD_FeesMasterManager.GetSTD_FeesMasterByFeesMasterID(int.Parse(sTD_FeesUpdate.FeesName));

                feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField1) + sTD_FeesUpdate.Amount).ToString();//total paid Amount
                feesMaster.ExtraField1 = (decimal.Parse(feesMaster.ExtraField2) - sTD_FeesUpdate.Amount).ToString();//total unpaid Amount

                resutl = STD_FeesMasterManager.UpdateSTD_FeesMaster(feesMaster);
            }
        }
        catch (Exception ex)
        { }
        STD_FeesMaster feesMasterTemp = new STD_FeesMaster();
        try
        {
            if (Request.QueryString["newFeesID"] != null)
            {
                if (Session["feesListUpdate"] != null)
                {
                    List<STD_Fees> feesListUpdate = new List<STD_Fees>();
                    feesListUpdate = (List<STD_Fees>)Session["feesListUpdate"];

                    foreach (STD_Fees item in feesListUpdate)
                    {
                        item.IsPaid = true;
                        STD_FeesManager.UpdateSTD_Fees(item);
                    }
                    Session.Remove("feesListUpdate");
                }
                if (Session["feesMaster"] != null)
                {
                    feesMasterTemp = (STD_FeesMaster)Session["feesMaster"];
                    feesMasterTemp.ExtraField4 = FeesMasterJournalID.ToString();
                    STD_FeesMasterManager.UpdateSTD_FeesMaster(feesMasterTemp);
                    Session.Remove("feesMaster");
                }

                if (Request.QueryString["newFeesID"] != "0")
                {
                    STD_Fees sTD_FeesUpdate = new STD_Fees();

                    sTD_FeesUpdate = STD_FeesManager.GetSTD_FeesByFeesID(int.Parse(Request.QueryString["newFeesID"]));
                    sTD_FeesUpdate.RowStatusID = int.Parse("1");
                    bool resutl = STD_FeesManager.UpdateSTD_Fees(sTD_FeesUpdate);
                }

            }
        }
        catch (Exception ex)
        { }

        if (Request.QueryString["Refund"] != null)
        {
            if (STD_FeesMasterManager.RefundSTD_FeesMaster(hfStudentID.Value))
            {
                lblMessage.Text += "Student Refund Successfull<br/>";
            }
        }

        lblMessage.Text += "Journal Entry Successful. <a href='VoucherPage.aspx?JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&EmployeeID=" + ddlAccountingUserMoney.SelectedValue + "&Amount=" + lblDebit.Text + "' target='_blank'>Click here to Print</a>";
        if (Request.QueryString["AccountID"] != null)
        {
            //if (int.Parse(Request.QueryString["AccountID"]) >= 29 && int.Parse(Request.QueryString["AccountID"]) <= 37)
            if (int.Parse(Request.QueryString["SubBasicAccountID"]) ==20)
            {
                lblMessage.Text += "</br><a  target='_blank' href='FeesInstallment.aspx?StudentCode=" + Request.QueryString["StudentCode"] + "'>Back to Student Fees Search page</a></br><a href='MoneyReceipt.aspx?StudentID=" + hfStudentID.Value + "&Amount=" + lblDebit.Text + "&Remark=" + (chkAddInMoneyReceipt.Checked ? txtRemarks.Text : "") + "&FeesMasterID=" + feesMasterTemp.FeesMasterID.ToString() + "&JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&IsAdmissionFees=" + Request.QueryString["IsAdmissionFees"] + "' target='_blank'>Click here to Print the receipt</a>";
                //lblMessage.Text += "</br><a  target='_blank' href='FeesInstallment.aspx?StudentCode=" + Request.QueryString["StudentCode"] + "'>Back to Student Fees Search page</a></br><a href='../Accounting/MoneyReceipt.aspx?StudentID=" + hfStudentID.Value + "&Amount=" + lblDebit.Text + "&Remark=" + Request.QueryString["Remark"] + "&FeesMasterID=" + feesMasterTemp.FeesMasterID.ToString() + "&JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "' target='_blank'>Click here to Print the receipt</a>";
            }
            else
                if (int.Parse(Request.QueryString["AccountID"]) >= 17 && int.Parse(Request.QueryString["AccountID"]) <= 19)
                {
                    lblMessage.Text += "</br><a  target='_blank' href='AccountEmployPayRoleSalary.aspx?EmployeeID=" + Request.QueryString["EmployeeID"] + "'>Back to Sallary posting page</a></br><a href='VoucherPage.aspx?JournalMasterID=" + aCC_JournalMaster.JournalMasterID.ToString() + "&EmployeeID=" + ddlAccountingUser.SelectedValue + "&Amount=" + lblDebit.Text + "&Payto=" + ddlAccountingUser.SelectedItem.Text + "&Purpose=" + Request.QueryString["Purpose"] + "' target='_blank'>Click here to Print the receipt</a>";
                }
        }

        lblMessage.ForeColor = System.Drawing.Color.Green;

        btnJournalEntry.Visible = false;
    }
Example #12
0
 public static int CheckTransactinoCompletedByCheckID(ACC_Check aCC_Check)
 {
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     return sqlACC_CheckProvider.CheckTransactinoCompletedByCheckID(aCC_Check);
 }
Example #13
0
 public static int CheckBounchByCheckID(ACC_Check aCC_Check)
 {
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     return sqlACC_CheckProvider.CheckBounchByCheckID(aCC_Check);
 }
Example #14
0
 public static bool UpdateACC_Check(ACC_Check aCC_Check)
 {
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     return sqlACC_CheckProvider.UpdateACC_Check(aCC_Check);
 }
Example #15
0
 public static int InsertACC_Check(ACC_Check aCC_Check)
 {
     SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
     return sqlACC_CheckProvider.InsertACC_Check(aCC_Check);
 }