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) { } }