public static List <Entities.Part> getPart() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Configuration.LazyLoadingEnabled = false; List <Entities.Part> parts = new List <Entities.Part>(); var h = db.Part.ToList(); foreach (var item in h) { parts.Add(Entities.Part.PartEntities(item)); } //db.Database.Connection.Close(); return(parts); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } //return db.areas(); }
public static List <Entities.Recomend> getReccomend(int companyId) { try { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); List <Entities.Recomend> recomendList = new List <Recomend>(); foreach (var item in DB.Recomend) { if (item.RecomemdCompanyId == companyId) { recomendList.Add(Entities.Recomend.RecomendEntities(item)); } } return(recomendList); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <JobView> getNewJobs() { try { //var context = new DAL.IdialEntities3(); //context.Database.Initialize(force: false); // db.Database.Initialize(force: false); using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.Job> Job2 = new List <Entities.Job>(); var y = from u in db.Job where u.JobStatus == true && u.JobDateCaughtJob == null orderby u.JobDateAdv descending select u; foreach (var item in y) { Job2.Add(Entities.Job.JobEntities(item)); } db.Database.Connection.Close(); return(JobView(Job2)); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message + " " + e.Source + " " + e.Data); return(null); } }
public static HttpResponseMessage addRecomend(Recomend recomend) { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); Entities.Recomend newRecomend = new Recomend(); newRecomend.RecomemdCompanyId = recomend.RecomemdCompanyId; newRecomend.RecomendUserId = recomend.RecomendUserId; newRecomend.RecomendInfo = recomend.RecomendInfo; db.Recomend.Add(Entities.Recomend.RecomendDAL(newRecomend)); 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.City> getAllCity() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.City> cities = new List <Entities.City>(); foreach (var item in db.City.ToList()) { cities.Add(Entities.City.CityEntities(item)); } cities = cities.OrderBy(p => p.CityName).ToList(); db.Database.Connection.Close(); return(cities); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <Entities.SubjectJob> getSubjectJob() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.SubjectJob> subjectJob = new List <Entities.SubjectJob>(); foreach (var item in db.SubjectJob.ToList()) { subjectJob.Add(Entities.SubjectJob.SubjectJobEntities(item)); } subjectJob = subjectJob.OrderBy(p => p.SubName).ToList(); //subjectJob.OrderByDescending(p=>p.SubName,ab) db.Database.Connection.Close(); return(subjectJob); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <Entities.City> getCity(int areaId) { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.City> cities = new List <Entities.City>(); foreach (var item in db.City.ToList()) { cities.Add(Entities.City.CityEntities(item)); } cities = cities.Where(p => p.CityAreaId == areaId).ToList(); cities = cities.OrderBy(p => p.CityName).ToList(); db.Database.Connection.Close(); return(cities); } } catch (Exception e) { Trace.TraceInformation("Your Information"); Trace.TraceError("Your Error"); Trace.TraceWarning("Your Warning"); BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static Entities.JobParameters getjobParameters() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { Entities.JobParameters jp = new Entities.JobParameters(); jp.Areas = getArea(); jp.Parts = getPart(); jp.SubjectJob = getSubjectJob(); jp.Cities = getAllCity(); jp.OutNets = getOutNet(); jp.Workspaces = getWS(); return(jp); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
//רשימת העבודות שיש להן השמותתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתתת //מחזירה את העבודות שיש להם השמות public static List <Entities.JobView> jobsSign() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { var jobs = db.Job.Where(job => job.Sign.Count > 0).ToList(); List <DAL.Job> j = new List <DAL.Job>(); foreach (var item in jobs) { var pw = db.Sign.FirstOrDefault(p => p.SignJobId == item.JobId && p.SignStatusSend != true); if (pw != null) { j.Add(db.Job.FirstOrDefault(w => w.JobId == pw.SignJobId)); } } var temp = j?.Select(job => Entities.Job.JobEntities(job)).ToList(); return(BL.SelectorJob.JobView(temp)); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static Entities.User registerUser(Entities.User user) { try { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); DB.User.Add(Entities.User.UserDAL(user)); DB.SaveChanges(); var u = DB.User.FirstOrDefault(x => x.UserMail == user.UserMail && x.UserPassword == user.password); //BL.SendMail.SendEmail(data, "ברוך בואך לאתר אידיאל", u.UserMail); //var p = BL.SendMail.register(u.UserName, u.UserPassword, u.UserMail); return(Entities.User.UserEntities(u)); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <JobView> JobToCheck() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { List <Entities.Job> Jobs = new List <Entities.Job>(); foreach (var item in db.Job.ToList()) { if (item.JobStatus == false) { Jobs.Add(Entities.Job.JobEntities(item)); } } //Jobs.OrderBy(p => p.JobDateAdv); var jobsVeiw = BL.SelectorJob.JobView(Jobs); return(jobsVeiw); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <Entities.OutNet> getOutNet() { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { List <Entities.OutNet> outNet = new List <Entities.OutNet>(); var h = db.OutNet.ToList(); foreach (var item in h) { outNet.Add(Entities.OutNet.OutNetEntities(item)); } db.Database.Connection.Close(); return(outNet); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <Entities.Workspace> getWS() { try { using (DAL.IdialEntities3 dbn = new DAL.IdialEntities3()) { dbn.Database.Connection.Open(); List <Entities.Workspace> ws = new List <Entities.Workspace>(); var h = dbn.Workspace.ToList(); foreach (var item in h) { ws.Add(Entities.Workspace.WorkspaceEntities(item)); } dbn.Database.Connection.Close(); return(ws); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static List <Entities.Area> getArea() { try { //db.Database.Connection.Open(); using (DAL.IdialEntities3 dbn = new DAL.IdialEntities3()) { dbn.Database.Connection.Open(); List <Entities.Area> areas = new List <Entities.Area>(); foreach (var item in dbn.Area.ToList()) { areas.Add(Entities.Area.AreaEntities(item)); } areas = areas.OrderBy(p => p.AreaName).ToList(); dbn.Database.Connection.Close(); return(areas); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
//בודק אם יוזר קיים public static Entities.User CheckIsLogin(Entities.User u) { try { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); var user = DB.User.ToList(); var x = user.FirstOrDefault(c => c.UserMail == u.UserMail && c.UserPassword == u.password); if (x == null) { return(null); } DB.Database.Connection.Close(); return(Entities.User.UserEntities(x)); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static void SendToSmart(Job newjob) { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { var job = db.Job.FirstOrDefault(p => p.JobDescribe == newjob.JobDescribe && p.JobExperience == newjob.JobExperience && p.JobRole == newjob.JobRole); BL.SmartAgentLogic.SendImmediatelySmartAgent(Entities.Job.JobEntities(job)); } }
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 Entities.Boss IsRegistered(Entities.Boss b) { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); // List<Entities.Boss> boss2 = new List<Entities.Boss>(); var boss = DB.Boss.FirstOrDefault(p => p.BossPassword == b.BossPassword && p.BossMail == b.BossMail); if (boss != null) { return(Entities.Boss.BossEntities(boss)); } return(null); } }
public static List <Entities.SubjectJob> getSubjectsSurvey() { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.SubjectJob> subjectJob = new List <Entities.SubjectJob>(); foreach (var item in db.SubjectJob.ToList()) { subjectJob.Add(Entities.SubjectJob.SubjectJobEntities(item)); } db.Database.Connection.Close(); return(subjectJob); } }
public static List <JobView> JobView(List <Job> job) { try { using (DAL.IdialEntities3 dbn = new DAL.IdialEntities3()) { //new connection to the database dbn.Database.Connection.Open(); String diff2 = ""; List <Entities.JobView> jv = new List <JobView>(); DateTime temp; foreach (var item in job) { DAL.Workspace w = dbn.Workspace.FirstOrDefault(p1 => p1.WSId == item.JobWorkspaceId); DAL.SubjectJob s = dbn.SubjectJob.FirstOrDefault(p1 => p1.SubId == item.JobSubId); DAL.OutNet outNet = dbn.OutNet.FirstOrDefault(o => o.OutNetId == item.JobPartOutNetId); DAL.Company company = dbn.Company.FirstOrDefault(q => q.CompanyId == item.JobCompanyId); DAL.City city = dbn.City.FirstOrDefault(c => c.CityId == company.CompanyCityId); DAL.Area area = dbn.Area.FirstOrDefault(a => a.AreaId == company.CompanyAreaId); DAL.SubjectJob SubjectJob = dbn.SubjectJob.FirstOrDefault(o => o.SubId == item.JobSubId); DAL.Part p = dbn.Part.FirstOrDefault(s2 => s2.PartId == item.JobPartId); DAL.Job job1 = dbn.Job.FirstOrDefault(j => j.JobId == item.JobId); Entities.JobView v = new JobView(); DateTime.TryParse(item.JobDateAdv.ToString(), out temp); if (temp != null) { diff2 = Convert.ToInt32((DateTime.Today - temp).TotalDays).ToString(); } v = Entities.JobView.CreateJobView(area, company, job1, SubjectJob, w, p, outNet, city, diff2); jv.Add(v); } db.Database.Connection.Close(); return(jv); } //DAL.IdialEntities3.Connection.Open(); } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
public static User GetUser(int id) { try { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); var user = DB.User.FirstOrDefault(p => p.UserId == id); return(User.UserEntities(user)); } } 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 List <Entities.User> getListSignUsers(int jobId) { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.User> userList = new List <User>(); var users = db.User.Where(u => u.Sign.Count > 0).ToList(); foreach (var item in users) { var temp = item.Sign.FirstOrDefault(a => a.SignJobId == jobId && a.SignStatusSend != true); if (temp != null) { userList.Add(Entities.User.UserEntities(item)); } } foreach (var item in userList) { var cv = db.Cv.FirstOrDefault(p => p.CvUserId == item.UserId); if (cv != null) { item.cvURL = baseURL + cv.CvLink; } else { item.cvURL = ""; } } db.Database.Connection.Close(); return(userList); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); db.Database.Connection.Close(); 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 Entities.Boss GetBoss(int id) { try { using (DAL.IdialEntities3 DB = new DAL.IdialEntities3()) { DB.Database.Connection.Open(); var boss = DB.Boss.FirstOrDefault(p => p.BossId == id); return(Entities.Boss.BossEntities(boss)); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(null); } }
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 List <JobView> getJobsByBossId(int?id) { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); List <Entities.Job> Job2 = new List <Entities.Job>(); var y = from u in db.Job where u.JobStatus == true && u.JobBossId == id && u.JobIsByUs == null orderby u.JobDateAdv descending select u; foreach (var item in y) { Job2.Add(Entities.Job.JobEntities(item)); } db.Database.Connection.Close(); return(JobView(Job2)); } }
public static int getAreaByCityId(int cityId) { try { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { db.Database.Connection.Open(); var area = db.City.FirstOrDefault(p => p.CityId == cityId); db.Database.Connection.Close(); return(area != null?Convert.ToInt32(area.CityAreaId) : 1); } } catch (Exception e) { BL.SendMail.SendEmail(e.ToString(), e.Message, ""); BL.WriteLogError.WriteLogErrors(e.Message); return(0); } }
public static List <Entities.Recomend> getRecommendsToCurrentJob(int jobId) { using (DAL.IdialEntities3 db = new DAL.IdialEntities3()) { List <Entities.Recomend> recommendList = new List <Recomend>(); int?companyId = db.Job.FirstOrDefault(j => j.JobId == jobId).JobCompanyId; if (companyId == null) { return(null); } foreach (var item in db.Recomend) { if (item.RecomemdCompanyId == companyId) { recommendList.Add(Entities.Recomend.RecomendEntities(item)); } } return(recommendList); } }