protected void ddlCLasses_SelectedIndexChanged(object sender, EventArgs e) { try { Session["ClassiD"] = ddlCLasses.SelectedValue; Feedue sfd = new Feedue(); sfd.CID = Convert.ToInt64(ddlCLasses.SelectedValue); DataSet ds = Fddal.Sections(sfd); if (ds.Tables[0].Rows.Count > 0) { ddlSection.DataSource = ds; ddlSection.DataBind(); ddlSection.Items.Insert(0, new ListItem("Select Section", "-1")); ddlSection.Focus(); } else { ddlSection.DataSource = null; ddlSection.DataBind(); ddlSection.Items.Insert(0, new ListItem("No Section Found", "-1")); } } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.ToString(); } }
public void loadDues(long id) { try { if (ddlStType.SelectedValue != "5") { Feedue feed = new Feedue(); feed.StudentID = id; feed.CSession = Session["Current_Session"].ToString(); DataSet ds = dal.LoadFeeDue(feed); if (ds.Tables[0].Rows.Count > 0) { Session["Dataset"] = ds; gvChkDueFees.DataSource = ds; gvChkDueFees.DataBind(); } else { Session["Dataset"] = null; gvChkDueFees.DataSource = null; gvChkDueFees.DataBind(); } } } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.ToString(); } }
public void Classes() { try { Feedue cfd = new Feedue(); cfd.CSession = Session["Current_Session"].ToString(); DataSet ds = Fddal.classes(cfd); if (ds.Tables[0].Rows.Count > 0) { ddlCLasses.DataSource = ds; ddlCLasses.DataBind(); ddlCLasses.Items.Insert(0, new ListItem("Select Section", "-1")); Session["ClassID"] = ddlCLasses.SelectedValue; ddlCLasses.Focus(); } else { ddlCLasses.DataSource = null; ddlCLasses.DataBind(); ddlCLasses.Items.Insert(0, new ListItem("No Section Found", "-1")); } } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.ToString(); } }
protected void ddlSection_SelectedIndexChanged(object sender, EventArgs e) { Session["Sectionid"] = ddlSection.SelectedValue; Feedue sfd = new Feedue(); sfd.CID = Convert.ToInt64(ddlCLasses.SelectedValue); sfd.SecID = Convert.ToInt64(ddlSection.SelectedValue); DataSet ds = Fddal.gStudent(sfd); if (ds.Tables[0].Rows.Count > 0) { ddlStudent.DataSource = ds; ddlStudent.DataBind(); ddlStudent.Items.Insert(0, new ListItem("Select Student", "-1")); ddlStudent.Focus(); } else { ddlStudent.DataSource = null; ddlStudent.DataBind(); ddlStudent.Items.Insert(0, new ListItem("No Student Found", "-1")); ddlSection.Focus(); } }
public void Sections() { try { Session["ClassiD"] = ddlclasses.SelectedValue; Feedue sfd = new Feedue(); sfd.CID = Convert.ToInt64(ddlclasses.SelectedValue); DataSet ds = Ddal.Sections(sfd); if (ds.Tables[0].Rows.Count > 0) { ddlsection.DataSource = ds; ddlsection.DataTextField = "SectionName"; ddlsection.DataValueField = "SectionID"; ddlsection.DataBind(); ddlsection.Items.Insert(0, new ListItem("Select Section", "-1")); } else { ddlsection.DataSource = null; ddlsection.DataBind(); ddlsection.Items.Insert(0, new ListItem("No Section Found", "-1")); } } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.ToString(); } }
public void getFSAmount() { try { SqlDataReader rdr = null; if (ddlStType.SelectedValue == "5") { Feedue FDdal = new Feedue(); FDdal.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); FDdal.CID = Convert.ToInt64(ddlCLasses.SelectedValue); rdr = dal.getFSAmountByCID(FDdal); } else { Feedue FDdal = new Feedue(); FDdal.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); FDdal.StudentID = Convert.ToInt64(Session["SCode"].ToString()); FDdal.CSession = Session["Current_Session"].ToString(); rdr = dal.GetFSAmount(FDdal); } if (rdr.HasRows) { txtAmount.Text = rdr["Amount"].ToString(); lblError.Visible = false; lblSuccess.Visible = false; lblError.Text = ""; lblSuccess.Text = ""; } else { ddlCLasses.SelectedValue = "-1"; btnAddFS.Visible = true; btnAddFS.Attributes.Add("onclick", " return OpenPopup(" + Convert.ToInt64(Session["ClassID"]) + ");"); ddlFeeHeads.SelectedValue = "-1"; txtAmount.Text = ""; txtDueDate.Text = ""; txtRemarks.Text = ""; ddlBussFee.SelectedValue = "-1"; ddlBussFee.Visible = false; lblError.Visible = true; lblSuccess.Visible = false; lblSuccess.Text = ""; lblError.Text = " Fee Structure Not Assigned Yet!"; } } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.ToString(); } }
public int getFHType() { Feedue fhT = new Feedue(); fhT.FHID = Convert.ToInt32(ddlFeeHeads.SelectedValue); DataSet ds = dal.getFHType(fhT); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; int FHID = Convert.ToInt32(dr["FHType"].ToString()); return(FHID); } else { return(0); } }
private void StudentByClass() { //try //{ Feedue bo = new Feedue(); int cc = 0; int count = 0; int countN = 0; bo.CSession = Session["Current_Session"].ToString(); bo.CID = Convert.ToInt64(ddlCLasses.SelectedValue); bo.SecID = Convert.ToInt64(ddlSection.SelectedValue); bo.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); if (ddlFeeHeads.SelectedValue == "2") { if (ddlBussFee.SelectedValue == "1") { bo.Check = 1; } else { bo.Check = 2; } } else { bo.Check = 1; } DataSet dsStudents = Fddal.studentInfobyCID(bo); foreach (ListItem li in chklMonths.Items) { if (li.Selected) { if (ddlBussFee.SelectedValue == "2") { if (dsStudents.Tables[0].Rows.Count > 0) { DataRow ddrr = dsStudents.Tables[0].Rows[0]; if (Convert.ToInt64(ddrr["BusStopID"].ToString()) != 0) { if (string.IsNullOrEmpty(ddrr["BusRate"].ToString())) { cc++; lblError.Text = cc.ToString(); } else { foreach (DataRow dr in dsStudents.Tables[0].Rows) { if (Convert.ToDecimal(dr["BusRate"]) != 0) { Feedue fdModel = new Feedue(); fdModel.CID = Convert.ToInt64(ddlCLasses.SelectedValue); fdModel.SecID = Convert.ToInt64(dr["SectionID"].ToString()); fdModel.StudentID = Convert.ToInt64(dr["StudentID"].ToString()); fdModel.StudentInfoID = Convert.ToInt64(dr["StudentInfoID"].ToString()); fdModel.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); fdModel.DID = Convert.ToInt64(dr["SubDepartmentID"]); fdModel.CSession = Session["Current_Session"].ToString(); fdModel.FeeMonth = li.Text; fdModel.FYear = Session["FYear"].ToString(); fdModel.SystemMonth = DateTime.Now.ToString("MMMM"); fdModel.SystemYear = DateTime.Now.ToString("yyyy"); fdModel.FeeRate = Convert.ToDecimal(dr["BusRate"]); fdModel.Rebate = 0; fdModel.UserName = Session["UserName"].ToString(); fdModel.IsApplicable = 0; fdModel.Remarks = txtRemarks.Text; fdModel.FeeHeadName = ddlFeeHeads.SelectedItem.Text; fdModel.TType = 0; fdModel.IsPaid = 0; fdModel.FHType = getFHType(); fdModel.BillDate = DateTime.Now; fdModel.DueDate = CreatDueDate(li.Text, li.Value); fdModel.FSID = 0; string var = Fddal.feeDueInduviual(fdModel); if (var == "1" || var == "0") { if (var == "1") { count++; } else { countN++; } } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = var; } } } } if (count > 0) { lblError.Visible = false; lblSuccess.Visible = true; lblSuccess.Text = "Fee assigned for '" + count + "' Students "; btnAddFS.Visible = false; // txtAmount.Text = ""; //ddlFeeHeads.SelectedValue = "-1"; } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "transaction Failed or Alredy assigned !."; // txtAmount.Text = ""; } } } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "No students found !"; } } else { if (dsStudents.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsStudents.Tables[0].Rows) { Feedue fdModel = new Feedue(); fdModel.CID = Convert.ToInt64(ddlCLasses.SelectedValue); fdModel.SecID = Convert.ToInt64(dr["SectionID"].ToString()); fdModel.StudentID = Convert.ToInt64(dr["StudentID"].ToString()); fdModel.StudentInfoID = Convert.ToInt64(dr["StudentInfoID"].ToString()); fdModel.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); fdModel.DID = Convert.ToInt64(dr["SubDepartmentID"]); fdModel.CSession = Session["Current_Session"].ToString(); if (ddlFeeHeads.SelectedValue == "3") { fdModel.FeeMonth = "Annual Fee"; } else { fdModel.FeeMonth = li.Text; } fdModel.FYear = Session["FYear"].ToString(); fdModel.SystemMonth = DateTime.Now.ToString("MMMM"); fdModel.SystemYear = DateTime.Now.ToString("yyyy"); fdModel.FeeRate = Convert.ToDecimal(txtAmount.Text); fdModel.Rebate = 0; fdModel.UserName = Session["UserName"].ToString(); fdModel.IsApplicable = 0; fdModel.Remarks = txtRemarks.Text; fdModel.FeeHeadName = ddlFeeHeads.SelectedItem.Text; fdModel.TType = 0; fdModel.IsPaid = 0; fdModel.FHType = getFHType(); fdModel.BillDate = DateTime.Now; fdModel.DueDate = CreatDueDate(li.Text, li.Value); fdModel.FSID = Convert.ToInt64(dr["FSID"].ToString()); string var = Fddal.feeDueInduviual(fdModel); if (var == "1" || var == "0") { if (var == "1") { count++; } else { countN++; } } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = var; } } if (count > 0) { lblError.Visible = false; lblSuccess.Visible = true; lblSuccess.Text = "Fee assigned for '" + count + "' Students "; btnAddFS.Visible = false; } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "transaction Failed or Alredy assigned !."; } } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "No students found !"; } } } } //} //catch (Exception ex) //{ // lblError.Visible = true; // lblMessage.Visible = false; // lblError.Text = ex.ToString(); // lblError.ForeColor = System.Drawing.Color.Red; //} }
private void Student() { try { Feedue bo = new Feedue(); int count = 0; if (ddlBussFee.SelectedValue == "2") { bo.CSession = Session["Current_Session"].ToString(); bo.StudentID = Convert.ToInt64(Session["SCode"].ToString()); bo.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); bo.Check = 2; } else { bo.CSession = Session["Current_Session"].ToString(); bo.StudentID = Convert.ToInt64(Session["SCode"].ToString()); bo.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); if (ddlFeeHeads.SelectedValue == "2") { if (ddlBussFee.SelectedValue == "1") { bo.Check = 1; } else { bo.Check = 2; } } else { bo.Check = 1; } } DataSet dsStudents = Fddal.studentInfobyID(bo); foreach (ListItem li in chklMonths.Items) { if (li.Selected) { if (dsStudents.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsStudents.Tables[0].Rows) { Feedue fdModel = new Feedue(); fdModel.CID = Convert.ToInt64(dr["classid"].ToString()); fdModel.SecID = Convert.ToInt64(dr["SectionID"].ToString()); fdModel.StudentID = Convert.ToInt64(dr["StudentID"].ToString()); fdModel.StudentInfoID = Convert.ToInt64(dr["StudentInfoID"].ToString()); fdModel.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); fdModel.DID = Convert.ToInt64(dr["SubDepartmentID"]); fdModel.CSession = Session["Current_Session"].ToString(); if (ddlFeeHeads.SelectedValue == "3") { fdModel.FeeMonth = "Annual Fee"; } else { fdModel.FeeMonth = li.Text; } fdModel.FYear = "2018-19"; //Session["FYear"].ToString(); fdModel.SystemMonth = DateTime.Now.ToString("MMMM"); fdModel.SystemYear = DateTime.Now.ToString("yyyy"); fdModel.FeeRate = Convert.ToDecimal(txtAmount.Text); fdModel.Rebate = 0; fdModel.UserName = Session["UserName"].ToString(); fdModel.IsApplicable = 0; fdModel.Remarks = txtRemarks.Text; fdModel.FeeHeadName = ddlFeeHeads.SelectedItem.Text; fdModel.TType = 0; fdModel.IsPaid = 0; fdModel.FHType = getFHType(); fdModel.BillDate = DateTime.Now; fdModel.DueDate = Convert.ToDateTime((CreatDueDate(li.Text, li.Value))); if (ddlBussFee.SelectedValue == "2") { fdModel.FSID = 0; } else { fdModel.FSID = Convert.ToInt64(dr["FSID"].ToString()); } string var = Fddal.feeDueInduviual(fdModel); if (var == "1" || var == "0") { if (var == "1") { count++; } } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = var; } } if (count > 0) { lblError.Visible = false; lblSuccess.Visible = true; lblSuccess.Text = "Fee assigned for " + count + " Months"; loadDues(Convert.ToInt64(Session["SCode"])); // txtAmount.Text = ""; } else { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "Transaction Failed or Alredy assigned !."; loadDues(Convert.ToInt64(Session["SCode"])); } } } } } catch (Exception ex) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = ex.ToString(); lblError.ForeColor = System.Drawing.Color.Red; } }
public void CheckFeeHeadIsPaid() { try { Feedue fee = new Feedue(); fee.StudentID = Convert.ToInt64(Session["SCode"]); fee.CSession = Session["Current_Session"].ToString(); fee.FHID = Convert.ToInt64(ddlFeeHeads.SelectedValue); DataSet ds = dal.isFHIDPaid(fee); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (Convert.ToInt64(dr["FHType"]) == getFHType()) { if (CheckFHTypeinMonths() > 0) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "Fee Already Billed in " + dr["FeeMonth"].ToString() + ". This is Onetime Payable !. "; chklMonths.ClearSelection(); chklMonths.Enabled = false; } } else if (Convert.ToInt64(dr["FHType"]) == getFHType()) { if (CheckFHTypeinMonths() > 1) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = "Fee Already Billed in " + dr["FeeMonth"].ToString() + ". This is Annually Payable !. "; chklMonths.ClearSelection(); chklMonths.Enabled = false; } } } else { int count = 0; if (getFHType() == 3) { if (CheckFHTypeinMonths() > 1) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = ddlFeeHeads.SelectedItem.Text + " is Onetime payable"; } } else if (getFHType() == 2) { if (CheckFHTypeinMonths() > 1) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = ddlFeeHeads.SelectedItem.Text + " is Annually payable, select only one month."; } } } } catch (Exception ex) { lblError.Visible = true; lblSuccess.Visible = false; lblError.Text = ex.ToString(); } }