public void RemoveUserEducation(int UserEducationID)
{
PIKCV.DAL.UserEducation obj = new PIKCV.DAL.UserEducation();
obj.LoadByPrimaryKey(UserEducationID);
obj.MarkAsDeleted();
obj.Save();
}
public DataTable GetUserEducationDetail(int UserEducationID)
{
try
{
PIKCV.DAL.UserEducation objUserEducation = new PIKCV.DAL.UserEducation();
objUserEducation.LoadByPrimaryKey(UserEducationID);
return(objUserEducation.DefaultView.ToTable());
}
catch (Exception) {
return(null);
}
}
public DataTable GetUserEducations(int UserID, PIKCV.COM.EnumDB.EducationTypes EducationType, PIKCV.COM.EnumDB.LanguageID LanugageID, bool IsDeleted)
{
try
{
PIKCV.DAL.UserEducation objUserEducation = new PIKCV.DAL.UserEducation();
return(objUserEducation.GetUserEducation(UserID, (int)EducationType, (int)LanugageID, IsDeleted));
}
catch (Exception) {
return(null);
}
return(null);
}
public bool SaveEducation(int UserEducationID, int UserID, PIKCV.COM.EnumDB.EducationTypes EducationTypeCode, int SchoolID,
int EducationStatusID, DateTime StartDate, DateTime EndDate, string OtherSchool, int DepartmentID, string OtherDepartment, int CountryID,
int CityID, string OtherCity, string Degree, bool IsDeleted)
{
PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr();
try {
PIKCV.DAL.UserEducation obj = new PIKCV.DAL.UserEducation();
if (UserEducationID > 0)
{
obj.LoadByPrimaryKey(UserEducationID);
}
else
{
obj.AddNew();
}
obj.CityID = CityID;
obj.CountryID = CountryID;
string mDegree = Util.ReplaceStrForDB(Degree.Trim());
if (mDegree == "")
{
mDegree = "0";
}
obj.Degree = float.Parse(mDegree);
obj.DepartmentID = DepartmentID;
obj.EducationStatusID = EducationStatusID;
obj.EducationTypeCode = (int)EducationTypeCode;
if (EducationStatusID.ToString() == ((int)PIKCV.COM.EnumDB.EducationStates.Graduate).ToString())
{
obj.EndDate = EndDate;
}
else
{
obj.EndDate = StartDate.AddYears(-1);
}
obj.IsDeleted = IsDeleted;
obj.OtherCity = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(OtherCity));
obj.OtherDepartment = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(OtherDepartment));
obj.OtherSchool = PIKCV.COM.Util.ReturnEmptyString(Util.ReplaceStrForDB(OtherSchool));
obj.SchoolID = SchoolID;
obj.StartDate = StartDate;
obj.UserID = UserID;
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.Education)
{
ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.Education;
}
Tran.BeginTransaction();
ObjCV.Save();
obj.Save();
Tran.CommitTransaction();
return(true);
}
catch (Exception) {
Tran.RollbackTransaction();
PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset();
return(false);
}
}
