public bool SaveUserReference(int UserReferenceID, int UserID, string ReferenceName, string Company, string Phone, string Position) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { PIKCV.DAL.UserReferences obj = new PIKCV.DAL.UserReferences(); if (UserReferenceID > 0) { obj.LoadByPrimaryKey(UserReferenceID); } else { obj.AddNew(); } obj.UserID = UserID; obj.ReferenceName = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(ReferenceName)); obj.Company = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(Company)); obj.Phone = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(Phone.Trim())); obj.Position = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(Position)); PIKCV.DAL.UserCVs ObjCV = new PIKCV.DAL.UserCVs(); ObjCV.Where.UserID.Value = UserID; ObjCV.Query.Load(); if (ObjCV.RowCount < 1) { return(false); } ObjCV.ModifyDate = DateTime.Now; if (ObjCV.CvFocusCode < (int)PIKCV.COM.EnumDB.CVFocusCode.OtherChoices) { ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.OtherChoices; } Tran.BeginTransaction(); ObjCV.Save(); obj.Save(); Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }
public bool RemoveUserReference(int UserReferenceID) { try { PIKCV.DAL.UserReferences obj = new PIKCV.DAL.UserReferences(); obj.LoadByPrimaryKey(UserReferenceID); obj.MarkAsDeleted(); obj.Save(); return(true); } catch (Exception) { return(false); } }