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