protected void BindAccountManagerDetails()
{
try
{
Int64 UserId = Convert.ToInt64(Session["UserId"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, 7, UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
Int64 FacultyId = Convert.ToInt64(dtFaculty.Rows[0]["FD_FacultyDetailsId"]);
DataTable dtAccount = TMSFacultyDetails.GetStaffFacultyDetails(FacultyId, 7, UserId).Tables[0];
if (dtAccount.Rows.Count > 0)
{
lblFullName.Text = dtAccount.Rows[0]["FD_FirstName"].ToString() + " " + dtAccount.Rows[0]["FD_MiddleName"].ToString() + " " + dtAccount.Rows[0]["FD_LastName"].ToString();
Image1.ImageUrl = dtAccount.Rows[0]["FD_Image"].ToString();
lblDOB.Text = String.Format("{0:dd MMM yyyy}", dtAccount.Rows[0]["FD_BirthDate"]);// (Convert.ToString(objstudappl.StdaDob))("MM/dd/yyyy");
lblNationality.Text = dtAccount.Rows[0]["FD_Nationality"].ToString();
lblGender.Text = dtAccount.Rows[0]["FD_Gender"].ToString();
lblMotherTongue.Text = dtAccount.Rows[0]["FD_MotherTounge"].ToString();
lblMedicalproblems.Text = dtAccount.Rows[0]["FD_MedicalProblem"].ToString();
lblBithPlace.Text = dtAccount.Rows[0]["FD_BirthPlace"].ToString();
lblBloodGroup.Text = dtAccount.Rows[0]["FD_BloodGroup"].ToString();
lblCaste.Text = dtAccount.Rows[0]["FD_Caste"].ToString();
lblSubcaste.Text = dtAccount.Rows[0]["FD_SubCaste"].ToString();
lblDOJ.Text = String.Format("{0:dd MMM yyyy}", dtAccount.Rows[0]["FD_JoiningDate"]);
lblHihestDegree.Text = dtAccount.Rows[0]["FD_HighestDegreeCompletd"].ToString();
lblCopleteYear.Text = dtAccount.Rows[0]["FD_CompletionDate"].ToString();
lblUniversity.Text = dtAccount.Rows[0]["FD_University"].ToString();
lblLastSchoolWas.Text = dtAccount.Rows[0]["FD_LastSchoolwas"].ToString();
lblLastSchoolFrom.Text = dtAccount.Rows[0]["FD_LastSchoolFromDate"].ToString();
if (lblLastSchoolFrom.Text != "")
{
string[] s = lblLastSchoolFrom.Text.Split(' ');
lblLastSchoolFrom.Text = String.Format("{0:dd MMM yyyy}", Convert.ToDateTime(s[0]));
}
lblLastSchoolTo.Text = dtAccount.Rows[0]["FD_LastSchoolToDate"].ToString();
if (lblLastSchoolTo.Text != "")
{
string[] s = lblLastSchoolTo.Text.Split(' ');
lblLastSchoolTo.Text = String.Format("{0:dd MMM yyyy}", Convert.ToDateTime(s[0]));
}
lblTotalExpInMonth.Text = dtAccount.Rows[0]["FD_ExperienceFrom"].ToString();
lblTotalExpInYear.Text = dtAccount.Rows[0]["FD_ExperienceTo"].ToString();
lblSpecialization.Text = dtAccount.Rows[0]["FD_SpecificExpertise"].ToString();
//***Mother Details
//***Residance Details
lblAddress.Text = dtAccount.Rows[0]["FacultyPerAdd"].ToString();
lblmobileNo.Text = dtAccount.Rows[0]["FacultyMobNo"].ToString();
lblResidencePhone.Text = dtAccount.Rows[0]["FacultyResNo"].ToString();
lblEmailID.Text = dtAccount.Rows[0]["FacultyEmailId"].ToString();
lblCountry.Text = dtAccount.Rows[0]["FacultyCountry"].ToString();
lblState.Text = dtAccount.Rows[0]["FacultyState"].ToString();
lblCity.Text = dtAccount.Rows[0]["FacultyCity"].ToString();
lblPin.Text = dtAccount.Rows[0]["FacultyPinCode"].ToString();
//***Residance Details
}
}
}
catch (Exception ex) { }
}
protected void BindAcountManagerPhoto()
{
try
{
Int64 UserId = Convert.ToInt64(Session["UserId"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, 7, UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
image1.ImageUrl = dtFaculty.Rows[0]["FD_Image"].ToString();
}
}
catch (Exception ex) { }
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Int64 UserId = Convert.ToInt64(Session["UserId"]);
//DataTable dtFaculty = TMSFacultyDetails.GetSearch(null, UserId, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1).Tables[0];
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, 7, UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
Int64 FacultyId = Convert.ToInt64(dtFaculty.Rows[0]["FD_FacultyDetailsId"]);
TMSFacultyDetails objFaculty = TMSFacultyDetails.Get(FacultyId);
if (objFaculty != null)
{
//objFaculty.FDImage = ImageE;
if (FileUpload1.PostedFile.FileName != "")
{
bool isExist = false;
string strFatherFileNameWithPath = FileUpload1.PostedFile.FileName;
string strFatherExtensionName = System.IO.Path.GetExtension(strFatherFileNameWithPath);
string strFatherFileName = System.IO.Path.GetFileName(strFatherFileNameWithPath).Replace(" ", "_");
if (strFatherExtensionName.Equals(".jpg") || strFatherExtensionName.Equals(".gif") || strFatherExtensionName.Equals(".png") || strFatherExtensionName.Equals(".jpeg") || strFatherExtensionName.Equals(".bmp"))
{
isExist = File.Exists(Server.MapPath(@"~\\UploadImages\\FacultyPhoto\\" + strFatherFileName));
string[] Name = strFatherFileName.Split('.');
string Fname = Name[0];
string ReplacFileName = Fname + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + strFatherExtensionName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(@"..\\UploadImages\\FacultyPhoto\\" + ReplacFileName));
objFaculty.FDImage = "../UploadImages/FacultyPhoto/" + ReplacFileName;
}
else
{
dvMsg.Visible = true;
lblMessage.Text = "Please Upload .jpg,.gif,.jpeg,.bmp File Only !";
dvMsg.Attributes.Add("class", "error_msg");
return;
}
}
objFaculty.Update();
Response.Redirect("ChangePhoto.aspx?msg=Photo is updated Successfully");
}
}
}
catch (Exception ex) { }
}
protected void BindTeacherDetails()
{
try
{
if ((Session["AccountID"] != null) && (Session["FacultyType"] != null))
{
Int64 UserId = Convert.ToInt64(Session["AccountID"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, Convert.ToInt64(Session["FacultyType"]), UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
if (dtFaculty.Rows[0]["FD_AgeProof"].ToString() != "AGEPROOF")
{
string[] dd = dtFaculty.Rows[0]["FD_AgeProof"].ToString().Split('/');
hyperAge.Text = dd[2].ToString();
hyperAge.NavigateUrl = dtFaculty.Rows[0]["FD_AgeProof"].ToString();
}
else
{
hyperAge.Text = dtFaculty.Rows[0]["FD_AgeProof"].ToString();
}
if (dtFaculty.Rows[0]["FD_Image"] != null)
{
string[] dd = dtFaculty.Rows[0]["FD_Image"].ToString().Split('/');
hyperPassphoto.Text = dd[3].ToString();
hyperPassphoto.NavigateUrl = dtFaculty.Rows[0]["FD_Image"].ToString();
}
if (dtFaculty.Rows[0]["FD_ReleavingLetter"].ToString() != "ReleavingLetter")
{
string[] dd = dtFaculty.Rows[0]["FD_ReleavingLetter"].ToString().Split('/');
hyperOleavingSchoolSertificate.Text = dd[2].ToString();
hyperOleavingSchoolSertificate.NavigateUrl = dtFaculty.Rows[0]["FD_ReleavingLetter"].ToString();
}
else
{
hyperOleavingSchoolSertificate.Text = dtFaculty.Rows[0]["FD_ReleavingLetter"].ToString();
}
}
}
}
catch (Exception ex) { }
}
protected void BindPrincipalDetails()
{
try
{
DataTable dt = null;
dt = TMSFacultyDetails.GetStaffFacultyDetails(null, 1, null).Tables[0];
if (dt.Rows.Count > 0)
{
ListStaff.DataSource = dt;
ListStaff.DataBind();
}
else
{
ListStaff.DataSource = null;
ListStaff.DataBind();
}
}
catch { }
}
protected void btnEdit_Click(object sender, EventArgs e)
{
try
{
btnSave.Text = "Update";
SectionEditProfile.Visible = true;
SectionViewProfile.Visible = false;
fillCountry();
BindState();
BindCity();
//fillQualification();
fillCompletedYear();
Int64 UserId = Convert.ToInt64(Session["UserId"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, 7, UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
Int64 FacultyId = Convert.ToInt64(dtFaculty.Rows[0]["FD_FacultyDetailsId"]);
TMSFacultyDetails objFaculty = TMSFacultyDetails.Get(FacultyId);
if (objFaculty != null)
{
txtFullName.Text = objFaculty.FDFirstName;
txtMiddleName.Text = objFaculty.FDMiddleName;
txtLatName.Text = objFaculty.FDLastName;
txtBithPlace.Text = objFaculty.FDBirthPlace;
txtDOB.Text = String.Format("{0:MM/dd/yyyy}", objFaculty.FDBirthDate);
ddlBloddGroup.SelectedValue = Convert.ToString(objFaculty.FDBloodGroup);
txtNationality.Text = objFaculty.FDNationality;
txtCaste.Text = objFaculty.FDCaste;
txtSubcaste.Text = objFaculty.FDSubCaste;
ddlGender.SelectedValue = objFaculty.FDGender;
txtMotherTongue.Text = objFaculty.FDMotherTongue;
txtMedicalproblems.Text = objFaculty.FDMedicalProblem;
if (objFaculty.FDJoiningDate != null)
{
txtDOJ.Text = String.Format("{0:MM/dd/yyyy}", objFaculty.FDJoiningDate);
}
if (objFaculty.FDHighestDegreeCompletd != null)
{
//ddlHighestDegree.SelectedValue = objFaculty.FDHighestDegreeCompletd;
txtHeighestDegree.Text = objFaculty.FDHighestDegreeCompletd.ToString();;
}
if (objFaculty.FDSpecificExpertise != "")
{
ddlSpeciallization.SelectedItem.Text = objFaculty.FDSpecificExpertise;
}
if (objFaculty.FDCompletionDate != "")
{
ddlCompletedYear.SelectedValue = objFaculty.FDCompletionDate;
}
txtUniversity.Text = objFaculty.FDUniversity;
txtLastSchoolWas.Text = objFaculty.FDLastSchoolwas;
if (objFaculty.FDLastSchoolFromDate != null)
{
txtLastSchoolFrom.Text = String.Format("{0:MM/dd/yyyy}", objFaculty.FDLastSchoolFromDate);
}
if (objFaculty.FDLastSchoolToDate != null)
{
txtLastSchoolTo.Text = String.Format("{0:MM/dd/yyyy}", objFaculty.FDLastSchoolToDate);
}
txtTotalExpInYear.Text = objFaculty.FDExperienceTo;
txtTotalExpInMonth.Text = objFaculty.FDExperienceFrom;
Int64 AddressId = Convert.ToInt64(objFaculty.FDAddressId);
TMSAddressDetails objAddress = TMSAddressDetails.Get(AddressId);
if (objAddress != null)
{
txtAddress.Text = objAddress.ADPermanentAddress;
txtmobileNo.Text = objAddress.ADMobileNo;
txtResidencePhone.Text = objAddress.ADLandLineNo;
txtPin.Text = objAddress.ADPinCode;
txtEmailID.Text = objAddress.ADEmailId;
ddlCountry.SelectedValue = objAddress.ADCountryId.ToString();
BindState();
ddlState.SelectedValue = objAddress.ADStateId.ToString();
BindCity();
ddlCity.SelectedValue = objAddress.ADCityId.ToString();
}
Image2.Visible = true;
Image2.ImageUrl = objFaculty.FDImage;
Session["Image"] = objFaculty.FDImage;
}
}
}
catch (Exception ex) { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string ImageE = EditGetImage();
if (ImageE == "Ext")
{
dvMsg.Visible = true;
lblMessage.Text = "InValid File Format";
dvMsg.Attributes.Add("class", "error_msg");
}
else
{
Int64 UserId = Convert.ToInt64(Session["UserId"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, 7, UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
Int64 FacultyId = Convert.ToInt64(dtFaculty.Rows[0]["FD_FacultyDetailsId"]);
TMSFacultyDetails objFaculty = TMSFacultyDetails.Get(FacultyId);
if (objFaculty != null)
{
objFaculty.FDFirstName = txtFullName.Text;
objFaculty.FDBirthPlace = txtBithPlace.Text;
objFaculty.FDBirthDate = Convert.ToDateTime(txtDOB.Text);
objFaculty.FDBloodGroup = ddlBloddGroup.SelectedValue;
objFaculty.FDNationality = txtNationality.Text;
objFaculty.FDCaste = txtCaste.Text;
objFaculty.FDSubCaste = txtSubcaste.Text;
objFaculty.FDGender = ddlGender.SelectedValue;
objFaculty.FDMotherTongue = txtMotherTongue.Text;
objFaculty.FDMedicalProblem = txtMedicalproblems.Text;
if (txtDOJ.Text != "")
{
objFaculty.FDJoiningDate = Convert.ToDateTime(txtDOJ.Text);
}
else
{
objFaculty.FDJoiningDate = null;
}
//objFaculty.FDHighestDegreeCompletd = ddlHighestDegree.SelectedValue;
objFaculty.FDHighestDegreeCompletd = txtHeighestDegree.Text;
objFaculty.FDSpecificExpertise = ddlSpeciallization.SelectedItem.Text;
objFaculty.FDCompletionDate = ddlCompletedYear.SelectedValue;
objFaculty.FDUniversity = txtUniversity.Text;
objFaculty.FDLastSchoolwas = txtLastSchoolWas.Text;
if (txtLastSchoolFrom.Text != "")
{
objFaculty.FDLastSchoolFromDate = Convert.ToDateTime(txtLastSchoolFrom.Text);
}
if (txtLastSchoolTo.Text != "")
{
objFaculty.FDLastSchoolToDate = Convert.ToDateTime(txtLastSchoolTo.Text);
}
objFaculty.FDExperienceTo = txtTotalExpInYear.Text;
objFaculty.FDExperienceFrom = txtTotalExpInMonth.Text;
objFaculty.FDImage = ImageE;
objFaculty.Update();
Int64 AddressId = Convert.ToInt64(objFaculty.FDAddressId);
TMSAddressDetails objAddressDetails = TMSAddressDetails.Get(AddressId);
if (objAddressDetails != null)
{
objAddressDetails.ADPermanentAddress = txtAddress.Text.Trim();
if (!string.IsNullOrEmpty(ddlCity.SelectedValue))
{
objAddressDetails.ADCityId = Convert.ToInt64(ddlCity.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlCountry.SelectedValue))
{
objAddressDetails.ADCountryId = Convert.ToInt64(ddlCountry.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlState.SelectedValue))
{
objAddressDetails.ADStateId = Convert.ToInt64(ddlState.SelectedValue);
}
objAddressDetails.ADEmailId = txtEmailID.Text.Trim();
objAddressDetails.ADMobileNo = txtmobileNo.Text.Trim();
objAddressDetails.ADPinCode = txtPin.Text.Trim();
objAddressDetails.ADLandLineNo = txtResidencePhone.Text;
objAddressDetails.Update();
}
TMSUserLogin objLogin = TMSUserLogin.Get(Convert.ToInt64(Session["UserId"]));
if (objLogin != null)
{
//objLogin.ULUserName = txtEmailID.Text.Trim();
objLogin.ULEmailId = txtEmailID.Text.Trim();
objLogin.Update();
}
BindAccountManagerDetails();
SectionEditProfile.Visible = false;
SectionViewProfile.Visible = true;
dvMsg.Visible = true;
lblMessage.Text = "Profile Is Updated Successfully";
dvMsg.Attributes.Add("class", "warring_msg");
}
}
}
}
catch (Exception ex) { }
}
protected void BindTeacherDetails()
{
try
{
Int64 UserId = Convert.ToInt64(Session["AccountID"]);
DataTable dtFaculty = TMSFacultyDetails.GetStaffFacultyDetails(null, Convert.ToInt64(Session["FacultyType"]), UserId).Tables[0];
if (dtFaculty.Rows.Count > 0)
{
lblFullName.Text = dtFaculty.Rows[0]["FD_FirstName"].ToString() + " " + dtFaculty.Rows[0]["FD_MiddleName"].ToString() + " " + dtFaculty.Rows[0]["FD_LastName"].ToString();
if (dtFaculty.Rows[0]["FD_Image"] != null)
{
imasdfdsg.ImageUrl = dtFaculty.Rows[0]["FD_Image"].ToString();
}
lblEduDetail.Text = dtFaculty.Rows[0]["FD_HighestDegreeCompletd"].ToString() + "-" + dtFaculty.Rows[0]["FD_SpecificExpertise"].ToString() + " " + dtFaculty.Rows[0]["FD_CompletionDate"].ToString();
lblAddress.Text = dtFaculty.Rows[0]["FacultyPerAdd"].ToString();
lblnationality.Text = dtFaculty.Rows[0]["FD_Nationality"].ToString();
lblgender.Text = dtFaculty.Rows[0]["FD_Gender"].ToString();
lblmotherLong.Text = dtFaculty.Rows[0]["FD_MotherTounge"].ToString();
lblmedicolprm.Text = dtFaculty.Rows[0]["FD_MedicalProblem"].ToString();
lblbirthPlace.Text = dtFaculty.Rows[0]["FD_BirthPlace"].ToString();
lblbloodgroup.Text = dtFaculty.Rows[0]["FD_BloodGroup"].ToString();
lblcast.Text = dtFaculty.Rows[0]["FD_Caste"].ToString();
lblsubcast.Text = dtFaculty.Rows[0]["FD_SubCaste"].ToString();
if (dtFaculty.Rows[0]["FD_HighestDegreeCompletd"].ToString() != "-1")
{
lblhighestDegree.Text = dtFaculty.Rows[0]["FD_HighestDegreeCompletd"].ToString();
}
if (dtFaculty.Rows[0]["FD_CompletionDate"].ToString() != "Select")
{
lblcomplicationDateofHigherDegree.Text = dtFaculty.Rows[0]["FD_CompletionDate"].ToString();
}
lbluniversity.Text = dtFaculty.Rows[0]["FD_University"].ToString();
if ((dtFaculty.Rows[0]["FD_ExperienceFrom"] != null) && (dtFaculty.Rows[0]["FD_ExperienceTo"] != null))
{
lblexpyears.Text = dtFaculty.Rows[0]["FD_ExperienceTo"].ToString() + " Year";
lblexperience.Text = dtFaculty.Rows[0]["FD_ExperienceTo"].ToString() + " Year" + " " + dtFaculty.Rows[0]["FD_ExperienceFrom"].ToString() + " Month";
}
else if ((dtFaculty.Rows[0]["FD_ExperienceFrom"] != null) && (dtFaculty.Rows[0]["FD_ExperienceTo"] == null))
{
lblexperience.Text = dtFaculty.Rows[0]["FD_ExperienceFrom"].ToString() + " Year";
lblexpyears.Text = dtFaculty.Rows[0]["FD_ExperienceFrom"].ToString() + " Year";
}
// lblspeciolisation.Text = dtFaculty.Rows[0]["FD_SpecificExpertise"].ToString();
if (dtFaculty.Rows[0]["ClassName"] != null)
{
string Classname = dtFaculty.Rows[0]["ClassName"].ToString();
if (Classname != "")
{
lblstandard.Text = Classname.Remove(Classname.Length - 1, 1);
}
}
if (dtFaculty.Rows[0]["SubjectName"] != null)
{
string SubjectName = dtFaculty.Rows[0]["SubjectName"].ToString();
if (SubjectName != "")
{
lblsubject.Text = SubjectName.Remove(SubjectName.Length - 1, 1);
}
}
// lblusingtransport.Text = dtFaculty.Rows[0]["FD_TransportStatus"].ToString();
}
}
catch (Exception ex) { }
}
