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