public DataTable GetUserLabouringTypes(int UserID, int LanguageID)
{
PIKCV.DAL.UserLabouringTypes obj = new PIKCV.DAL.UserLabouringTypes();
return(obj.GetUserLabouringTypes(UserID, LanguageID));
}
public bool SavePlacementPreferences(int UserID, ArrayList arrSelectedCities, ArrayList arrSelectedCountries, bool HasTravelDifficulty, ArrayList arrLabouringTypes, bool IsSmoking)
{
PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr();
try
{
PIKCV.DAL.UserPlacementPreferences objPlacementPreferences = new PIKCV.DAL.UserPlacementPreferences();
PIKCV.DAL.UserCVs ObjCV = new PIKCV.DAL.UserCVs();
PIKCV.DAL.UserLabouringTypes objLabouringTypes = new PIKCV.DAL.UserLabouringTypes();
objPlacementPreferences.Where.UserID.Value = UserID;
objPlacementPreferences.Query.Load();
objLabouringTypes.Where.UserID.Value = UserID;
objLabouringTypes.Query.Load();
Tran.BeginTransaction();
objPlacementPreferences.DeleteAll();
objPlacementPreferences.Save();
objLabouringTypes.DeleteAll();
objLabouringTypes.Save();
objLabouringTypes = new PIKCV.DAL.UserLabouringTypes();
for (int i = 0; i < arrLabouringTypes.Count; i++)
{
objLabouringTypes.AddNew();
objLabouringTypes.UserID = UserID;
objLabouringTypes.LabouringTypeID = Convert.ToInt32(arrLabouringTypes[i]);
objLabouringTypes.Save();
}
for (int i = 0; i < arrSelectedCities.Count; i++)
{
objPlacementPreferences.AddNew();
objPlacementPreferences.UserID = UserID;
objPlacementPreferences.PlaceTypeCode = (int)PIKCV.COM.EnumDB.PlaceTypes.TurkeyCity;
if (Util.Left(arrSelectedCities[i].ToString(), 2) == "__")
{
objPlacementPreferences.OtherPlace = arrSelectedCities[i].ToString().Replace("__", "");
objPlacementPreferences.PlaceID = 0;
}
else
{
objPlacementPreferences.OtherPlace = " ";
objPlacementPreferences.PlaceID = Convert.ToInt32(arrSelectedCities[i]);
}
objPlacementPreferences.Save();
}
for (int i = 0; i < arrSelectedCountries.Count; i++)
{
objPlacementPreferences.AddNew();
objPlacementPreferences.UserID = UserID;
objPlacementPreferences.PlaceTypeCode = (int)PIKCV.COM.EnumDB.PlaceTypes.Country;
objPlacementPreferences.PlaceID = Convert.ToInt32(arrSelectedCountries[i]);
objPlacementPreferences.OtherPlace = " ";
objPlacementPreferences.Save();
}
ObjCV.Where.UserID.Value = UserID;
ObjCV.Query.Load();
if (ObjCV.CvFocusCode < (int)PIKCV.COM.EnumDB.CVFocusCode.ProhibitedCompanies)
{
ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.ProhibitedCompanies;
}
ObjCV.ModifyDate = DateTime.Now;
ObjCV.HasTravelDifficulty = HasTravelDifficulty;
ObjCV.IsSmoking = IsSmoking;
ObjCV.Save();
Tran.CommitTransaction();
return(true);
}
catch (Exception)
{
Tran.RollbackTransaction();
PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset();
return(false);
}
}
