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();
}
}
