public static HttpResponseMessage RegisterToSingJob(int idjob, int iduser)
{
try
{
Entities.Sign newSign = new Entities.Sign();
newSign.SignDate = DateTime.Now;
newSign.SignUserId = iduser;
newSign.SignJobId = idjob;
newSign.SignStatusSend = false;
DB.Sign.Add(Entities.Sign.SignDAL(newSign));
DB.SaveChanges();
return new HttpResponseMessage(HttpStatusCode.OK) { };
}
catch(Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return new HttpResponseMessage(HttpStatusCode.BadRequest) { };
}
}
public static HttpResponseMessage addSurvey(Survey survey)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
db.Database.Connection.Open();
Entities.Survey newSurvey = new Entities.Survey();
newSurvey.SurveyIsWork = survey.SurveyIsWork;
if (survey.SurveySeminar != null)
{
newSurvey.SurveySeminar = survey.SurveySeminar;
}
if (survey.SurveySubLearnId != null)
{
newSurvey.SurveySubLearnId = survey.SurveySubLearnId;
}
if (survey.SurveySubTodayId != null)
{
newSurvey.SurveySubTodayId = survey.SurveySubTodayId;
}
if (survey.SurveySubTodayTxt != null)
{
newSurvey.SurveySubTodayTxt = survey.SurveySubTodayTxt;
}
if (survey.SurveySubLearnedTxt != null)
{
newSurvey.SurveySubLearnedTxt = survey.SurveySubLearnedTxt;
}
var _survey = Entities.Survey.SurveyDAL(newSurvey);
db.Survey.Add(_survey);
db.SaveChanges();
db.Database.Connection.Close();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
//edit job
public static HttpResponseMessage EditJobDetails(JobView editJob)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
db.Database.Connection.Open();
var y = from u in db.Job
where u.JobId == editJob.JobId
select u;
foreach (var item in y)
{
item.JobIsByUs = editJob.JobIsByUs;
//item.JobOfferId = editJob.JobOfferId;
item.JobPartId = editJob.JobPartId;
item.JobPartOutNetId = editJob.JobPartOutNetId;
item.JobWorkspaceId = editJob.JobWorkspaceId;
item.JobDateCaughtJob = editJob.JobDateCaughtJob;
item.JobDateAdv = editJob.JobDateAdv;
item.JobBossId = editJob.JobBossId;
item.JobCompanyId = editJob.JobCompanyId;
item.JobDescribe = editJob.JobDescribe;
item.JobExperience = editJob.JobExperience;
//item.JobCVId = editJob.JobCVId;
item.JobRole = editJob.JobRole;
item.JobStatus = editJob.JobStatus;
item.JobStars = editJob.JobStars;
item.JobSubId = editJob.JobSubId;
item.JobRequire = editJob.JobRequire;
}
db.SaveChanges();
db.Database.Connection.Close();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static List <Entities.Advs> removeAdv(int idAdv)
{
try
{
var a = db.Adv.FirstOrDefault(p => p.AdvId == idAdv);
db.Adv.Remove(a);
db.SaveChanges();
return(getAdvs());
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
public static List <Entities.Company> removeCompany(int companyId)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
var company = db.Company.FirstOrDefault(c => c.CompanyId == companyId);
//מחיקת כל המשרות של החברה
foreach (var item in db.Job)
{
if (item.JobCompanyId == companyId)
{
//מחיקת הנרשמים למשרות של החברה
foreach (var s in db.Sign)
{
if (s.SignJobId == item.JobId)
{
db.Sign.Remove(s);
}
}
db.Job.Remove(item);
}
}
//מחיקת כל ההמלצות על החברה
foreach (var item in db.Recomend)
{
if (item.RecomemdCompanyId == companyId)
{
db.Recomend.Remove(item);
}
}
db.Company.Remove(company);
db.SaveChanges();
return(BL.SelectorJob.getCompanyName());
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
//public static HttpResponseMessage AddNewJob(JobView jobView)
//{
// try
// {
// Job newjob = new Job();
// newjob.JobDateAdv = DateTime.Now;
// newjob.JobDescribe = jobView.JobDescribe;
// newjob.JobExperience = jobView.JobExperience;
// newjob.JobPartId = db.Part.FirstOrDefault(p => p.PartName == jobView.PartName).PartId;
// newjob.JobPartOutNetId = db.OutNet.FirstOrDefault(p => p.OutNetName == jobView.OutNetName).OutNetId;
// newjob.JobRole = jobView.JobRole;
// newjob.JobCompanyId = jobView.CompanyId;
// newjob.JobBossId = jobView.BossId;
// //newjob.JobStars
// newjob.JobStatus = false;
// newjob.JobSubId = db.SubjectJob.FirstOrDefault(p => p.SubName == jobView.SubjectName).SubId;
// newjob.JobWorkspaceId = db.Workspace.FirstOrDefault(p => p.WSName == jobView.WSName).WSId;
// newjob.JobRequire = jobView.JobRequire;
// db.Job.Add(Entities.Job.JobDAL(newjob));
// db.SaveChanges();
// //SendToSmart(newjob);
// return new HttpResponseMessage(HttpStatusCode.OK) { };
// }
// catch
// {
// return new HttpResponseMessage(HttpStatusCode.BadRequest) { };
// }
//}
public static HttpResponseMessage AddNewJob(Job jobView)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
db.Database.Connection.Open();
Job newjob = new Job();
newjob.JobDateAdv = DateTime.Now;
newjob.JobDescribe = jobView.JobDescribe;
newjob.JobExperience = jobView.JobExperience;
newjob.JobPartId = jobView.JobPartId;
newjob.JobPartOutNetId = jobView.JobPartOutNetId;
newjob.JobRole = jobView.JobRole;
newjob.JobCompanyId = jobView.JobCompanyId;
newjob.JobBossId = jobView.JobBossId;
newjob.JobStars = stars(jobView.JobWorkspaceId, jobView.JobPartOutNetId);
newjob.JobStatus = false;
newjob.JobSubId = jobView.JobSubId;
newjob.JobWorkspaceId = jobView.JobWorkspaceId;
newjob.JobRequire = jobView.JobRequire;
db.Job.Add(Entities.Job.JobDAL(newjob));
db.SaveChanges();
//SendToSmart(newjob);
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static List <Entities.Boss> removeBoss(int bossId)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
List <Entities.Boss> bossList = new List <Boss>();
var boss = db.Boss.FirstOrDefault(b => b.BossId == bossId);
//מחיקת המשרות שפרסם
foreach (var item in db.Job)
{
if (item.JobBossId == bossId)
{
//מחיקת הנרשמים למשרות שפרסם
foreach (var s in db.Sign)
{
if (s.SignJobId == item.JobId)
{
db.Sign.Remove(s);
}
}
db.Job.Remove(item);
}
}
db.Boss.Remove(boss);
db.SaveChanges();
foreach (var item in db.Boss)
{
bossList.Add(Entities.Boss.BossEntities(item));
}
return(bossList);
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
public static Entities.User EditDetailsUser(Entities.User editUser)
{
Entities.User user = new Entities.User();
try
{
using (DAL.IdialEntities3 DB = new DAL.IdialEntities3())
{
DB.Database.Connection.Open();
var y = from u in DB.User
where u.UserId == editUser.UserId
select u;
foreach (var item in y)
{
item.UserName = editUser.UserName;
item.UserPartId = editUser.UserPartId;
item.UserPassword = editUser.password;
item.UserSubId = editUser.UserSubId;
item.UserCityId = editUser.UserCityId;
item.UserSubId = editUser.UserSubId;
item.UserIsUpdate = editUser.UserIsUpdate;
item.UserIsChizuk = editUser.UserIsChizuk;
item.UserMail = editUser.UserMail;
item.UserTel = editUser.UserTel;
item.UserIsSmartAgent = editUser.UserIsSmartAgent;
item.UserSmartAgentTime = editUser.UserSmartAgentTime;
user = Entities.User.UserEntities(DB.User.FirstOrDefault(d => d.UserId == item.UserId));
}
DB.SaveChanges();
return(user);
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
public static List <Entities.Company> AddNewCompany(Company company)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
db.Database.Connection.Open();
Company newCompany = new Company();
newCompany.CompanyMail = company.CompanyMail;
newCompany.CompanyName = company.CompanyName;
newCompany.CompanyStreet = company.CompanyStreet;
newCompany.CompanyTel = company.CompanyTel;
newCompany.CompanyNumBuild = company.CompanyNumBuild;
newCompany.CompanyAreaId = company.CompanyAreaId;
newCompany.CompanyCityId = company.CompanyCityId;
db.Company.Add(Entities.Company.CompanyDAL(newCompany));
db.SaveChanges();
db.Database.Connection.Close();
}
// return new HttpResponseMessage(HttpStatusCode.OK) { };
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
// return new HttpResponseMessage(HttpStatusCode.BadRequest) { };
}
List <Entities.Company> c = new List <Entities.Company>();
var h = db.Company.ToList();
foreach (var item in h)
{
c.Add(Entities.Company.CompanyEntities(item));
}
return(c);
}
public static HttpResponseMessage addCv(string mail)
{
try
{
using (DAL.IdialEntities3 DB = new DAL.IdialEntities3())
{
DB.Database.Connection.Open();
string s = mail.Substring(0, mail.LastIndexOf('.'));
var cvUserId = DB.User.FirstOrDefault(d => d.UserMail == s).UserId;
var check = DB.Cv.FirstOrDefault(a => a.CvUserId == cvUserId);
if (check != null)
{
check.CvLink = mail;
}
else
{
Entities.Cv cv = new Entities.Cv();
cv.CvLink = mail;
cv.CvUserId = cvUserId;
DB.Cv.Add(Entities.Cv.CvDAL(cv));
}
DB.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static HttpResponseMessage EditCompanyDetails(Company editCompany)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
db.Database.Connection.Open();
var y = from u in db.Company
where u.CompanyId == editCompany.CompanyId
select u;
foreach (var item in y)
{
item.CompanyAreaId = editCompany.CompanyAreaId;
item.CompanyCityId = editCompany.CompanyCityId;
item.CompanyMail = editCompany.CompanyMail;
item.CompanyName = editCompany.CompanyName;
item.CompanyNumBuild = editCompany.CompanyNumBuild;
item.CompanyStreet = editCompany.CompanyStreet;
item.CompanyTel = editCompany.CompanyTel;
}
db.SaveChanges();
db.Database.Connection.Close();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static Entities.User changePassword(string email, string p1)
{
try
{
using (DAL.IdialEntities3 DB = new DAL.IdialEntities3())
{
DB.Database.Connection.Open();
var user = DB.User.FirstOrDefault(s => s.UserMail == email);
if (user != null)
{
user.UserPassword = p1;
DB.SaveChanges();
}
return(Entities.User.UserEntities(user));
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}
public static HttpResponseMessage EditDetailsBoss(Boss editBoss)
{
try
{
using (DAL.IdialEntities3 DB = new DAL.IdialEntities3())
{
DB.Database.Connection.Open();
var y = from u in DB.Boss
where u.BossId == editBoss.BossId
select u;
foreach (var item in y)
{
item.BossName = editBoss.BossName;
item.BossPassword = editBoss.BossPassword;
item.BossSubId = editBoss.BossSubId;
item.BossTel = editBoss.BossTel;
item.BossMail = editBoss.BossMail;
item.BossCompanyId = editBoss.BossCompanyId;
item.BossIsConnection = editBoss.BossIsConnection;
}
DB.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static HttpResponseMessage addNewSubjectJob(string subjectJobName)
{
Entities.SubjectJob subjectJob = new SubjectJob();
subjectJob.SubName = subjectJobName;
try
{
db.SubjectJob.Add(Entities.SubjectJob.SubjectJobDAL(subjectJob));
db.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.OK)
{
});
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
});
}
}
public static List <Entities.User> removeUser(int userId)
{
try
{
using (DAL.IdialEntities3 db = new DAL.IdialEntities3())
{
List <Entities.User> userList = new List <User>();
var user = db.User.FirstOrDefault(c => c.UserId == userId);
//מחיקת הקו"ח שלו
foreach (var item in db.Cv)
{
if (item.CvUserId == userId)
{
db.Cv.Remove(item);
}
}
//הסרה מרשימת הנרשמים לעבודה
foreach (var item in db.Sign)
{
if (item.SignUserId == userId)
{
db.Sign.Remove(item);
}
}
//הסרה מרשימת השמות עבודה
foreach (var item in db.PutInJob)
{
if (item.PutUserId == userId)
{
db.PutInJob.Remove(item);
}
}
//הסרת ההמלצות שפירסם- check!!!!
foreach (var item in db.Recomend)
{
if (item.RecomendUserId == userId)
{
db.Recomend.Remove(item);
}
}
//הסרת ההמלצות שפירסם- check!!!!
foreach (var item in db.Question)
{
if (item.QueUserId == userId)
{
db.Question.Remove(item);
}
}
//
db.User.Remove(user);
db.SaveChanges();
foreach (var item in db.User)
{
userList.Add(Entities.User.UserEntities(item));
}
return(userList);
}
}
catch (Exception e)
{
BL.SendMail.SendEmail(e.ToString(), e.Message, "");
BL.WriteLogError.WriteLogErrors(e.Message);
return(null);
}
}