protected void btnAdd_Click(object sender, EventArgs e)
{
BusinessLayer.StudentAdmissionBL objStudComm = new StudentAdmissionBL();
int Batch = Convert.ToInt32(ddlBatch.Items[ddlBatch.SelectedIndex].Value);
int Class = Convert.ToInt32(ddlClasses.Items[ddlClasses.SelectedIndex].Value);
int Section = Convert.ToInt32(ddlSections.Items[ddlSections.SelectedIndex].Value);
int i=objStudComm.AddStudPhysicalState(Convert.ToInt32(ddlStudent.Items[ddlStudent.SelectedIndex].Value), DateTime.Now, Convert.ToInt32(txtHeight.Text), Convert.ToInt32(txtWeight.Text), txtChest.Text, txtEyesight.Text, txtBloodgroup.Text, txtDietPreferred.Text, txtAilments.Text, txtAllergies.Text, txtChronocDisease.Text, txtMedicalOPenion.Text,Batch,Class,Section);
if (i > 0)
{
lblSave.Visible = true;
lblSave.Text = "Physical State Added Successfully";
}
ddlBatch.SelectedIndex = 0;
ddlClasses.SelectedIndex = 0;
ddlSections.SelectedIndex = 0;
ddlStudent.SelectedIndex = 0;
txtHeight.Text = "";
txtWeight.Text = "";
txtChest.Text = "";
txtEyesight.Text = "";
txtBloodgroup.Text = "";
txtDietPreferred.Text = "";
txtAilments.Text = "";
txtAllergies.Text = "";
txtChronocDisease.Text = "";
txtMedicalOPenion.Text = "";
}
public void fillStudent(int ClassID, int BatchID, int SectionID)
{
BusinessLayer.StudentAdmissionBL objStudComm = new StudentAdmissionBL();
ds = objStudComm.GetStudPromotionData(Convert.ToInt32(ddlClasses.Items[ddlClasses.SelectedIndex].Value), Convert.ToInt32(ddlBatch.Items[ddlBatch.SelectedIndex].Value), Convert.ToInt32(ddlSections.Items[ddlSections.SelectedIndex].Value));
if (ds.Tables.Count > 0)
{
ddlStudID.DataSource = ds.Tables[0];
ddlStudID.DataTextField = "FullName";
ddlStudID.DataValueField = "StudID";
ddlStudID.DataBind();
ddlStudID.Items.Insert(0, new ListItem("---Select---", "0"));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int i = 0;
string strFromDate = txtFrom.Text;
string strToDate = txtTo.Text;
BusinessLayer.StudentAdmissionBL objStudComm = new BusinessLayer.StudentAdmissionBL();
i = objStudComm.AddStudLeaves(Convert.ToInt32(ddlStudent.Items[ddlStudent.SelectedIndex].Value), Convert.ToDateTime(ChangeDateFormat(strFromDate)), Convert.ToDateTime(ChangeDateFormat(strToDate)), Convert.ToInt32(ddlhousemaster.Items[ddlhousemaster.SelectedIndex].Value), Convert.ToInt32(ddlClasses.Items[ddlClasses.SelectedIndex].Value), Convert.ToInt32(ddlSection.Items[ddlSection.SelectedIndex].Value), txtReason.Text);
if (i > 0)
{
lblMessage.Visible = true;
lblMessage.Text = "Student Leave Added Successfully";
ddlStudent.SelectedIndex = 0;
txtTo.Text = "";
ddlhousemaster.SelectedIndex = 0;
txtReason.Text = "";
ddlBatch.SelectedIndex = 0;
ddlClasses.SelectedIndex = 0;
ddlSection.SelectedIndex = 0;
ddlStudent.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
btnreset.Attributes.Add("onclick", "javascript:return ResetForm();");
btnsave.Attributes.Add("onclick", "javascript:return RequiredValidate();");
fudStudent.Attributes.Add("onchange", "javascript:return AddPhoto('" + fudStudent.ClientID + "','" + imgStud.ClientID + "');");
//fudFatherPhoto.Attributes.Add("onchange", "javascript:return AddPhoto('" + fudFatherPhoto.ClientID + "','" + imgFather.ClientID + "');");
//fudMother.Attributes.Add("onchange", "javascript:return AddPhoto('" + fudMother.ClientID + "','" + imgMother.ClientID + "');");
// fudGuardian.Attributes.Add("onchange", "javascript:return AddPhoto('" + fudGuardian.ClientID + "','" + imgGuardian.ClientID + "');");
lblMessage.Attributes.Add("style", "color:red;font-weight:bold;");
BusinessLayer.CommonDataBL objCommon = new CommonDataBL();
StudentAdmissionBL objStud = new StudentAdmissionBL();
ds = new DataSet();
if (!IsPostBack)
{
for (int i = 2005; i < 2050; i++)
{
ddlYear.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddlYear.Items.Insert(0, new ListItem("---Select---", "0"));
ddlYear.SelectedValue = "2012";
txtAdmissionmDate.Text = DateTime.Today.ToString("dd/MM/yyyy");
Message.Value = DateTime.Today.ToString("dd/MM/yyyy");
ds = objCommon.GetMotherTounge();
ddlMotherTounge.DataSource = ds.Tables[0];
ddlMotherTounge.DataTextField = "Language";
ddlMotherTounge.DataValueField = "MTID";
ddlMotherTounge.DataBind();
ddlMotherTounge.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetJoiningType();
ddlJoinType.DataSource = ds.Tables[0];
ddlJoinType.DataTextField = "JTName";
ddlJoinType.DataValueField = "JTID";
ddlJoinType.DataBind();
ddlJoinType.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetPhysicallyChallenged();
ddlPhysicallyChallanged.DataSource = ds.Tables[0];
ddlPhysicallyChallanged.DataTextField = "PHType";
ddlPhysicallyChallanged.DataValueField = "PHId";
ddlPhysicallyChallanged.DataBind();
ddlPhysicallyChallanged.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetCaste();
ddlcaste.DataSource = ds.Tables[0];
ddlcaste.DataTextField = "Caste";
ddlcaste.DataValueField = "CasteID";
ddlcaste.DataBind();
ddlcaste.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetExtraCurricular();
ddlECA.DataSource = ds.Tables[0];
ddlECA.DataTextField = "Activity";
ddlECA.DataValueField = "ExtraCurricularID";
ddlECA.DataBind();
ddlECA.Items.Insert(0, new ListItem("---Select---", "0"));
//ds = objCommon.GetQualification();
//ddlQualFather.DataSource = ds.Tables[0];
//ddlQualFather.DataTextField = "QualificationDetails";
//ddlQualFather.DataValueField = "QualificationID";
//ddlQualFather.DataBind();
//ddlQualFather.Items.Insert(0, new ListItem("---Select---", "0"));
//ds = objCommon.GetQualification();
//ddlQualMother.DataSource = ds.Tables[0];
//ddlQualMother.DataTextField = "QualificationDetails";
//ddlQualMother.DataValueField = "QualificationID";
//ddlQualMother.DataBind();
//ddlQualMother.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetClasses();
ddlClass.DataSource = ds.Tables[0];
ddlClass.DataTextField = "ClassName";
ddlClass.DataValueField = "ClassID";
ddlClass.DataBind();
ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetSection();
ddlSection.DataSource = ds.Tables[0];
ddlSection.DataTextField = "SectionName";
ddlSection.DataValueField = "SectionId";
ddlSection.DataBind();
ddlSection.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetMedium();
ddlMedium.DataSource = ds.Tables[0];
ddlMedium.DataTextField = "Language";
ddlMedium.DataValueField = "MediumID";
ddlMedium.DataBind();
ddlMedium.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetMedium();
ddlMed1.DataSource = ds.Tables[0];
ddlMed1.DataTextField = "Language";
ddlMed1.DataValueField = "MediumID";
ddlMed1.DataBind();
ddlMed1.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetMedium();
ddlMed2.DataSource = ds.Tables[0];
ddlMed2.DataTextField = "Language";
ddlMed2.DataValueField = "MediumID";
ddlMed2.DataBind();
ddlMed2.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetMedium();
ddlMed3.DataSource = ds.Tables[0];
ddlMed3.DataTextField = "Language";
ddlMed3.DataValueField = "MediumID";
ddlMed3.DataBind();
ddlMed3.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetBatch();
ddlBatch.DataSource = ds.Tables[0];
ddlBatch.DataTextField = "BatchNo";
ddlBatch.DataValueField = "BatchID";
ddlBatch.DataBind();
ddlBatch.Items.Insert(0, new ListItem("---Select---", "0"));
//ds = objCommon.GetGroups();
//ddlGroup.DataSource = ds.Tables[0];
//ddlGroup.DataTextField = "GroupName";
//ddlGroup.DataValueField = "GroupId";
//ddlGroup.DataBind();
//ddlGroup.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetState();
ddlstate.DataSource = ds.Tables[0];
ddlstate.DataTextField = "StateName";
ddlstate.DataValueField = "StateID";
ddlstate.DataBind();
ddlstate.Items.Insert(0, new ListItem("---Select---", "0"));
trCurHead.Style.Add("display", "none");
trCurBatch.Style.Add("display", "none");
trCurSection.Style.Add("display", "none");
if (Request.QueryString["ID"] != null)
{
ds = objCommon.GetBatch();
ddlCurBatch.DataSource = ds.Tables[0];
ddlCurBatch.DataTextField = "BatchNo";
ddlCurBatch.DataValueField = "BatchID";
ddlCurBatch.DataBind();
ddlCurBatch.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetGroups();
ddlCurGroup.DataSource = ds.Tables[0];
ddlCurGroup.DataTextField = "GroupName";
ddlCurGroup.DataValueField = "GroupId";
ddlCurGroup.DataBind();
ddlCurGroup.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetClasses();
ddlCurClass.DataSource = ds.Tables[0];
ddlCurClass.DataTextField = "ClassName";
ddlCurClass.DataValueField = "ClassID";
ddlCurClass.DataBind();
ddlCurClass.Items.Insert(0, new ListItem("---Select---", "0"));
ds = objCommon.GetSection();
ddlCurSection.DataSource = ds.Tables[0];
ddlCurSection.DataTextField = "SectionName";
ddlCurSection.DataValueField = "SectionId";
ddlCurSection.DataBind();
ddlCurSection.Items.Insert(0, new ListItem("---Select---", "0"));
trCurHead.Style.Add("display", "inline");
trCurBatch.Style.Add("display", "inline");
trCurSection.Style.Add("display", "inline");
StudID = Convert.ToInt32(Request.QueryString["ID"].ToString());
string path = Server.MapPath("..\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\") + StudID.ToString() + ".jpeg";
if (File.Exists(path))
{
imgStud.ImageUrl = "~\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\" + StudID.ToString() + ".jpeg";
}
path = Server.MapPath("..\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\") + StudID.ToString() + "_F.jpeg";
//if (File.Exists(path))
//{
// imgFather.ImageUrl = "~\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\" + StudID.ToString() + "_F.jpeg";
//}
path = Server.MapPath("..\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\") + StudID.ToString() + "_M.jpeg";
//if (File.Exists(path))
//{
// imgMother.ImageUrl = "~\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\" + StudID.ToString() + "_M.jpeg";
//}
path = Server.MapPath("..\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\") + StudID.ToString() + "_G.jpeg";
//if (File.Exists(path))
//{
// imgGuardian.ImageUrl = "~\\" + ConfigurationManager.AppSettings["StudentImg"] + "\\" + StudID.ToString() + "_G.jpeg";
//}
//Student Data
ds = objStud.GetStudent(StudID);
txtAdmissionNo.Text = ds.Tables[0].Rows[0]["AdmissionNo"].ToString();
txtHallTicket.Text = ds.Tables[0].Rows[0]["HallTicketNo"].ToString();
txtRank.Text = ds.Tables[0].Rows[0]["Rank"].ToString();
txtRegion.Text = ds.Tables[0].Rows[0]["Region"].ToString();
txtAdmissionmDate.Text = ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[0]["AdmissionDate"].ToString()).ToShortDateString());
txtfullname.Text = ds.Tables[0].Rows[0]["FullName"].ToString();
txtdob.Text = ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[0]["DOB"].ToString()).ToShortDateString());
ddlMotherTounge.SelectedValue = ds.Tables[0].Rows[0]["MotherTounge"].ToString();
txtMandal.Text = ds.Tables[0].Rows[0]["Mandal"].ToString();
txtNationality.Text = ds.Tables[0].Rows[0]["Nationality"].ToString();
ddlstate.SelectedValue = ds.Tables[0].Rows[0]["State"].ToString();
txtreligion.Text = ds.Tables[0].Rows[0]["Religion"].ToString();
ddlJoinType.SelectedValue = ds.Tables[0].Rows[0]["JoiningType"].ToString();
ddlPhysicallyChallanged.SelectedValue = ds.Tables[0].Rows[0]["PhysicallyChallenged"].ToString();
ddlcaste.SelectedValue = ds.Tables[0].Rows[0]["Caste"].ToString();
txtGamesPlayed.Text = ds.Tables[0].Rows[0]["Games"].ToString();
txtPrevSchoolTc.Text = ds.Tables[0].Rows[0]["PreviousSchoolTCNo"].ToString();
txtTcDate.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[0]["TCIssuedDate"].ToString()).ToShortDateString());
ddlClass.SelectedValue = ds.Tables[0].Rows[0]["AdmittedInClass"].ToString();
ddlMedium.SelectedValue = ds.Tables[0].Rows[0]["Medium"].ToString();
txtRollNo.Text = ds.Tables[0].Rows[0]["RollNoAlloted"].ToString();
ddlHouseAlloted.SelectedValue = ds.Tables[0].Rows[0]["HouseAlloted"].ToString();
ddlSection.SelectedValue = ds.Tables[0].Rows[0]["Section"].ToString();
ddlBatch.SelectedValue = ds.Tables[0].Rows[0]["BatchId"].ToString();
//ddlGroup.SelectedValue= ds.Tables[0].Rows[0]["Group"].ToString();
//txtAlphaCode.Text = ds.Tables[0].Rows[0]["AlphaCode"].ToString();
ddlCurBatch.SelectedValue = ds.Tables[0].Rows[0]["CurrentBatch"].ToString();
ddlCurClass.SelectedValue = ds.Tables[0].Rows[0]["CurrentClass"].ToString();
ddlCurSection.SelectedValue = ds.Tables[0].Rows[0]["CurrentSection"].ToString();
ddlCurGroup.SelectedValue = ds.Tables[0].Rows[0]["CurrentGroup"].ToString();
if (ds.Tables[0].Rows[0]["Gender"].ToString() == "1")
rbmale.Checked = true;
else
rbfemale.Checked = true;
//Student Identification
ds = objStud.GetStud_Identification(StudID);
txtMoles1.Text = ds.Tables[0].Rows[0]["Mole1"].ToString();
txtMoles2.Text = ds.Tables[0].Rows[0]["Mole2"].ToString();
txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
//Student Contact Information
ds = objStud.GetStud_ContactInfo(StudID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
txtfathername.Text = ds.Tables[0].Rows[0]["FatherName"].ToString();
txtaddr1.Text = ds.Tables[0].Rows[0]["FatherAddress"].ToString();
txtteloffice.Text = ds.Tables[0].Rows[0]["FatherPhone"].ToString();
ddlQualFather.SelectedValue = ds.Tables[0].Rows[0]["FatherQual"].ToString();
txtoccupation.Text = ds.Tables[0].Rows[0]["FatherOccup"].ToString();
//txtAnnualIncome.Text = ds.Tables[0].Rows[0]["FatherAnnualIncome"].ToString();
ddlFatherAnnualIncome.SelectedValue = ds.Tables[0].Rows[0]["FatherAnnualIncome"].ToString();
// txtMotherName.Text = ds.Tables[0].Rows[0]["MotherName"].ToString();
// txtAddress2.Text = ds.Tables[0].Rows[0]["MotherAddress"].ToString();
// txtPhoneMother.Text = ds.Tables[0].Rows[0]["MotherPhone"].ToString();
// ddlQualMother.SelectedValue = ds.Tables[0].Rows[0]["MotherQual"].ToString();
// txtOccupationMother.Text = ds.Tables[0].Rows[0]["MotherOccup"].ToString();
//// txtMotherAnnualIncome.Text = ds.Tables[0].Rows[0]["MotherAnnualIncome"].ToString();
// ddlMotherAnnualIncome.SelectedValue = ds.Tables[0].Rows[0]["MotherAnnualIncome"].ToString();
//txtguardname.Text = ds.Tables[0].Rows[0]["GuardianName"].ToString();
//txtguardaddress.Text = ds.Tables[0].Rows[0]["GuardianAddress"].ToString();
//txtguardtel.Text = ds.Tables[0].Rows[0]["GuardianPhone"].ToString();
//txtguardmobile.Text = ds.Tables[0].Rows[0]["GuardianMobile"].ToString();
}
}
//Student_Extra
ds = objStud.GetStud_Extra(StudID);
ddlECA.SelectedValue = ds.Tables[0].Rows[0]["ExtraCurricularID"].ToString();
txtJnvIssue.Text = ds.Tables[0].Rows[0]["TcIssuedByJnv"].ToString();
txtDateOfIssue.Text =ChangeDateFormat(Convert.ToDateTime( ds.Tables[0].Rows[0]["DateOfIssue"].ToString()).ToShortDateString());
//Student Education History
ds = objStud.GetStud_EducHistory(StudID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
txtPrevSchool1.Text = ds.Tables[0].Rows[i]["PrevSchoolName"].ToString();
txtFrom1.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Fromdate"].ToString()).ToShortDateString());
txtTo1.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Todate"].ToString()).ToShortDateString());
ddlMed1.SelectedValue = ds.Tables[0].Rows[i]["Medium"].ToString();
txtrem1.Text = ds.Tables[0].Rows[i]["Remarks"].ToString();
}
if (i == 1)
{
txtPrevSchool2.Text = ds.Tables[0].Rows[i]["PrevSchoolName"].ToString();
txtFrom2.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Fromdate"].ToString()).ToShortDateString());
txtto2.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Todate"].ToString()).ToShortDateString());
ddlMed2.SelectedValue = ds.Tables[0].Rows[i]["Medium"].ToString();
txtrem2.Text = ds.Tables[0].Rows[i]["Remarks"].ToString();
}
if (i == 2)
{
txtPrevSchool3.Text = ds.Tables[0].Rows[i]["PrevSchoolName"].ToString();
txtFrom3.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Fromdate"].ToString()).ToShortDateString());
txtto3.Text =ChangeDateFormat(Convert.ToDateTime(ds.Tables[0].Rows[i]["Todate"].ToString()).ToShortDateString());
ddlMed3.SelectedValue = ds.Tables[0].Rows[i]["Medium"].ToString();
txtrem3.Text = ds.Tables[0].Rows[i]["Remarks"].ToString();
}
}
}
}
btnsave.Text = "Update";
btnreset.Visible = false;
}
}
}
protected void ddlStudent_SelectedIndexChanged(object sender, EventArgs e)
{
BusinessLayer.StudentAdmissionBL objStudComm = new StudentAdmissionBL();
ds = new DataSet();
ds = objStudComm.GetStud_PhysicalState(Convert.ToInt32(ddlBatch.SelectedValue),Convert.ToInt32(ddlClasses.SelectedValue),Convert.ToInt32(ddlSections.SelectedValue), Convert.ToInt32(ddlStudent.SelectedValue));
if (ds.Tables[0].Rows.Count > 0)
{
txtHeight.Text = ds.Tables[0].Rows[0]["height"].ToString();
txtWeight.Text = ds.Tables[0].Rows[0]["weight"].ToString();
txtChest.Text = ds.Tables[0].Rows[0]["ChestMeasurement"].ToString();
txtEyesight.Text = ds.Tables[0].Rows[0]["eyesight"].ToString();
txtBloodgroup.Text = ds.Tables[0].Rows[0]["bloodGroup"].ToString();
txtDietPreferred.Text = ds.Tables[0].Rows[0]["dietPreferred"].ToString();
txtAilments.Text = ds.Tables[0].Rows[0]["ailments"].ToString();
txtAllergies.Text = ds.Tables[0].Rows[0]["allergies"].ToString();
txtChronocDisease.Text = ds.Tables[0].Rows[0]["ChronicDiseases"].ToString();
txtMedicalOPenion.Text = ds.Tables[0].Rows[0]["MedicalOpinion"].ToString();
btnAdd.Text = "Update";
}
else
{
txtHeight.Text = "";
txtWeight.Text = "";
txtChest.Text = "";
txtEyesight.Text = "";
txtBloodgroup.Text = "";
txtDietPreferred.Text = "";
txtAilments.Text = "";
txtAllergies.Text = "";
txtChronocDisease.Text = "";
txtMedicalOPenion.Text = "";
btnAdd.Text = "Save";
}
}