protected void BindFeesGrid() { try { FeesCollectionBL objFeeCollectionBL = new FeesCollectionBL(); ApplicationResult objResults = new ApplicationResult(); objResults = objFeeCollectionBL.Fee_Collection_PastDetail(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlYear.SelectedItem.ToString(), Convert.ToInt32(ViewState["StudentMID"].ToString())); if (objResults != null) { gvPastFees.Visible = true; gvPastFees.DataSource = objResults.resultDT; gvPastFees.DataBind(); if (objResults.resultDT.Rows.Count > 0) { aa.Visible = true; divPastFees.Visible = true; } else { aa.Visible = false; divPastFees.Visible = false; ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('No Record Found.');</script>"); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
public void BindSchoolFeesList() { ApplicationResult objResult = new ApplicationResult(); FeesCollectionBL objFeesCollectionBl = new FeesCollectionBL(); objResult = objFeesCollectionBl.FeesCollection_Select_byClasslWise(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ddlYear.SelectedItem.Text); if (objResult.resultDT.Rows.Count > 0) { gvReport.DataSource = objResult.resultDT; gvReport.DataBind(); divReport.Visible = true; //btnPrintDetail.Visible = true; pnlFeesCollectionInfo.Visible = false; lblTrust.Text = Session[ApplicationSession.TRUSTNAME].ToString(); lblSchool.Text = Session[ApplicationSession.SCHOOLNAME].ToString(); lblYear.Text = ddlYear.SelectedItem.Text; } else { divReport.Visible = false; // btnPrintDetail.Visible = false; pnlFeesCollectionInfo.Visible = true; ClearAll(); ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No Records Found.');", true); } }
protected void BindFeesReport() { try { FeesCollectionBL objFeeCollectionBL = new FeesCollectionBL(); ApplicationResult objResults = new ApplicationResult(); objResults = objFeeCollectionBL.FeesCollection_Report(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ViewState["FeesCollectionMID"])); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { gvReport.Visible = true; gvReport.DataSource = objResults.resultDT; gvReport.DataBind(); gvReport1.Visible = true; gvReport1.DataSource = objResults.resultDT; gvReport1.DataBind(); } else { gvReport.Visible = false; gvReport1.Visible = false; } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void gvPastFees_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.ToString() == "Print1") { GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int ReceiptNo = Convert.ToInt32(e.CommandArgument.ToString()); int rowIndex = gvr.RowIndex; Label lblRecNo = (Label)gvPastFees.Rows[rowIndex].Cells[0].FindControl("lblRcNo"); string strDate = gvPastFees.Rows[rowIndex].Cells[2].Text; string strName = lblStudentNameEng.Text; string strClass = lblClassDivision.Text; lblFinancialYear.Text = lblRecNo.Text.Split('/')[0]; lblVoucherNo.Text = lblRecNo.Text; lblDate.Text = strDate; lblStudentName.Text = strName; lblStd.Text = strClass.Split(' ')[0]; lblFYear.Text = lblRecNo.Text.Split('/')[0]; lblVoucherNo1.Text = lblRecNo.Text; lblDate1.Text = strDate; lblStudentName1.Text = strName; lblStd1.Text = strClass.Split(' ')[0]; FeesCollectionBL objFeeCollectionBL = new FeesCollectionBL(); ApplicationResult objResults = new ApplicationResult(); objResults = objFeeCollectionBL.FeesCollection_RePrint(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), ReceiptNo, Convert.ToInt32((ViewState["StudentMID"]))); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { gvReport.Visible = true; gvReport.DataSource = objResults.resultDT; gvReport.DataBind(); gvReport1.Visible = true; gvReport1.DataSource = objResults.resultDT; gvReport1.DataBind(); } else { gvReport.Visible = false; gvReport1.Visible = false; } ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "getPrint('divFeeCollectionPrint');", true); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void BindFeesGrid() { try { FeesCollectionBL objFeeCollectionBL = new FeesCollectionBL(); ApplicationResult objResults = new ApplicationResult(); objResults = objFeeCollectionBL.Fee_Collection_WithOptionalAndCompulsoryFees(Convert.ToInt32(ViewState["StudentMID"].ToString())); if (objResults != null) { gvFees.Visible = true; gvFees.DataSource = objResults.resultDT; gvFees.DataBind(); if (objResults.resultDT.Rows.Count > 0) { divFeeVisibility.Visible = true; lblFee.Visible = false; pnlFees.Visible = true; } else { // ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Fee Template is not defined for " + Convert.ToInt32(ViewState["ClassName"].ToString()) + "-" + ViewState["Division"].ToString() + "( " + ViewState["AcademicYear"].ToString() + " ).');</script>"); divFeePanel.Visible = true; divFeeVisibility.Visible = false; pnlFees.Visible = false; lblFee.Visible = true; lblFee.Text = "No fee Details"; } } objResults = objFeeCollectionBL.Fee_Collection_PastDetail(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ViewState["AcademicYear"].ToString(), Convert.ToInt32(ViewState["StudentMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { lblmsg.Visible = false; gvPastFees.Visible = true; gvPastFees.DataSource = objResults.resultDT; gvPastFees.DataBind(); divFeeVisibility.Visible = true; } else { //divPastFees.Visible = false; lblmsg.Visible = true; lblmsg.Text = "No Past Record."; } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { FeesCollectionBL ObjFeesCancellationBL = new FeesCollectionBL(); ApplicationResult objResults = new ApplicationResult(); int Count = 0; string FeesTID = string.Empty; string FeesMID = string.Empty; int FeesMIDCount = 0; foreach (GridViewRow row in gvPastFees.Rows) { ViewState["FeesCollectionTID"] = Convert.ToInt32(row.Cells[1].Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { FeesTID += ViewState["FeesCollectionTID"].ToString() + ","; if (FeesMIDCount == 0) { FeesMIDCount = Convert.ToInt32(row.Cells[0].Text); FeesMID += FeesMIDCount + ","; // ViewState["FeesCollectionMID"] = Convert.ToInt32(row.Cells[0].Text); } else { if (FeesMIDCount != Convert.ToInt32(row.Cells[0].Text)) { FeesMIDCount = Convert.ToInt32(row.Cells[0].Text); FeesMID += FeesMIDCount + ","; // ViewState["FeesCollectionMID"] = Convert.ToInt32(row.Cells[0].Text); } } Count = Count + 1; } } objResults = ObjFeesCancellationBL.Fee_Collection_ForCancellation(Convert.ToInt32(ViewState["StudentMID"].ToString()), FeesTID.TrimEnd(','), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString(), txtCancellationReason.Text, FeesMID.TrimEnd(',')); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('FeesCancellation Done SuccessFully.');</script>"); divFeePanel.Visible = false; } } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnGo_Click(object sender, EventArgs e) { FeesCollectionBL objFeesCollectionBl = new FeesCollectionBL(); ApplicationResult objResult = new ApplicationResult(); string strDvisionTIDs = string.Empty; for (int i = 0; i < gvClass.Rows.Count; i++) { GridView gvChildGrid = (GridView)gvClass.Rows[i].FindControl("gvChild"); for (int j = 0; j < gvChildGrid.Rows.Count; j++) { CheckBox chk = (CheckBox)gvChildGrid.Rows[j].FindControl("chkSelect"); if (chk.Checked == true) { strDvisionTIDs += gvChildGrid.Rows[j].Cells[0].Text + ","; } } } //objResult = objFeesCollectionBl.Compact_FirstReport( // Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), // strDvisionTIDs.TrimEnd(), txtFromDate.Text, txtToDate.Text ,ddlYear.SelectedItem.Text, Convert.ToInt32(Session[ApplicationSession.TRUSTID])); objResult = objFeesCollectionBl.Compact_Report(strDvisionTIDs.TrimEnd(), txtToDate.Text, ddlYear.SelectedItem.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), txtFromDate.Text); if (objResult != null) { gvReport.DataSource = null; if (objResult.resultDT.Rows.Count > 0) { divReport.Visible = true; gvReport.Visible = true; divButtons.Visible = true; tabs1.Visible = false; } else { ClearAll(); ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No Records Found.');", true); } } gvReport.DataSource = objResult.resultDT; gvReport.DataBind(); lblFromDate.Text = txtFromDate.Text; lblToDate.Text = txtToDate.Text; }
//protected void ddlclass_SelectedIndexChanged(object sender, EventArgs e) //{ // ApplicationResult objResult = new ApplicationResult(); // Controls objControls = new Controls(); // DivisionTBL objDivisionBl = new DivisionTBL(); // objResult = objDivisionBl.Division_SelectAll_ClassWise_ForDropDown(Convert.ToInt32(ddlclass.SelectedValue), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); // if (objResult != null) // { // objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID"); // if (objResult.resultDT.Rows.Count > 0) // { // } // ddlDivision.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "")); // } //} #endregion #region Go Button Event protected void btnGo_Click(object sender, EventArgs e) { FeesCollectionBL objFeesCollectionBl = new FeesCollectionBL(); ApplicationResult objResult = new ApplicationResult(); string strDvisionTIDs = string.Empty; for (int i = 0; i < gvClass.Rows.Count; i++) { GridView gvChildGrid = (GridView)gvClass.Rows[i].FindControl("gvChild"); for (int j = 0; j < gvChildGrid.Rows.Count; j++) { CheckBox chk = (CheckBox)gvChildGrid.Rows[j].FindControl("chkSelect"); if (chk.Checked == true) { strDvisionTIDs += gvChildGrid.Rows[j].Cells[0].Text + ","; } } } // objResult = objFeesCollectionBl.Test(strDvisionTIDs.TrimEnd()); objResult = objFeesCollectionBl.OutstandingFees_Report( Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), strDvisionTIDs.TrimEnd(), ddlYear.SelectedItem.Text, Convert.ToInt32(ddlStatus.SelectedValue), txtFromDate.Text, txtToDate.Text); if (objResult != null) { gvReport.DataSource = null; if (objResult.resultDT.Rows.Count > 0) { divReport.Visible = true; gvReport.Visible = true; divButtons.Visible = true; //lblClassName.Text = ddlclass.SelectedItem.Text; lblAYear.Text = ddlYear.SelectedItem.Text; //lblDivision.Text = ddlDivision.SelectedItem.Text; lblStatus.Text = ddlStatus.SelectedItem.Text; //DataRow newrow1 = objResult.resultDT.NewRow(); //newrow1[1] = "Total"; //objResult.resultDT.Rows.Add(newrow1); //int i = 0; //foreach (DataColumn col in objResult.resultDT.Columns) //{ // if (i != 0 && i != 1 && i != 2 && i != 3 && i != 4) // { // object sumObject; // sumObject = objResult.resultDT.Compute("Sum([" + col.ColumnName + "])", ""); // objResult.resultDT.Rows[objResult.resultDT.Rows.Count - 1][i] = sumObject; // } // i++; //} //pnlStudentInfo.Visible = false; tabs1.Visible = false; } else { ClearAll(); ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('No Records Found.');", true); } } gvReport.DataSource = objResult.resultDT; gvReport.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { FeesCollectionBL objFeeCollectionBL = new FeesCollectionBL(); FeesCollectionBO objFeeCollectionBO = new FeesCollectionBO(); FeesCollectionTBO objFeeCollectionTBO = new FeesCollectionTBO(); ApplicationResult objResults = new ApplicationResult(); //ApplicationResult objResultsJM = new ApplicationResult(); //JournalVoucherMBL objJournalVoucherMBL = new JournalVoucherMBL(); //JournalVoucherMBO objJournalVoucherMBO = new JournalVoucherMBO(); try { float Total = 0; // Label lblTotalAmount = (Label)gvFees.FooterRow.FindControl("lblTotalAmount"); objFeeCollectionBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objFeeCollectionBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objFeeCollectionBO.StudentMID = Convert.ToInt32(ViewState["StudentMID"].ToString()); objFeeCollectionBO.FeesToBePaid = Convert.ToDouble(txtFullAmount.Text); objFeeCollectionBO.AmountPaid = Convert.ToDouble(txtAmountPaid.Text); objFeeCollectionBO.Date = txtdate.Text; objFeeCollectionBO.CancellationReason = ""; objFeeCollectionBO.AcademicYear = ViewState["AcademicYear"].ToString(); objFeeCollectionBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objFeeCollectionBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); string FeesCollectionTIDs = string.Empty; int Count = 0; foreach (GridViewRow row in gvFees.Rows) { ViewState["ClassTemplateIDs"] = Convert.ToInt32(row.Cells[0].Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { TextBox txt = (TextBox)row.FindControl("lblAcademicYear"); ViewState["Class"] = Convert.ToInt32(row.Cells[11].Text); ViewState["Division"] = Convert.ToInt32(row.Cells[12].Text); ViewState["Year"] = txt.Text; lblFinancialYear.Text = GetCurrentFinancialYear(); lblFYear.Text = GetCurrentFinancialYear(); FeesCollectionTIDs += ViewState["ClassTemplateIDs"].ToString() + ","; Count = Count + 1; } } objFeeCollectionBO.ClassMID = Convert.ToInt32(ViewState["Class"].ToString()); objFeeCollectionBO.DivisionTID = Convert.ToInt32(ViewState["Division"].ToString()); objFeeCollectionBO.AcademicYear = ViewState["Year"].ToString(); objFeeCollectionBO.ClassWiseTemplateIDs = FeesCollectionTIDs.TrimEnd(','); //objFeeCollectionTBO // jornal M // objJournalVoucherMBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); // objJournalVoucherMBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); //// objJournalVoucherMBO.SchoolMID = 0; // objJournalVoucherMBO.VoucherDate = txtdate.Text; // objJournalVoucherMBO.OperationType = "Journal"; // objJournalVoucherMBO.Description = "Fee recieved from student: " + lblStudentNameEng.Text + " in Class " + lblClassDivision.Text + "/" + ViewState["AcademicYear"].ToString(); // objJournalVoucherMBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); // objJournalVoucherMBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); // objJournalVoucherMBO.IsDeleted = 0; // objJournalVoucherMBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); // objJournalVoucherMBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); // string[] words = ViewState["AcademicYear"].ToString().Split('-'); // string Year = words[0] + words[1]; // objJournalVoucherMBO.Year = Convert.ToInt32(Year); //if (initialInsert == 0) //{ // objJournalVoucherMBO.LedgerID = 2; // objJournalVoucherMBO.TransactionType = "Debit"; // objJournalVoucherMBO.Amount = Convert.ToDouble(txtAmountPaid.Text); DatabaseTransaction.OpenConnectionTransation(); // objResultsJM = objJournalVoucherMBL.JournalVoucherM_Insert(objJournalVoucherMBO); // initialInsert++; // if (objResultsJM != null) // { // DataTable dt = new DataTable(); // dt = objResultsJM.resultDT; // if (initialInsert == 1) // { // if (dt.Rows.Count > 0) // { // if (dt.Rows[0][0].ToString() == "Fail") // { // DatabaseTransaction.RollbackTransation(); // //ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Initialize Voucher Start No. For This Year.');</script>"); // initialInsert = 100;// not allow to go in for loop and any transactin and master entry insert // } // else // { // ViewState["VoucherNoJM"] = Convert.ToInt32(dt.Rows[0][0]); // ViewState["VoucherCode"] = dt.Rows[0][1].ToString(); // objJournalVoucherMBO.VoucherNo = Convert.ToInt32(ViewState["VoucherNoJM"]); // objJournalVoucherMBO.VoucherCode = ViewState["VoucherCode"].ToString(); // } // } // } // } //} // Total = Total + txtFeesAmount; objResults = objFeeCollectionBL.FeesCollection_Insert(objFeeCollectionBO); if (objResults != null) { ViewState["FeesCollectionMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); ViewState["VoucherNo"] = Convert.ToInt32(objResults.resultDT.Rows[0][1].ToString()); if (initialInsert != 100) { for (int i = 0; i < gvFees.Rows.Count; i++) { if (((CheckBox)gvFees.Rows[i].FindControl("chkChild")).Checked) { ViewState["ClassWiseFeesTemplateTID"] = Convert.ToInt32(gvFees.Rows[i].Cells[0].Text); ViewState["LedgerID"] = Convert.ToInt32(gvFees.Rows[i].Cells[10].Text); objFeeCollectionTBO.FeesCollectionMID = Convert.ToInt32(ViewState["FeesCollectionMID"].ToString()); TextBox txtDiscount = (TextBox)gvFees.Rows[i].Cells[4].FindControl("txtDiscountAmount"); TextBox txtFeesAmount = (TextBox)gvFees.Rows[i].Cells[6].FindControl("txtTotalAmount"); TextBox txtRemainingAmount = (TextBox)gvFees.Rows[i].Cells[7].FindControl("txtRemainingAmount"); objFeeCollectionTBO.Discount = Convert.ToInt32(txtDiscount.Text); objFeeCollectionTBO.FeesAmount = Convert.ToInt32(txtFeesAmount.Text); objFeeCollectionTBO.RemainingAmount = Convert.ToDouble(txtRemainingAmount.Text); objFeeCollectionTBO.ClassWiseFeesTemplateTID = Convert.ToInt32(ViewState["ClassWiseFeesTemplateTID"]); objFeeCollectionTBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objFeeCollectionTBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResults = objFeeCollectionBL.FeesCollectionT_Insert(objFeeCollectionTBO); if (objResults != null) { //ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees are Collected.');</script>"); } // insertion of Journal Voucher M //if (initialInsert == 1) //{ // objJournalVoucherMBO.LedgerID = Convert.ToInt32(ViewState["LedgerID"].ToString()); // objJournalVoucherMBO.TransactionType = "Credit"; // objJournalVoucherMBO.Amount = Convert.ToInt32(txtFeesAmount.Text); // // initialInsert++; // objResultsJM = objJournalVoucherMBL.JournalVoucherM_Insert(objJournalVoucherMBO); //} } } // insertLedgerTransaction(ViewState["VoucherCode"].ToString()); } DatabaseTransaction.CommitTransation(); BindFeesGrid(); //string strToDate = DateTime.UtcNow.AddHours(5.5).ToShortDateString(); //string LastTwoDigit, strYear; //int intNo; //LastTwoDigit = strToDate.Substring(strToDate.Length - 2); //intNo = Convert.ToInt32(LastTwoDigit) - 1; //strYear = intNo.ToString()+'-'+ LastTwoDigit; lblStudentName.Text = lblStudentNameEng.Text; lblVoucherNo.Text = GetCurrentFinancialYear() + "/" + ViewState["VoucherNo"].ToString(); Session["FYear"] = GetCurrentFinancialYear(); lblStd.Text = lblClassDivision.Text; lblDate.Text = txtdate.Text; lblStudentName1.Text = lblStudentNameEng.Text; lblVoucherNo1.Text = GetCurrentFinancialYear() + "/" + ViewState["VoucherNo"].ToString(); lblStd1.Text = lblClassDivision.Text; lblDate1.Text = txtdate.Text; BindFeesReport(); ScriptManager.RegisterStartupScript(this, GetType(), "CallMyFunction", "getPrint('divFeeCollectionPrint');", true); txtdate.Text = ""; ViewState["AcademicYear"] = ""; divFeePanel.Visible = false; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Initialize Voucher Start No. For This Year.');</script>"); } } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }