public DataTable GetUserSectors(int UserID, int LanguageID) { PIKCV.DAL.UserSectors obj = new PIKCV.DAL.UserSectors(); return(obj.GetUserSectors(UserID, LanguageID)); }
public bool SaveEmploymentChooices(int UserID, ArrayList arrSelectedSectors, ArrayList arrSelectedPositions, PIKCV.COM.EnumDB.EmployeeTypes EmployeeType) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { PIKCV.DAL.UserSectors objSectors = new PIKCV.DAL.UserSectors(); PIKCV.DAL.UserPositions objPositions = new PIKCV.DAL.UserPositions(); PIKCV.DAL.UserCVs ObjCV = new PIKCV.DAL.UserCVs(); PIKCV.DAL.User ObjUser = new PIKCV.DAL.User(); objSectors.Where.UserID.Value = UserID; objPositions.Where.UserID.Value = UserID; objSectors.Query.Load(); objPositions.Query.Load(); Tran.BeginTransaction(); objSectors.DeleteAll(); objSectors.Save(); objPositions.DeleteAll(); objPositions.Save(); for (int i = 0; i < arrSelectedPositions.Count; i++) { objPositions.AddNew(); objPositions.UserID = UserID; objPositions.PositionID = Convert.ToInt32(arrSelectedPositions[i]); objPositions.Save(); } for (int i = 0; i < arrSelectedSectors.Count; i++) { objSectors.AddNew(); objSectors.UserID = UserID; objSectors.SectorID = Convert.ToInt32(arrSelectedSectors[i]); objSectors.Save(); } ObjCV.Where.UserID.Value = UserID; ObjCV.Query.Load(); ObjCV.ModifyDate = DateTime.Now; if (ObjCV.CvFocusCode < (int)PIKCV.COM.EnumDB.CVFocusCode.PlacementPreferences) { ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.PlacementPreferences; } ObjCV.Save(); ObjUser.LoadByPrimaryKey(UserID); ObjUser.EmployeeTypeCode = (int)EmployeeType; ObjUser.Save(); Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }