public bool RemoveUserLanguage(int UserLanguageID)
{
try
{
PIKCV.DAL.UserLanguages obj = new PIKCV.DAL.UserLanguages();
obj.LoadByPrimaryKey(UserLanguageID);
obj.MarkAsDeleted();
obj.Save();
return(true);
}
catch (Exception)
{
return(false);
}
}
public DataTable GetUserLanguages(int UserID, int LanguageID)
{
PIKCV.DAL.UserLanguages obj = new PIKCV.DAL.UserLanguages();
return(obj.GetUserLanguages(UserID, LanguageID));
}
public DataTable GetUserLanguageDetail(int UserLanguageID)
{
PIKCV.DAL.UserLanguages obj = new PIKCV.DAL.UserLanguages();
obj.LoadByPrimaryKey(UserLanguageID);
return(obj.DefaultView.ToTable());
}
public bool SaveUserLanguage(int UserLanguageID, int UserID, int ForeignLanguageID, int ReadLevelID, int WriteLevelID, int SpeakLevelID,
string PlaceLearned, int ForeignLanguageExamID, string ExamDegree)
{
PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr();
try
{
PIKCV.DAL.UserLanguages obj = new PIKCV.DAL.UserLanguages();
if (UserLanguageID > 0)
{
obj.LoadByPrimaryKey(UserLanguageID);
}
else
{
obj.AddNew();
}
obj.ForeignLanguageID = ForeignLanguageID;
obj.PlaceLearned = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(PlaceLearned));
obj.WriteLevelID = WriteLevelID;
obj.SpeakLevelID = SpeakLevelID;
obj.ReadLevelID = ReadLevelID;
obj.UserID = UserID;
obj.ForeignLanguageExamID = ForeignLanguageExamID;
string mExamDegree = Util.ReplaceStrForDB(ExamDegree.Trim());
if (mExamDegree == "")
{
mExamDegree = "0";
}
obj.ExamDegree = float.Parse(mExamDegree);
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.ComputerKnowledge)
{
ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.ComputerKnowledge;
}
Tran.BeginTransaction();
ObjCV.Save();
obj.Save();
Tran.CommitTransaction();
return(true);
}
catch (Exception)
{
Tran.RollbackTransaction();
PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset();
return(false);
}
}
