Exemplo n.º 1
0
 public DataTable GetUserSectors(int UserID, int LanguageID)
 {
     PIKCV.DAL.UserSectors obj = new PIKCV.DAL.UserSectors();
     return(obj.GetUserSectors(UserID, LanguageID));
 }
Exemplo n.º 2
0
        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);
            }
        }