public static bool DeleteMesssage(int MessageID) { try { PIKCV.DAL.Messages obj = new PIKCV.DAL.Messages(); obj.LoadByPrimaryKey(MessageID); obj.IsDeleted = true; obj.Save(); return(true); } catch (Exception) { return(false); } }
//Mesajý okunmuþlar statüsüne koyar public static void MakeMessageReaded(int MessageID) { try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); objMessages.LoadByPrimaryKey(MessageID); objMessages.IsRead = true; objMessages.Save(); } catch (Exception) { throw; } }
//Firmanýn Tek Bir Mesajýn Detayýný Getir public static DataTable GetCompanyMessageByID(int MessageID) { DataTable dt; try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); dt = objMessages.GetCompanyMessageByID(MessageID); } catch (Exception) { dt = null; throw; } return(dt); }
//Firmanýn Gönderilen Mesajlarýný Getir public static DataTable GetCompanySentMessages(int CompanyID, bool IsDeleted, string UserID) { DataTable dt; try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); dt = objMessages.GetCompanySentMessages(CompanyID, IsDeleted, UserID); } catch (Exception) { dt = null; throw; } return(dt); }
//Firma Mesajlarý Getir public static DataTable GetCompanyMessages(int CompanyID, bool IsDeleted, EnumDB.MemberTypes MessageOwnerTypeCode) { DataTable dt; try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); dt = objMessages.GetCompanyMessages(CompanyID, IsDeleted, (int)MessageOwnerTypeCode); } catch (Exception) { dt = null; throw; } return(dt); }
//Tüm Mesajlarý Getir public static DataTable GetAllMessages(int UserID, bool IsDeleted, EnumDB.MemberTypes MessageOwnerTypeCode, string CompanyID, string JobID) { DataTable dt; try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); dt = objMessages.LoadAllMessages(UserID, IsDeleted, (int)MessageOwnerTypeCode, CompanyID, JobID); } catch (Exception) { dt = null; throw; } return(dt); }
//Kullanýcýnýn Mesaj Sayýsýný Getirir public static DataTable GetUserMessageCount(int UserID, int MessageOwnerTypeCode, bool IsRead) { DataTable dt; try { PIKCV.DAL.Messages objMessages = new PIKCV.DAL.Messages(); dt = objMessages.GetUserMessageCount(UserID, MessageOwnerTypeCode, IsRead); } catch (Exception) { dt = null; throw; } return(dt); }
public bool InsertMessages(int CompanyID, string MessageBody, string MessageTitle, EnumDB.MemberTypes MessageOwnerType, EnumDB.MemberTypes MessageSenderType, ArrayList arrUsers) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { for (int i = 0; i < arrUsers.Count; i++) { PIKCV.DAL.Messages obj = new PIKCV.DAL.Messages(); obj.AddNew(); obj.CreateDate = DateTime.Now; obj.IsDeleted = false; obj.IsRead = false; obj.JobID = 0; obj.MessageBody = CARETTA.COM.Util.ReplaceStrForDB(MessageBody); obj.MessageOwnerID = Convert.ToInt32(arrUsers[i]); obj.MessageOwnerTypeCode = (int)MessageOwnerType; obj.MessageTitle = CARETTA.COM.Util.ReplaceStrForDB(MessageTitle); obj.MessageTypeCode = 1; obj.SenderID = CompanyID; obj.SenderTypeCode = (int)MessageSenderType; obj.Save(); } Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }
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); } }