public DataTable GetUserReferences(int UserID)
{
PIKCV.DAL.UserReferences obj = new PIKCV.DAL.UserReferences();
obj.Where.UserID.Value = UserID;
obj.Query.Load();
return(obj.DefaultView.ToTable());
}
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);
}
}
public DataTable GetReferenceDetail(int UserReferenceID)
{
PIKCV.DAL.UserReferences obj = new PIKCV.DAL.UserReferences();
obj.LoadByPrimaryKey(UserReferenceID);
return(obj.DefaultView.ToTable());
}
