public DataSet BindCasteCategory_DL(EWA_StudentProfile objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "FetchCasteCategory";
prmList[2] = "@OrgID";
prmList[3] = objEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_AdmissionForm");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
public int UpdateStudent(EWA_StudentProfile objEWA)
{
try
{
int flag = objDL.UpdateStudentProfile(objEWA);
return(flag);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet BindCasteCategory_BL(EWA_StudentProfile objEWA)
{
try
{
//DL_Admission objDL = new DL_Admission();
DataSet ds = objDL.BindCasteCategory_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
// Show Student Profile
#region Show Student Profile
public DataSet BL_ShowStudentProfile(EWA_StudentProfile objEWA)
{
try
{
DL_StudentProfile objDL = new DL_StudentProfile();
DataSet ds = objDL.DL_ShowStudentProfile(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
// Student View Profile Method
#region Student View Profile Method
public DataSet DL_ShowStudentProfile(EWA_StudentProfile objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "StudentProfile";
prmList[2] = "@OrgID";
prmList[3] = objEWA.OrgId;
prmList[4] = "@UserCode";
prmList[5] = objEWA.UserCode;
//prmList[4] = "@UserName";
//prmList[5] = objEWA.StudentUserName;
//prmList[6] = "@UserType";
//prmList[7] = Convert.ToString(objEWA.Usertype);
ds = ObjHelper.FillControl(prmList, "SP_Student");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
}
catch (Exception exp)
{
// GeneralErr(exp.Message.ToString());
throw exp;
}
return(ds);
}
private void ShowStudentProfile(EWA_StudentProfile objEWA)
{
DataSet ds;
try
{
objEWA.UserCode = Session["UserCode"].ToString();
objEWA.OrgId = Session["OrgId"].ToString();
ds = objBAL.BL_ShowStudentProfile(objEWA);
//variable declare
//For Name
string FirstName = ds.Tables[0].Rows[0]["FirstName"].ToString();
string MiddleName = ds.Tables[0].Rows[0]["MiddleName"].ToString();
string LastName = ds.Tables[0].Rows[0]["LastName"].ToString();
string FullName = FirstName + " " + MiddleName + " " + LastName;
//Personal Information
ViewState["UserCode"] = ds.Tables[0].Rows[0]["UserCode"].ToString();
//Personal Information
//For Id
lblRollNo.Text = ds.Tables[0].Rows[0]["RollNo"].ToString();
lblGRNO.Text = ds.Tables[0].Rows[0]["GRNo"].ToString();
lblStudentName.Text = FullName;
lblGender.Text = ds.Tables[0].Rows[0]["Gender"].ToString();
lblBirthDate.Text = ds.Tables[0].Rows[0]["BirthDate"].ToString();
lblBloodGroup.Text = ds.Tables[0].Rows[0]["BloodGroup"].ToString();
lblMobileNo.Text = ds.Tables[0].Rows[0]["Mobile"].ToString();
lblStudentEmail.Text = ds.Tables[0].Rows[0]["EMail"].ToString();
lblNationality.Text = ds.Tables[0].Rows[0]["Nationality"].ToString();
lblHandicaped.Text = ds.Tables[0].Rows[0]["Handicap"].ToString();
lblReligion.Text = ds.Tables[0].Rows[0]["Religion"].ToString();
lblCasteCategory.Text = ds.Tables[0].Rows[0]["CasteCategoryName"].ToString();
lblCaste.Text = ds.Tables[0].Rows[0]["Caste"].ToString();
lblSubCaste.Text = ds.Tables[0].Rows[0]["SubCaste"].ToString();
byte[] btImage = null;
var _photo = ds.Tables[0].Rows[0]["Photo"].ToString();
if (ds.Tables[0].Rows[0]["Photo"] == null || _photo == "")
{
}
else
{
btImage = (byte[])ds.Tables[0].Rows[0]["Photo"];
string base64String = Convert.ToBase64String(btImage, 0, btImage.Length);
img_StudentImage.ImageUrl = "data:image/png;base64," + base64String;
img_StudentImage.Visible = true;
}
//lblCourse.Text = db.getDbstatus_Value("SELECT tblCourse.CourseName FROM tblCourse INNER JOIN tblStudent ON tblCourse.CourseId = tblStudent.CourseId WHERE (tblCourse.OrgId = '" + Session["OrgId"].ToString() + "') AND (tblStudent.UserCode = '" + Session["UserCode"].ToString() + "')");
// lblCourse.Text = ds.Tables[0].Rows[0]["CourseName"].ToString(); //db.getDbstatus_Value("SELECT tblCourse.CourseName FROM tblCourse INNER JOIN tblStudent ON tblCourse.CourseId = tblStudent.CourseId WHERE (tblCourse.OrgId = '" + Session["OrgId"].ToString() + "') AND (tblStudent.UserCode = '" + Session["UserCode"].ToString() + "')");
//Contact Information
lblAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
//country= db.getDbstatus_Value("SELECT Country.County FROM Country INNER JOIN tblStudent ON Country.CountryId = tblStudent.Country WHERE tblStudent.UserCode = '"+Session["UserCode"].ToString()+"' ");
lblStudentCountry.Text = ds.Tables[0].Rows[0]["Country"].ToString();// country.ToString();
//state = db.getDbstatus_Value("SELECT countryState.State FROM tblStudent INNER JOIN countryState ON tblStudent.State = countryState.StateId AND tblStudent.Country = countryState.CountryId WHERE tblStudent.UserCode = '" + Session["UserCode"].ToString() + "'");
lblStudentState.Text = ds.Tables[0].Rows[0]["State"].ToString();//state.ToString();
lblStudentDistrict.Text = ds.Tables[0].Rows[0]["District"].ToString();
lblStudentTaluka.Text = ds.Tables[0].Rows[0]["Taluka"].ToString();
//city = db.getDbstatus_Value(" select City from tblStudent WHERE UserCode = '" + Session["UserCode"].ToString() + "'");
// city = db.getDbstatus_Value("SELECT stateCity.City FROM stateCity INNER JOIN tblStudent ON Country.CityId = tblStudent.City WHERE tblStudent.UserCode = '" + Session["UserCode"].ToString() + "' ");
// lblStudentCity.Text = city.ToString();
lblStudentCity.Text = ds.Tables[0].Rows[0]["City"].ToString(); //city.ToString();
//lblStudentPinCode.Text = ds.Tables[0].Rows[0]["PinCode"].ToString();
lblBirthPlace.Text = ds.Tables[0].Rows[0]["BirthPlace"].ToString();
//Parent Information
lblParentName.Text = ds.Tables[0].Rows[0]["ParentName"].ToString();
lblMotherName.Text = ds.Tables[0].Rows[0]["MotherName"].ToString();
//lblParentMobileNo.Text = ds.Tables[0].Rows[0]["ParentMobile"].ToString();
//lblParentAddress.Text = ds.Tables[0].Rows[0]["ParentAddress"].ToString();
//lblParentCountry.Text = ds.Tables[0].Rows[0]["ParentCountry"].ToString();
//lblParentState.Text = ds.Tables[0].Rows[0]["ParentState"].ToString();
//lblParentDistrict.Text = ds.Tables[0].Rows[0]["ParentDistrict"].ToString();
//lblParentTaluka.Text = ds.Tables[0].Rows[0]["ParentTaluka"].ToString();
//lblParentCity.Text = ds.Tables[0].Rows[0]["ParentCity"].ToString();
//lblParentPinCode.Text = ds.Tables[0].Rows[0]["ParentPinCode"].ToString();
//lblParentMobileNo.Text = ds.Tables[0].Rows[0]["ParentMobile"].ToString();
//lblParentEmail.Text = ds.Tables[0].Rows[0]["ParentEMail"].ToString();
//Education Information
//lblLastClass.Text = ds.Tables[0].Rows[0]["LastClass"].ToString();
//lblLastInstitute.Text = ds.Tables[0].Rows[0]["LastInstitute"].ToString();
lblQualifiedExam.Text = ds.Tables[0].Rows[0]["QualifiedExam"].ToString();
//lblSeatNo.Text = ds.Tables[0].Rows[0]["SeatNo"].ToString();
//lblPassingMonth.Text = ds.Tables[0].Rows[0]["PassingMonth"].ToString();
//lblPassingYear.Text = ds.Tables[0].Rows[0]["PassingYear"].ToString();
//lblPercentage.Text = ds.Tables[0].Rows[0]["Percentage"].ToString();
//lblResult.Text = ds.Tables[0].Rows[0]["Result"].ToString();
//Academic Information
lblCourse.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
lblBranch.Text = ds.Tables[0].Rows[0]["BranchName"].ToString();
lblClass.Text = ds.Tables[0].Rows[0]["ClassName"].ToString();
//lblDivision.Text = ds.Tables[0].Rows[0]["DivisionName"].ToString();
lblAcademicYear.Text = ds.Tables[0].Rows[0]["AcademicYear"].ToString();
//lblSport.Text = ds.Tables[0].Rows[0]["SportName"].ToString();
//lblLevelPlayed.Text = ds.Tables[0].Rows[0]["AdharNo"].ToString();
lblAdharNo.Text = ds.Tables[0].Rows[0]["AdharNO"].ToString();
//Other Information
// lblIFSCCode.Text = ds.Tables[0].Rows[0]["IFSCCode"].ToString();
//if (ds.Tables[0].Rows[0]["Signature"] == null)
//{
//}
//else
//{
// byte[] btSign = null;
// btSign = (byte[])ds.Tables[0].Rows[0]["Signature"];
// string base64String = Convert.ToBase64String(btSign, 0, btSign.Length);
// img_StudentSign.ImageUrl = "data:image/png;base64," + base64String;
// img_StudentSign.Visible = true;
//}
//string Photo1 = ds.Tables[0].Rows[0]["Photo"].ToString();
//if (Photo1 != null && Photo1 != "")
//{
// Byte[] bytes = (Byte[])ds.Tables[0].Rows[0]["Photo"];
// string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
// img_StudentImage.ImageUrl = "data:image/png;base64," + base64String;
// img_StudentImage.Visible = true;
//}
}
catch (Exception exp)
{
//GeneralErr(exp.Message.ToString());
//msgBox.ShowMessage("Proper Inserted Data Or Photo Properly !!!", "Saved", CMS.UserControls.MessageBox.MessageStyle.Successfull);
// msgBox.ShowMessage("Improper Data !!!", "Saved", CMS.UserControls.MessageBox.MessageStyle.Successfull);
}
}
// Save Update Form
#region Update
private void UpdateDetails(string strAction)
{
try
{
EWA_StudentProfile objEWA = new EWA_StudentProfile();
objEWA.Action = strAction.ToString();
objEWA.UserCode = ViewState["UserCode"].ToString();
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.StudentId = txtStudentId.Text.Trim();
objEWA.GRNo = txtGRNO.Text.Trim();
objEWA.FirstName = txtFirstName.Text;
objEWA.MiddleName = txtMiddleName.Text;
objEWA.LastName = txtLastName.Text;
objEWA.Gender = rbtGender.SelectedValue.ToString();
objEWA.BirthDate = txtBirthDate.Text;
objEWA.BirthPlace = txtBirthPlace.Text;
objEWA.StudentMobile = txtMobileNo.Text;
objEWA.StudentEMail = txtStudentEmail.Text;
objEWA.BloodGroup = txtBloodGroup.Text;
objEWA.Handicaped = txtHandicaped.Text;
//objEWA.MarriedStatus = rbtMarriedStatus.SelectedValue.ToString();
objEWA.Religion = ddlReligion.SelectedItem.ToString();
objEWA.CasteCategoryId = ddlCasteCategory.SelectedValue.ToString();
objEWA.FeesCategoryId = ddlFeesCategory.SelectedValue.ToString();
objEWA.SubCaste = txtSubCaste.Text;
objEWA.StudentAddress = txtAddress.Text;
objEWA.StudentCountry = ddlStudentCountry.SelectedValue;
objEWA.StudentState = ddlStudentState.SelectedValue;
objEWA.StudentDistrict = ddlStudentDistrict.SelectedValue;
objEWA.StudentTaluka = txtStudentTaluka.Text;
objEWA.StudentCity = txtStudentCity.Text;
objEWA.AdharNo = txtAdharNo.Text;
// Panel Parent information
//objEWA.ParentName = txtParentName.Text;
//objEWA.MotherName = txtMotherName.Text;
//objEWA.ParentAddress = txtParentAddress.Text;
//objEWA.ParentCountry = ddlParentCountry.SelectedValue;
//objEWA.ParentState = ddlParentState.SelectedValue;
//objEWA.ParentDistrict = ddlStudentDistrict.SelectedValue;
//objEWA.ParentTaluka = txtParentTaluka.Text;
//objEWA.ParentPinCode = txtParentPinCode.Text;
//objEWA.ParentMobile = txtParentMobileNo.Text;
//objEWA.ParentEmail = txtParentEmail.Text;
//// Panel Last Institute information
//objEWA.LastClass = txtLastClass.Text;
//objEWA.LastInstitute = txtLastInstitute.Text;
//objEWA.LastQualifiedExam = txtQualifiedExam.Text;
// objEWA.SeatNo = txtSeatNo.Text;
// objEWA.PassingMonth = txtPassingMonth.Text;
// objEWA.PassingYear = txtPassingYear.Text;
// objEWA.Percentage = txtPercentage.Text;
// objEWA.Result = txtResult.Text;
//objEWA.BankName= txtBankName.Text;
// objEWA.Branch= txtBranch1.Text ;
// objEWA.IFSCCode= txtIFSCCode.Text ;
// objEWA.BankAccountNo = txtAccountNo.Text;
// objEWA.TcNo = txtTcNo.Text;
// objEWA.SportId = ddlSport.SelectedValue.ToString();
//objEWA.AdharNo = txtAdharNo.Text;
// Iamage Store
int length = 0;
byte[] imgSignbyte = null;
byte[] imgPhotobyte = null;
if (fileupload_StudentPhoto.HasFile)
{
length = fileupload_StudentPhoto.PostedFile.ContentLength;
imgPhotobyte = new byte[length];
HttpPostedFile img1 = fileupload_StudentPhoto.PostedFile;
img1.InputStream.Read(imgPhotobyte, 0, length);
ViewState["StudentPhoto"] = imgPhotobyte;
string base64String = Convert.ToBase64String(imgPhotobyte, 0, imgPhotobyte.Length);
img_StudentImage.ImageUrl = "data:image/png;base64," + base64String;
}
objEWA.StudentPhoto = (byte[])ViewState["StudentPhoto"];
//if (fileupload_StudentSign.HasFile)
//{
// length = fileupload_StudentSign.PostedFile.ContentLength;
// imgSignbyte = new byte[length];
// HttpPostedFile img1 = fileupload_StudentSign.PostedFile;
// img1.InputStream.Read(imgSignbyte, 0, length);
// ViewState["StudentSign"] = imgSignbyte;
//}
//objEWA.StudentSign = (byte[])ViewState["StudentSign"];
int flag = objBAL.UpdateStudent(objEWA);
if (flag > 0)
{
if (strAction == "Update")
{
_strAction = "Record Updated Successfully!!!";
msgBox.ShowMessage("Record Updated Successfully !!!", "Updated", UserControls.MessageBox.MessageStyle.Successfull);
}
}
}
catch (Exception exp)
{
//throw exp;
}
}
private void ShowStudentProfile(EWA_StudentProfile objEWA)
{
DataSet ds;
try
{
objEWA.UserCode = Session["UserCode"].ToString();
objEWA.OrgId = Session["OrgId"].ToString();
ds = objBAL.BL_ShowStudentProfile(objEWA);
ViewState["UserCode"] = ds.Tables[0].Rows[0]["UserCode"].ToString();
//Personal Information
txtStudentId.Text = ds.Tables[0].Rows[0]["SaralId"].ToString();
txtGRNO.Text = ds.Tables[0].Rows[0]["GRNo"].ToString();
txtFirstName.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
txtMiddleName.Text = ds.Tables[0].Rows[0]["MiddleName"].ToString();
txtLastName.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
rbtGender.SelectedValue = ds.Tables[0].Rows[0]["Gender"].ToString();
txtBirthDate.Text = ds.Tables[0].Rows[0]["BirthDate"].ToString();
txtBirthPlace.Text = ds.Tables[0].Rows[0]["BirthPlace"].ToString();
txtBloodGroup.Text = ds.Tables[0].Rows[0]["BloodGroup"].ToString();
txtRollNo.Text = ds.Tables[0].Rows[0]["StudentId"].ToString();
txtMobileNo.Text = ds.Tables[0].Rows[0]["Mobile"].ToString();
txtStudentEmail.Text = ds.Tables[0].Rows[0]["EMail"].ToString();
//rbtMarriedStatus.SelectedValue = ds.Tables[0].Rows[0]["MaritalStatus"].ToString();
txtNationality.Text = ds.Tables[0].Rows[0]["Nationality"].ToString();
txtHandicaped.Text = ds.Tables[0].Rows[0]["Handicap"].ToString();
ddlReligion.Text = ds.Tables[0].Rows[0]["Religion"].ToString();
ddlCasteCategory.SelectedValue = ds.Tables[0].Rows[0]["CasteCategoryId"].ToString();
ddlFeesCategory.SelectedValue = ds.Tables[0].Rows[0]["FeesCategory"].ToString();
txtSubCaste.Text = ds.Tables[0].Rows[0]["SubCaste"].ToString();
//byte[] btImage;
//if (ds.Tables[0].Rows[0]["Photo"] ==System.DBNull.Value)
//{
// ds.Tables[0].Rows[0]["Photo"] = img_StudentImage.ImageUrl;
//}
//else
//{
// btImage = (byte[])ds.Tables[0].Rows[0]["Photo"];
// string base64String = Convert.ToBase64String(btImage, 0, btImage.Length);
// img_StudentImage.ImageUrl = "data:image/png;base64," + base64String;
// img_StudentImage.Visible = true;
//}
//if (ds.Tables[0].Rows[0]["Signature"] == null)
//{
// ds.Tables[0].Rows[0]["Signature"] = img_StudentSign.ImageUrl;
//}
//else
//{
// byte[] btSign;
// btSign = (byte[])ds.Tables[0].Rows[0]["Signature"];
// string base64String = Convert.ToBase64String(btSign, 0, btSign.Length);
// img_StudentSign.ImageUrl = "data:image/png;base64," + base64String;
// img_StudentSign.Visible = true;
//}
//Contact Information
txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
// ddlStudentCountry.Items.FindByText(ds.Tables[0].Rows[0]["Country"].ToString()).Selected = true;
txtStudentTaluka.Text = ds.Tables[0].Rows[0]["Taluka"].ToString();
//string city;
//city = ds.Tables[0].Rows[0]["City"].ToString();
txtStudentCity.Text = ds.Tables[0].Rows[0]["City"].ToString();//db.getDbstatus_Value("select City from stateCity where CityId='" + city + "'");
//txtStudentPinCode.Text = ds.Tables[0].Rows[0]["PinCode"].ToString();
//Parent Information
//txtParentName.Text = ds.Tables[0].Rows[0]["ParentName"].ToString();
//txtMotherName.Text = ds.Tables[0].Rows[0]["MotherName"].ToString();
// txtParentMobileNo.Text = ds.Tables[0].Rows[0]["ParentMobile"].ToString();
// txtParentAddress.Text = ds.Tables[0].Rows[0]["ParentAddress"].ToString();
//// ddlParentCountry.Items.FindByText( ds.Tables[0].Rows[0]["ParentCountry"].ToString()).Selected=true;
// txtParentTaluka.Text = ds.Tables[0].Rows[0]["ParentTaluka"].ToString();
// txtParentCity.Text = ds.Tables[0].Rows[0]["ParentCity"].ToString();
// txtParentPinCode.Text = ds.Tables[0].Rows[0]["ParentPinCode"].ToString();
// txtParentMobileNo.Text = ds.Tables[0].Rows[0]["ParentMobile"].ToString();
// txtParentEmail.Text = ds.Tables[0].Rows[0]["ParentEMail"].ToString();
// //Education Information
// txtLastClass.Text = ds.Tables[0].Rows[0]["LastClass"].ToString();
//txtLastInstitute.Text = ds.Tables[0].Rows[0]["LastInstitute"].ToString();
//txtQualifiedExam.Text = ds.Tables[0].Rows[0]["QualifiedExam"].ToString();
//txtSeatNo.Text = ds.Tables[0].Rows[0]["SeatNo"].ToString();
//txtPassingMonth.Text = ds.Tables[0].Rows[0]["PassingMonth"].ToString();
//txtPassingYear.Text = ds.Tables[0].Rows[0]["PassingYear"].ToString();
//txtPercentage.Text = ds.Tables[0].Rows[0]["Percentage"].ToString();
//txtResult.Text = ds.Tables[0].Rows[0]["Result"].ToString();
//Academic Information
txtCourse.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
txtBranch1.Text = ds.Tables[0].Rows[0]["BranchName"].ToString();
txtClass.Text = ds.Tables[0].Rows[0]["ClassName"].ToString();
//txtDivision.Text = ds.Tables[0].Rows[0]["DivisionName"].ToString();
txtAcademicYear.Text = ds.Tables[0].Rows[0]["AcademicYear"].ToString();
//ddlSport.SelectedValue=ds.Tables[0].Rows[0]["SportId"].ToString();
txtAdharNo.Text = ds.Tables[0].Rows[0]["AdharNo"].ToString();
ddlStudentCountry.SelectedValue = ds.Tables[0].Rows[0]["CountryID"].ToString();
Bind_ddlState();
ddlStudentState.SelectedValue = ds.Tables[0].Rows[0]["StateId"].ToString();
Bind_ddlCity();
ddlStudentDistrict.SelectedValue = ds.Tables[0].Rows[0]["DistrictId"].ToString();
//Other Information
//txtBankName.Text = ds.Tables[0].Rows[0]["BankName"].ToString();
////txtBranch.Text = ds.Tables[0].Rows[0]["Branch"].ToString();
//txtIFSCCode.Text = ds.Tables[0].Rows[0]["IFSCCode"].ToString();
//txtAccountNo.Text = ds.Tables[0].Rows[0]["BankAccountNo"].ToString();
}
catch (Exception exp)
{
// throw exp;
}
}
public int UpdateStudentProfile(EWA_StudentProfile objEWA)
{
try
{
SqlCommand cmd = new SqlCommand("SP_Student", con);
cmd.CommandType = CommandType.StoredProcedure;
// Panel Personal Information
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@UserCode", objEWA.UserCode);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@GRNo", objEWA.GRNo);
cmd.Parameters.AddWithValue("@StudentId", objEWA.StudentId);
cmd.Parameters.AddWithValue("@FirstName", objEWA.FirstName);
cmd.Parameters.AddWithValue("@MiddleName", objEWA.MiddleName);
cmd.Parameters.AddWithValue("@LastName", objEWA.LastName);
cmd.Parameters.AddWithValue("@Gender", objEWA.Gender);
cmd.Parameters.AddWithValue("@BirthDate", objEWA.BirthDate);
cmd.Parameters.AddWithValue("@BirthPlace", objEWA.BirthPlace);
cmd.Parameters.AddWithValue("@Address", objEWA.StudentAddress);
cmd.Parameters.AddWithValue("@Country", objEWA.StudentCountry);
cmd.Parameters.AddWithValue("@State", objEWA.StudentState);
cmd.Parameters.AddWithValue("@District", objEWA.StudentDistrict);
cmd.Parameters.AddWithValue("@Taluka", objEWA.StudentTaluka);
cmd.Parameters.AddWithValue("@City", objEWA.StudentCity);
//cmd.Parameters.AddWithValue("@PinCode", objEWA.StudentPincode);
cmd.Parameters.AddWithValue("@Mobile", objEWA.StudentMobile);
cmd.Parameters.AddWithValue("@EMail", objEWA.StudentEMail);
cmd.Parameters.AddWithValue("@Nationality", objEWA.Nationality);
cmd.Parameters.AddWithValue("@AdharNo", objEWA.AdharNo);
cmd.Parameters.AddWithValue("@BloodGroup", objEWA.BloodGroup);
cmd.Parameters.AddWithValue("@Religion", objEWA.Religion);
cmd.Parameters.AddWithValue("@CasteCategoryId", objEWA.CasteCategoryId);
cmd.Parameters.AddWithValue("@FeesCategoryId", objEWA.FeesCategoryId);
cmd.Parameters.AddWithValue("@SubCaste", objEWA.SubCaste);
cmd.Parameters.AddWithValue("@Handicaped", objEWA.Handicaped);
// Panel Parent Info
cmd.Parameters.AddWithValue("@ParentName", objEWA.ParentName);
cmd.Parameters.AddWithValue("@MotherName", objEWA.MotherName);
//cmd.Parameters.AddWithValue("@ParentAddress", objEWA.ParentAddress);
//cmd.Parameters.AddWithValue("@ParentCountry", objEWA.ParentCountry);
//cmd.Parameters.AddWithValue("@ParentState", objEWA.ParentState);
//cmd.Parameters.AddWithValue("@ParentDistrict", objEWA.ParentDistrict);
//cmd.Parameters.AddWithValue("@ParentTaluka", objEWA.ParentTaluka);
//cmd.Parameters.AddWithValue("@ParentCity", objEWA.ParentCity);
//cmd.Parameters.AddWithValue("@ParentPincode", objEWA.ParentPinCode);
//cmd.Parameters.AddWithValue("@ParentMobile", objEWA.ParentMobile);
//cmd.Parameters.AddWithValue("@ParentEMail", objEWA.ParentEmail);
//Panel Education Info
//cmd.Parameters.AddWithValue("@LastClass", objEWA.LastClass);
cmd.Parameters.AddWithValue("@LastInstitute", objEWA.LastInstitute);
cmd.Parameters.AddWithValue("@QualifiedExam", objEWA.LastQualifiedExam);
//cmd.Parameters.AddWithValue("@SeatNo", objEWA.SeatNo);
//cmd.Parameters.AddWithValue("@PassingMonth", objEWA.PassingMonth);
//cmd.Parameters.AddWithValue("@PassingYear", objEWA.PassingYear);
//cmd.Parameters.AddWithValue("@Percentage", objEWA.Percentage);
//cmd.Parameters.AddWithValue("@Result", objEWA.Result);
//cmd.Parameters.AddWithValue("@TcNo", objEWA.TcNo);
//cmd.Parameters.AddWithValue("@BankName", objEWA.BankName);
//cmd.Parameters.AddWithValue("@Branch", objEWA.Branch);
//cmd.Parameters.AddWithValue("@IFSCCode", objEWA.IFSCCode);
//cmd.Parameters.AddWithValue("@BankAccountNo", objEWA.BankAccountNo);
//cmd.Parameters.AddWithValue("@Signature", objEWA.StudentSign);
cmd.Parameters.AddWithValue("@Photo", objEWA.StudentPhoto);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception exp)
{
throw exp;
}
}
private void ShowStudentProfile(EWA_StudentProfile objEWA)
{
DataSet ds;
try
{
objEWA.UserCode = Session["StusUserCode"].ToString();
objEWA.OrgId = Session["OrgId"].ToString();
ds = objBAL.BL_ShowStudentProfile(objEWA);
ViewState["UserCode"] = ds.Tables[0].Rows[0]["UserCode"].ToString();
//Personal Information
txtStudentId.Text = ds.Tables[0].Rows[0]["SaralId"].ToString();
txtGRNO.Text = ds.Tables[0].Rows[0]["GRNo"].ToString();
txtFirstName.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
txtMiddleName.Text = ds.Tables[0].Rows[0]["MiddleName"].ToString();
txtLastName.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
rbtGender.SelectedValue = ds.Tables[0].Rows[0]["Gender"].ToString();
txtBirthDate.Text = ds.Tables[0].Rows[0]["BirthDate"].ToString();
txtBirthPlace.Text = ds.Tables[0].Rows[0]["BirthPlace"].ToString();
txtBloodGroup.Text = ds.Tables[0].Rows[0]["BloodGroup"].ToString();
txtRollNo.Text = ds.Tables[0].Rows[0]["StudentId"].ToString();
txtMobileNo.Text = ds.Tables[0].Rows[0]["Mobile"].ToString();
txtStudentEmail.Text = ds.Tables[0].Rows[0]["EMail"].ToString();
//rbtMarriedStatus.SelectedValue = ds.Tables[0].Rows[0]["MaritalStatus"].ToString();
txtNationality.Text = ds.Tables[0].Rows[0]["Nationality"].ToString();
txtHandicaped.Text = ds.Tables[0].Rows[0]["Handicap"].ToString();
ddlReligion.Text = ds.Tables[0].Rows[0]["Religion"].ToString();
ddlCasteCategory.SelectedValue = ds.Tables[0].Rows[0]["CasteCategoryId"].ToString();
ddlFeesCategory.SelectedValue = ds.Tables[0].Rows[0]["FeesCategory"].ToString();
txtSubCaste.Text = ds.Tables[0].Rows[0]["SubCaste"].ToString();
//Contact Information
txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
// ddlStudentCountry.Items.FindByText(ds.Tables[0].Rows[0]["Country"].ToString()).Selected = true;
txtStudentTaluka.Text = ds.Tables[0].Rows[0]["Taluka"].ToString();
//string city;
//city = ds.Tables[0].Rows[0]["City"].ToString();
txtStudentCity.Text = ds.Tables[0].Rows[0]["City"].ToString();//db.getDbstatus_Value("select City from stateCity where CityId='" + city + "'");
//Academic Information
txtCourse.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
txtBranch1.Text = ds.Tables[0].Rows[0]["BranchName"].ToString();
txtClass.Text = ds.Tables[0].Rows[0]["ClassName"].ToString();
txtAcademicYear.Text = ds.Tables[0].Rows[0]["AcademicYear"].ToString();
txtAdharNo.Text = ds.Tables[0].Rows[0]["AdharNo"].ToString();
ddlStudentCountry.SelectedValue = ds.Tables[0].Rows[0]["CountryID"].ToString();
Bind_ddlState();
ddlStudentState.SelectedValue = ds.Tables[0].Rows[0]["StateId"].ToString();
Bind_ddlCity();
ddlStudentDistrict.SelectedValue = ds.Tables[0].Rows[0]["DistrictId"].ToString();
//Other Information
//txtBankName.Text = ds.Tables[0].Rows[0]["BankName"].ToString();
////txtBranch.Text = ds.Tables[0].Rows[0]["Branch"].ToString();
//txtIFSCCode.Text = ds.Tables[0].Rows[0]["IFSCCode"].ToString();
//txtAccountNo.Text = ds.Tables[0].Rows[0]["BankAccountNo"].ToString();
}
catch (Exception exp)
{
// throw exp;
}
}