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;
}
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;
}
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;
}
}
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();
}
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
}
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");
}
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;
}
}
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;
}
}
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();
}
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)
{
}
}
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;
}
public static int CheckTransactinoCompletedByCheckID(ACC_Check aCC_Check)
{
SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
return sqlACC_CheckProvider.CheckTransactinoCompletedByCheckID(aCC_Check);
}
public static int CheckBounchByCheckID(ACC_Check aCC_Check)
{
SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
return sqlACC_CheckProvider.CheckBounchByCheckID(aCC_Check);
}
public static bool UpdateACC_Check(ACC_Check aCC_Check)
{
SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
return sqlACC_CheckProvider.UpdateACC_Check(aCC_Check);
}
public static int InsertACC_Check(ACC_Check aCC_Check)
{
SqlACC_CheckProvider sqlACC_CheckProvider = new SqlACC_CheckProvider();
return sqlACC_CheckProvider.InsertACC_Check(aCC_Check);
}
