public static int CheckFilterExistance(int UserID, string FilterName, PIKCV.COM.EnumDB.MemberTypes MemberType, PIKCV.COM.EnumDB.FilterTypes FilterType)
{
PIKCV.DAL.Filters objFilters = new PIKCV.DAL.Filters();
objFilters.Where.FilterName.Value = FilterName;
objFilters.Where.FilterOwnerID.Value = UserID;
objFilters.Where.FilterOwnerTypeCode.Value = (int)MemberType;
objFilters.Where.FilterTypeCode.Value = (int)FilterType;
objFilters.Where.IsDeleted.Value = false;
objFilters.Query.Load();
return(objFilters.DefaultView.ToTable().Rows.Count);
}
private void MemberCtrl(PIKCV.COM.EnumDB.MemberTypes MemberType)
{
if (Session[PIKCV.COM.EnumUtil.Sess.MemberType.ToString()] != null)
{
if (Session[PIKCV.COM.EnumUtil.Sess.MemberType.ToString()].ToString() != ((int)MemberType).ToString())
{
Session.Clear();
Session.Abandon();
PIKCV.COM.Util.GoToEntryPage(this.Response);
}
}
}
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 static DataTable GetUserFilters(PIKCV.COM.EnumDB.FilterTypes FilterType, int OwnerID, PIKCV.COM.EnumDB.MemberTypes MemberType, bool IsDeleted)
{
PIKCV.DAL.Filters objFilters = new PIKCV.DAL.Filters();
objFilters.Where.FilterTypeCode.Value = (int)FilterType;
objFilters.Where.FilterOwnerID.Value = OwnerID;
objFilters.Where.FilterOwnerTypeCode.Value = (int)MemberType;
objFilters.Where.IsDeleted.Value = IsDeleted;
objFilters.Query.Load();
return(objFilters.DefaultView.ToTable());
}
public static void SaveFilter(PIKCV.COM.EnumDB.FilterTypes FilterType, string FilterName, int OwnerID, PIKCV.COM.EnumDB.MemberTypes MemberType, string FilterValue)
{
try {
PIKCV.DAL.Filters objFilter = new PIKCV.DAL.Filters();
objFilter.AddNew();
objFilter.CreateDate = DateTime.Now;
objFilter.FilterName = Util.ReplaceStrForDB(FilterName);
objFilter.FilterOwnerID = OwnerID;
objFilter.FilterOwnerTypeCode = (int)MemberType;
objFilter.FilterTypeCode = (int)FilterType;
objFilter.FilterValue = FilterValue;
objFilter.IsDeleted = false;
objFilter.ModifyDate = DateTime.Now;
objFilter.Save();
}
catch (Exception) {
}
}
