public bool LoginControl(string Email, string Password)
{
Email = Util.ClearString(Email.Trim());
Password = Encryption.Encrypt(CARETTA.COM.Util.ClearString(Password.Trim()));
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.Where.Email.Value = Email;
objUser.Where.Password.Value = Password;
objUser.Where.IsEmailConfirmed.Value = true;
objUser.Where.IsActive.Value = true;
objUser.Where.IsDeleted.Value = false;
objUser.Query.Load();
if (!objUser.EOF)
{
this.m_UserID = objUser.UserID;
this.m_ActivationNumber = objUser.ActivationNumber;
this.m_CreateDate = objUser.CreateDate;
this.m_Email = objUser.Email;
this.m_EmployeeType = (PIKCV.COM.EnumDB.EmployeeTypes)((int)objUser.EmployeeTypeCode);
this.m_FirstName = objUser.FirstName;
this.m_IdentityNo = objUser.IdentityNo;
this.m_IsActive = objUser.IsActive;
this.m_IsCVActive = objUser.IsCVActive;
this.m_IsCVConfirmed = objUser.IsCVConfirmed;
this.m_IsDeleted = objUser.IsDeleted;
this.m_IsEmailConfirmed = objUser.IsEmailConfirmed;
this.m_LastName = objUser.LastName;
this.m_ModifyDate = objUser.ModifyDate;
this.m_Password = objUser.Password;
this.m_LastLoginDate = objUser.LastLoginDate;
UpdateLastLoginDate(UserID);
return(true);
}
return(false);
}
public void UpdateLastLoginDate(int UserID)
{
DateTime LastLoginDate = DateTime.Now;
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.LoadByPrimaryKey(UserID);
objUser.LastLoginDate = LastLoginDate;
objUser.Save();
}
public bool UpdateCVStatus(int UserID, bool IsCVActive)
{
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.LoadByPrimaryKey(UserID);
if (objUser.IsCVConfirmed)
{
objUser.IsCVActive = IsCVActive;
objUser.Save();
return(true);
}
return(false);
}
public bool isEmailConfirmed(int UserID)
{
PIKCV.DAL.User obj = new PIKCV.DAL.User();
obj.LoadByPrimaryKey(UserID);
if (!obj.EOF)
{
return(obj.IsEmailConfirmed);
}
else
{
return(false);
}
}
// Üyelik Bilgileri Yeni Kayýt | Güncelle
public int SaveUserInfo(int UserID, string FirstName, string LastName, string Email, string IdentityNo,
string Password, string SecretQuestion, string SecretAnswer, bool IsWantedSMS)
{
try
{
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
if (UserID > 0)
{
objUser.LoadByPrimaryKey(UserID);
}
else
{
objUser.AddNew(); objUser.CreateDate = DateTime.Now;
}
objUser.Email = Email;
objUser.FirstName = Util.ReplaceStrForDB(FirstName);
objUser.IdentityNo = Util.ClearString(IdentityNo.Trim());
if (UserID < 1)
{
objUser.CreateDate = DateTime.Now;
objUser.ActivationNumber = " ";
objUser.EmployeeTypeCode = (int)PIKCV.COM.EnumDB.EmployeeTypes.Unknown;
objUser.IsActive = true;
objUser.IsCVActive = false;
objUser.IsCVConfirmed = false;
objUser.IsDeleted = false;
objUser.IsEmailConfirmed = false;
//**objUser.IsEmailConfirmed = true;
objUser.LastLoginDate = DateTime.Now.AddYears(50);
}
if (Password != String.Empty)
{
objUser.Password = Encryption.Encrypt(Password);
}
objUser.LastName = Util.ReplaceStrForDB(LastName);
objUser.ModifyDate = DateTime.Now;
objUser.SecretQuestion = Util.ReplaceStrForDB(SecretQuestion);
objUser.SecretAnswer = Util.ReplaceStrForDB(SecretAnswer);
objUser.IsWantedSMS = IsWantedSMS;
objUser.Save();
return(objUser.UserID);
}
catch (Exception)
{
return(0);
}
}
public static bool RemoveUser(int UserID)
{
try
{
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.LoadByPrimaryKey(UserID);
objUser.IsDeleted = true;
objUser.Save();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool ActivateUser(int UserID, string ActivationNumber)
{
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.Where.UserID.Value = UserID;
objUser.Where.ActivationNumber.Value = ActivationNumber;
objUser.Query.Load();
if (objUser.RowCount > 0)
{
objUser.LoadByPrimaryKey(UserID);
objUser.IsEmailConfirmed = true;
objUser.Save();
return(true);
}
return(false);
}
public DataRow GetUserByEmail(string Email)
{
string m_Email = Util.ClearString(Email.Trim());
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.Where.Email.Value = m_Email;
objUser.Query.Load();
if (objUser.RowCount > 0)
{
return(objUser.DefaultView.ToTable().Rows[0]);
}
else
{
return(null);
}
}
public bool SaveActivation(int UserID, string ActivationNumber)
{
try
{
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.LoadByPrimaryKey(UserID);
objUser.ActivationNumber = ActivationNumber;
objUser.Save();
return(true);
}
catch (Exception)
{
throw;
}
return(false);
}
public bool UserExist(string Email, string IdentityNo)
{
string m_Email = CARETTA.COM.Util.ClearString(Email.Trim());
string m_IdentityNo = CARETTA.COM.Util.ClearString(IdentityNo.Trim());
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
objUser.Where.Email.Value = m_Email;
objUser.Where.IdentityNo.Value = m_IdentityNo;
objUser.Query.Load("OR");
if (objUser.RowCount > 0)
{
return(true);
}
else
{
return(false);
}
}
public static DataTable GetEmployeeSearchResults(ArrayList Gender,
ArrayList AgeRange,
ArrayList MaritalStates,
ArrayList MilitaryStates,
int DriverLicenceTypes,
bool Handicapped,
bool Convicted,
bool MartyrRelative,
bool TerrorAggrieved,
ArrayList Countries,
ArrayList TurkeyCities,
ArrayList EducationLevels,
ArrayList EducationStates,
ArrayList HighSchoolEducationLevels,
int HighSchoolTypes,
ArrayList UniversityEducationLevels,
int UniversityNames,
int DepartmentNames,
ArrayList Sectors,
ArrayList Positions,
ArrayList Experience,
ArrayList LabouringTypes,
int ForeignLanguages1,
int ForeignLanguages1Reading,
int ForeignLanguages1Writing,
int ForeignLanguages1Speaking,
int ForeignLanguages2,
int ForeignLanguages2Reading,
int ForeignLanguages2Writing,
int ForeignLanguages2Speaking,
int ForeignLanguages3,
int ForeignLanguages3Reading,
int ForeignLanguages3Writing,
int ForeignLanguages3Speaking,
ArrayList ComputerKnowledgeTypes,
ArrayList SectorsDesired,
ArrayList PositionsDesired,
ArrayList CountriesDesired,
ArrayList CitiesDesired,
ArrayList LabouringTypesDesired,
int EmployeeSearchType,
int CompanyID,
int JobID,
ArrayList ApplicationStatus)
{
//int EmployeeSearchType
//int UniversityNames,
//int DepartmentNames,
//int HighSchoolTypes,
string strGender;
if (Gender != null && Gender.Count != 0)
{
strGender = XMLHelper.BuildXmlString("Gender", "Gender", Gender);
}
else
{
strGender = "";
}
string strAgeRange;
if (AgeRange != null && AgeRange.Count != 0)
{
strAgeRange = XMLHelper.BuildXmlString("AgeRange", "AgeRange", AgeRange);
}
else
{
strAgeRange = "";
}
string strMaritalStates;
if (MaritalStates != null && MaritalStates.Count != 0)
{
strMaritalStates = XMLHelper.BuildXmlString("MaritalStates", "MaritalStates", MaritalStates);
}
else
{
strMaritalStates = "";
}
string strMilitaryStates;
if (MilitaryStates != null && MilitaryStates.Count != 0)
{
strMilitaryStates = XMLHelper.BuildXmlString("MilitaryStates", "MilitaryStates", MilitaryStates);
}
else
{
strMilitaryStates = "";
}
string strCountries;
if (Countries != null && Countries.Count != 0)
{
strCountries = XMLHelper.BuildXmlString("Countries", "Countries", Countries);
}
else
{
strCountries = "";
}
string strTurkeyCities;
if (TurkeyCities != null && TurkeyCities.Count != 0)
{
strTurkeyCities = XMLHelper.BuildXmlString("TurkeyCities", "TurkeyCities", TurkeyCities);
}
else
{
strTurkeyCities = "";
}
string strEducationLevels;
if (EducationLevels != null && EducationLevels.Count != 0)
{
strEducationLevels = XMLHelper.BuildXmlString("EducationLevels", "EducationLevels", EducationLevels);
}
else
{
strEducationLevels = "";
}
string strEducationStates;
if (EducationStates != null && EducationStates.Count != 0)
{
strEducationStates = XMLHelper.BuildXmlString("EducationStates", "EducationStates", EducationStates);
}
else
{
strEducationStates = "";
}
string strHighSchoolEducationLevels;
if (HighSchoolEducationLevels != null && HighSchoolEducationLevels.Count != 0)
{
strHighSchoolEducationLevels = XMLHelper.BuildXmlString("HighSchoolEducationLevels", "HighSchoolEducationLevels", HighSchoolEducationLevels);
}
else
{
strHighSchoolEducationLevels = "";
}
string strUniversityEducationLevels;
if (UniversityEducationLevels != null && UniversityEducationLevels.Count != 0)
{
strUniversityEducationLevels = XMLHelper.BuildXmlString("UniversityEducationLevels", "UniversityEducationLevels", UniversityEducationLevels);
}
else
{
strUniversityEducationLevels = "";
}
string strSectors;
if (Sectors != null && Sectors.Count != 0)
{
strSectors = XMLHelper.BuildXmlString("Sectors", "Sectors", Sectors);
}
else
{
strSectors = "";
}
string strPositions;
if (Positions != null && Positions.Count != 0)
{
strPositions = XMLHelper.BuildXmlString("Positions", "Positions", Positions);
}
else
{
strPositions = "";
}
string strExperience;
if (Experience != null && Experience.Count != 0)
{
strExperience = XMLHelper.BuildXmlString("Experience", "Experience", Experience);
}
else
{
strExperience = "";
}
string strLabouringTypes;
if (LabouringTypes != null && LabouringTypes.Count != 0)
{
strLabouringTypes = XMLHelper.BuildXmlString("LabouringTypes", "LabouringTypes", LabouringTypes);
}
else
{
strLabouringTypes = "";
}
string strComputerKnowledgeTypes;
if (ComputerKnowledgeTypes != null && ComputerKnowledgeTypes.Count != 0)
{
strComputerKnowledgeTypes = XMLHelper.BuildXmlString("ComputerKnowledgeTypes", "ComputerKnowledgeTypes", ComputerKnowledgeTypes);
}
else
{
strComputerKnowledgeTypes = "";
}
string strSectorsDesired;
if (SectorsDesired != null && SectorsDesired.Count != 0)
{
strSectorsDesired = XMLHelper.BuildXmlString("SectorsDesired", "SectorsDesired", SectorsDesired);
}
else
{
strSectorsDesired = "";
}
string strPositionsDesired;
if (PositionsDesired != null && PositionsDesired.Count != 0)
{
strPositionsDesired = XMLHelper.BuildXmlString("PositionsDesired", "PositionsDesired", PositionsDesired);
}
else
{
strPositionsDesired = "";
}
string strCountriesDesired;
if (CountriesDesired != null && CountriesDesired.Count != 0)
{
strCountriesDesired = XMLHelper.BuildXmlString("CountriesDesired", "CountriesDesired", CountriesDesired);
}
else
{
strCountriesDesired = "";
}
string strCitiesDesired;
if (CitiesDesired != null && CitiesDesired.Count != 0)
{
strCitiesDesired = XMLHelper.BuildXmlString("CitiesDesired", "CitiesDesired", CitiesDesired);
}
else
{
strCitiesDesired = "";
}
string strLabouringTypesDesired;
if (LabouringTypesDesired != null && LabouringTypesDesired.Count != 0)
{
strLabouringTypesDesired = XMLHelper.BuildXmlString("LabouringTypesDesired", "LabouringTypesDesired", LabouringTypesDesired);
}
else
{
strLabouringTypesDesired = "";
}
string strApplicationStatus;
if (ApplicationStatus != null && ApplicationStatus.Count != 0)
{
strApplicationStatus = XMLHelper.BuildXmlString("ApplicationStatus", "ApplicationStatus", ApplicationStatus);
}
else
{
strApplicationStatus = "";
}
//string strForeignLanguages;
//if (ForeignLanguages != null && ForeignLanguages.Count != 0)
// strForeignLanguages = "";
// //strForeignLanguages = XMLHelper.BuildXmlString("ForeignLanguages", "ForeignLanguages", ForeignLanguages);
//else
// strForeignLanguages = "";
//string strForeignLanguagesReading;
//if (ForeignLanguagesReading != null && ForeignLanguagesReading.Count != 0)
// strForeignLanguagesReading = "";
// //strForeignLanguagesReading = XMLHelper.BuildXmlString("ForeignLanguagesReading", "ForeignLanguagesReading", ForeignLanguagesReading);
//else
// strForeignLanguagesReading = "";
//string strForeignLanguagesWriting;
//if (ForeignLanguagesWriting != null && ForeignLanguagesWriting.Count != 0)
// strForeignLanguagesWriting = "";
// //strForeignLanguagesWriting = XMLHelper.BuildXmlString("ForeignLanguagesWriting", "ForeignLanguagesWriting", ForeignLanguagesWriting);
//else
// strForeignLanguagesWriting = "";
//string strForeignLanguagesSpeaking;
//if (ForeignLanguagesSpeaking != null && ForeignLanguagesSpeaking.Count != 0)
// strForeignLanguagesSpeaking = "";
// //strForeignLanguagesSpeaking = XMLHelper.BuildXmlString("ForeignLanguagesSpeaking", "ForeignLanguagesSpeaking", ForeignLanguagesSpeaking);
//else
// strForeignLanguagesSpeaking = "";
string strForeignLanguages = "";
if (ForeignLanguages1 != 0 || ForeignLanguages2 != 0 || ForeignLanguages3 != 0)
{
strForeignLanguages = "<ForeignLanguages> ";
if (ForeignLanguages1 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages1.ToString() + "\" fls=\"" + ForeignLanguages1Speaking.ToString() + "\" flw=\"" + ForeignLanguages1Writing.ToString() + "\" flr=\"" + ForeignLanguages1Reading.ToString() + "\" /> ";
}
if (ForeignLanguages2 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages2.ToString() + "\" fls=\"" + ForeignLanguages2Speaking.ToString() + "\" flw=\"" + ForeignLanguages2Writing.ToString() + "\" flr=\"" + ForeignLanguages2Reading.ToString() + "\" /> ";
}
if (ForeignLanguages3 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages3.ToString() + "\" fls=\"" + ForeignLanguages3Speaking.ToString() + "\" flw=\"" + ForeignLanguages3Writing.ToString() + "\" flr=\"" + ForeignLanguages3Reading.ToString() + "\" /> ";
}
strForeignLanguages += " </ForeignLanguages>";
}
DataTable dt;
try
{
PIKCV.DAL.User obj = new PIKCV.DAL.User();
dt = null;
dt = obj.GetEmployeeSearchResults(strGender, strAgeRange, strMaritalStates, strMilitaryStates, DriverLicenceTypes,
Handicapped, Convicted, MartyrRelative, TerrorAggrieved,
strCountries, strTurkeyCities, strEducationLevels, strEducationStates, strHighSchoolEducationLevels,
HighSchoolTypes, strUniversityEducationLevels, UniversityNames, DepartmentNames, strSectors, strPositions, strExperience,
strLabouringTypes, strForeignLanguages, strComputerKnowledgeTypes, strSectorsDesired,
strPositionsDesired, strCountriesDesired, strCitiesDesired, strLabouringTypesDesired, EmployeeSearchType, CompanyID, JobID, strApplicationStatus);
}
catch (Exception)
{
dt = null;
throw;
}
return(dt);
}
public DataTable GetUserDetail(int UserID)
{
PIKCV.DAL.User obj = new PIKCV.DAL.User();
obj.LoadByPrimaryKey(UserID);
return(obj.DefaultView.ToTable());
}
public bool InsertInterview(int CompanyID, int CompanyAdvisorID, DateTime InterviewDate, DateTime InterviewEndTime,
PIKCV.COM.EnumDB.MemberTypes InterviewerTypeCode, string InterviewPlace, DateTime InterviewStartTime, int PositionID,
int UpdatedBy, ArrayList arrSelectedUsers, string CompanyAdvisorName)
{
PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr();
try
{
PIKCV.DAL.Interviews objInterview = new PIKCV.DAL.Interviews();
PIKCV.DAL.Messages objMessage = new PIKCV.DAL.Messages();
PIKCV.DAL.User objUser = new PIKCV.DAL.User();
PIKCV.DAL.Companies objCompany = new PIKCV.DAL.Companies();
string MessageBody = "";
Tran.BeginTransaction();
for (int i = 0; i < arrSelectedUsers.Count; i++)
{
objInterview.AddNew();
objInterview.CompanyAdvisorID = CompanyAdvisorID;
objInterview.CreateDate = DateTime.Now;
objInterview.InterviewDate = InterviewDate;
objInterview.InterviewEndTime = InterviewEndTime;
objInterview.InterviewerID = CompanyID;
objInterview.InterviewerTypeCode = (int)InterviewerTypeCode;
objInterview.InterviewNotes = PIKCV.COM.Util.ReturnEmptyString(String.Empty);
objInterview.InterviewPlace = InterviewPlace;
objInterview.InterviewRating = 0;
objInterview.InterviewStartTime = InterviewStartTime;
objInterview.InterviewStatusID = 1;
objInterview.JobID = 0;
objInterview.PositionID = PositionID;
objInterview.ModifyDate = DateTime.Now;
objInterview.UpdatedBy = UpdatedBy;
objInterview.UserID = Convert.ToInt32(arrSelectedUsers[i]);
objInterview.Save();
objUser.LoadByPrimaryKey(Convert.ToInt32(arrSelectedUsers[i]));
objCompany.LoadByPrimaryKey(CompanyID);
MessageBody = objCompany.CompanyName + " þirketi tarafýndan mülakata çaðrýldýnýz" +
"<br><br>Tarih: " + InterviewDate.ToShortDateString() +
"<br><br>Saat: " + InterviewStartTime.Hour.ToString() + ":" + InterviewStartTime.Minute.ToString() + "-" +
InterviewEndTime.Hour.ToString() + ":" + InterviewEndTime.Minute.ToString() +
"<br><br>Yer: " + InterviewPlace +
"<br><br>Danýþman: " + CompanyAdvisorName;
objMessage.AddNew();
objMessage.CreateDate = DateTime.Now;
objMessage.IsDeleted = false;
objMessage.IsRead = false;
objMessage.JobID = 0;
objMessage.MessageOwnerID = Convert.ToInt32(arrSelectedUsers[i]);
objMessage.MessageOwnerTypeCode = (int)PIKCV.COM.EnumDB.MemberTypes.Employee;
objMessage.MessageTitle = "Mülakat Daveti";
objMessage.MessageBody = MessageBody;
objMessage.MessageTypeCode = (int)PIKCV.COM.EnumDB.MessageTypeCode.Interview;
objMessage.SenderID = CompanyID;
objMessage.SenderTypeCode = (int)PIKCV.COM.EnumDB.MemberTypes.Company;
objMessage.Save();
}
Tran.CommitTransaction();
return(true);
}
catch (Exception)
{
Tran.RollbackTransaction();
PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset();
return(false);
}
}
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);
}
}
