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