public static bool AddLibrariandetails(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.Insert(_SqlTrans);
objLib.LDAddressId = objAddress.ADAddressId;
objLib.Insert(_SqlTrans);
flag = true;
_SqlTrans.Commit();
}
catch (Exception ex)
{
flag = false;
_SqlTrans.Rollback();
}
finally
{
CHelper.CloseConnection(_connection);
}
return flag;
}
public static TMSAddressDetails Get(System.Int64 adAddressId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSAddressDetails instance;
instance = new TMSAddressDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSAddressDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, adAddressId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSAddressDetails ID:" + adAddressId.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
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 TMSAddressDetails[] Search(System.Int64?adAddressId, System.String adPermanentAddress, System.String adOfficeAddress, System.String adCommercialAddress, System.String adOptionalAddress, System.String adLandLineNo, System.String adOfficeNo, System.String adMobileNo, System.String adMobileOptionalNo, System.String adEmailId, System.String adPinCode, System.String adZipCode, System.Int64?adCountryId, System.Int64?adStateId, System.Int64?adCityId, System.DateTime?adAddressDate, System.Int32?adStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSAddressDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, adAddressId, adPermanentAddress, adOfficeAddress, adCommercialAddress, adOptionalAddress, adLandLineNo, adOfficeNo, adMobileNo, adMobileOptionalNo, adEmailId, adPinCode, adZipCode, adCountryId, adStateId, adCityId, adAddressDate, adStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSAddressDetails.MapFrom(ds));
}
public static TMSAddressDetails[] MapFrom(DataSet ds)
{
List <TMSAddressDetails> objects;
// Initialise Collection.
objects = new List <TMSAddressDetails>();
// Validation.
if (ds == null)
{
throw new ApplicationException("Cannot map to dataset null.");
}
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
{
return(objects.ToArray());
}
if (ds.Tables[TABLE_NAME] == null)
{
throw new ApplicationException("Cannot find table [dbo].[TMS_AddressDetails] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_AddressDetails] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSAddressDetails instance = new TMSAddressDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static TMSAddressDetails[] Search(TMSAddressDetails searchObject)
{
return(Search(searchObject.ADAddressId, searchObject.ADPermanentAddress, searchObject.ADOfficeAddress, searchObject.ADCommercialAddress, searchObject.ADOptionalAddress, searchObject.ADLandLineNo, searchObject.ADOfficeNo, searchObject.ADMobileNo, searchObject.ADMobileOptionalNo, searchObject.ADEmailId, searchObject.ADPinCode, searchObject.ADZipCode, searchObject.ADCountryId, searchObject.ADStateId, searchObject.ADCityId, searchObject.ADAddressDate, searchObject.ADStatus));
}
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 TMSAddressDetails[] Search(TMSAddressDetails searchObject)
{
return Search ( searchObject.ADAddressId, searchObject.ADPermanentAddress, searchObject.ADOfficeAddress, searchObject.ADCommercialAddress, searchObject.ADOptionalAddress, searchObject.ADLandLineNo, searchObject.ADOfficeNo, searchObject.ADMobileNo, searchObject.ADMobileOptionalNo, searchObject.ADEmailId, searchObject.ADPinCode, searchObject.ADZipCode, searchObject.ADCountryId, searchObject.ADStateId, searchObject.ADCityId, searchObject.ADAddressDate, searchObject.ADStatus);
}
public static TMSAddressDetails[] MapFrom(DataSet ds)
{
List<TMSAddressDetails> objects;
// Initialise Collection.
objects = new List<TMSAddressDetails>();
// Validation.
if (ds == null)
throw new ApplicationException("Cannot map to dataset null.");
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
return objects.ToArray();
if (ds.Tables[TABLE_NAME] == null)
throw new ApplicationException("Cannot find table [dbo].[TMS_AddressDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_AddressDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSAddressDetails instance = new TMSAddressDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSAddressDetails Get(System.Int64 adAddressId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSAddressDetails instance;
instance = new TMSAddressDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSAddressDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, adAddressId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSAddressDetails ID:" + adAddressId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
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) { }
}
