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