public static bool UpdateLibrariandetails(TMSLibrianDetails objLib, TMSAddressDetails objAddress)
{
ConnectionHelper CHelper = new ConnectionHelper();
DbTransaction _SqlTrans = null;
SqlConnection _connection = null;;
bool flag = false;
try
{
_connection = CHelper.GetConnection();
_SqlTrans = _connection.BeginTransaction();
objAddress.Update(_SqlTrans);
objLib.LDAddressId = objAddress.ADAddressId;
objLib.Update(_SqlTrans);
flag = true;
_SqlTrans.Commit();
}
catch (Exception ex)
{
flag = false;
_SqlTrans.Rollback();
}
finally
{
CHelper.CloseConnection(_connection);
}
return(flag);
}
public static void Update(TMSAddressDetails tMSAddressDetails, DbTransaction transaction)
{
tMSAddressDetails.Update(transaction);
}
public static void Update(TMSAddressDetails tMSAddressDetails)
{
tMSAddressDetails.Update();
}
public static void Update(TMSAddressDetails tMSAddressDetails, DbTransaction transaction)
{
tMSAddressDetails.Update(transaction);
}
public static void Update(TMSAddressDetails tMSAddressDetails)
{
tMSAddressDetails.Update();
}
public static bool UpdateLibrariandetails(TMSLibrianDetails objLib, TMSAddressDetails objAddress)
{
ConnectionHelper CHelper = new ConnectionHelper();
DbTransaction _SqlTrans = null;
SqlConnection _connection = null; ;
bool flag = false;
try
{
_connection = CHelper.GetConnection();
_SqlTrans = _connection.BeginTransaction();
objAddress.Update(_SqlTrans);
objLib.LDAddressId = objAddress.ADAddressId;
objLib.Update(_SqlTrans);
flag = true;
_SqlTrans.Commit();
}
catch (Exception ex)
{
flag = false;
_SqlTrans.Rollback();
}
finally
{
CHelper.CloseConnection(_connection);
}
return flag;
}
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) { }
}
