//Grid Fee row deleting #region [Grid Fee Row Deleting] protected void GrdFees_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { string[] confirmValue = Request.Form["confirm_value"].Split(','); if (confirmValue[confirmValue.Length - 1] == "Yes") { EWA_Fees ObjEWA = new EWA_Fees(); BL_Fees ObjBL = new BL_Fees(); ObjEWA.Action = "DeleteParticular"; ObjEWA.FeesId = ViewState["FeesId"].ToString(); Label lblParticular = (Label)GrdFees.Rows[e.RowIndex].FindControl("lblPerticular"); ObjEWA.Particular = lblParticular.Text; string FeesDetailsId = GrdFees.DataKeys[e.RowIndex].Values["FeesDetailsId"].ToString(); ObjEWA.FeesDetalsId = FeesDetailsId; ObjBL.DeleteParticular_BL(ObjEWA); BindGridView(ObjEWA.FeesId); lblresult.ForeColor = Color.Green; lblresult.Text = ObjEWA.Particular + " Details Deleted successfully"; } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Grid Fee Row Command #region [Grid Fee Row Command] protected void GrdFees_RowCommand(object sender, GridViewCommandEventArgs e) { try { EWA_Fees ObjEWA = new EWA_Fees(); BL_Fees ObjBL = new BL_Fees(); if (e.CommandName.Equals("AddNew")) { TextBox txtParticular = (TextBox)GrdFees.FooterRow.FindControl("txtFooterPerticular"); TextBox txtAmount = (TextBox)GrdFees.FooterRow.FindControl("txtFooterAmount"); ObjEWA.FeesId = ViewState["FeesId"].ToString(); ObjEWA.Particular = txtParticular.Text; ObjEWA.Amount = txtAmount.Text; ObjEWA.Action = "Save"; ObjBL.AddNewRow_BL(ObjEWA); BindGridView(ObjEWA.FeesId); lblresult.ForeColor = Color.Green; lblresult.Text = ObjEWA.Particular + " Details inserted successfully"; //msgBox.ShowMessage("Particular added successfully !!!", "Information", UserControls.MessageBox.MessageStyle.Critical); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Grid View #region [Bind Grid View] private void BindGridView(string feesId) { try { EWA_Fees ObjEWA = new EWA_Fees(); BL_Fees ObjBL = new BL_Fees(); if (!feesId.Equals("Empty")) { ObjEWA.FeesId = feesId; DataSet ds = ObjBL.BindGridView_BL(ObjEWA); if (ds != null) { GrdFees.DataSource = ds; GrdFees.DataBind(); } else { BindEmptyDataTable(); } } else { BindEmptyDataTable(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Caste Category Index Changed #region [Caste Category Index Changed] protected void ddlCastCategory_SelectedIndexChanged(object sender, EventArgs e) { try { EWA_Fees ObjEWA = new EWA_Fees(); BL_Fees ObjBL = new BL_Fees(); ObjEWA.OrgId = Session["OrgId"].ToString(); ObjEWA.CourseId = ddlCourse.SelectedValue; ObjEWA.ClassId = ddlClass.SelectedValue; ObjEWA.CasteCategoryId = ddlCastCategory.SelectedValue; ObjEWA.AcademicYear = ddlAcademicYear.SelectedValue; if (!ObjEWA.CasteCategoryId.Equals("Select")) { DataSet ds = ObjBL.GetFeesId_BL(ObjEWA); if (ds.Tables[0].Rows.Count > 0) { feesId = ds.Tables[0].Rows[0]["FeesId"].ToString(); ViewState["FeesId"] = feesId; ObjEWA.OrgId = Session["OrgId"].ToString(); BindGridView(feesId); } else { ObjEWA.OrgId = Session["OrgId"].ToString(); ObjEWA.CourseId = ddlCourse.SelectedValue; ObjEWA.BranchId = ddlBranch.SelectedValue; ObjEWA.ClassId = ddlClass.SelectedValue; ObjEWA.AcademicYear = ddlAcademicYear.SelectedValue; ObjEWA.CasteCategoryId = ddlCastCategory.SelectedValue; ObjEWA.Action = "Save"; ObjBL.AddNewFees_BL(ObjEWA); ds = ObjBL.GetFeesId_BL(ObjEWA); feesId = ds.Tables[0].Rows[0]["FeesId"].ToString(); ViewState["FeesId"] = feesId; BindGridView("Empty"); } } else { BindEmptyDataTable(); } lblresult.Text = ""; } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Academic Year #region [Bind Academic Year] protected void BindAcademicYear() { try { EWA_AcademicYear ObjEWA = new EWA_AcademicYear(); BL_Fees ObjBL = new BL_Fees(); ObjEWA.OrgId = Convert.ToInt32(Session["OrgId"]); DataSet ds = ObjBL.BindAcademicYear_BL(ObjEWA); ddlAcademicYear.DataSource = ds; ddlAcademicYear.DataTextField = "AcademicYear"; ddlAcademicYear.DataValueField = "AcademicYearId"; ddlAcademicYear.DataBind(); ddlAcademicYear.Items.Insert(0, new ListItem("Select", "0")); BindEmptyDataTable(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Grid Fee Row Updating #region [Grid Fee Row Updating] protected void GrdFees_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { EWA_Fees ObjEWA = new EWA_Fees(); BL_Fees ObjBL = new BL_Fees(); ObjEWA.Action = "UpdateParticular"; ObjEWA.FeesId = ViewState["FeesId"].ToString(); TextBox txtParticular = (TextBox)GrdFees.Rows[e.RowIndex].FindControl("txtPerticular"); TextBox txtAmount = (TextBox)GrdFees.Rows[e.RowIndex].FindControl("txtAmount"); string FeesDetailsId = GrdFees.DataKeys[e.RowIndex].Values["FeesDetailsId"].ToString(); ObjEWA.FeesDetalsId = FeesDetailsId; ObjEWA.Particular = txtParticular.Text; ObjEWA.Amount = txtAmount.Text; ObjEWA.OldParticular = ViewState["OldParticular"].ToString(); ObjEWA.OldAmount = ViewState["OldAmount"].ToString(); int result = ObjBL.UpdateParticular_BL(ObjEWA); GrdFees.EditIndex = -1; BindGridView(ObjEWA.FeesId); if (result > 0) { lblresult.ForeColor = Color.Green; lblresult.Text = ObjEWA.Particular + " Details Updated successfully"; } else { lblresult.ForeColor = Color.Red; lblresult.Text = ObjEWA.OldParticular + " Details is in use. Not updated."; } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }