public void Update(Education update)
{
JobsEntities db = new JobsEntities();
db.Educations.Add(update);
db.SaveChanges();
}
public void Add(CompanyInfo add)
{
JobsEntities db = new JobsEntities();
db.CompanyInfoes.Add(add);
db.SaveChanges();
}
public void Add(City add)
{
JobsEntities db = new JobsEntities();
db.Cities.Add(add);
db.SaveChanges();
}
public void Add(Position add)
{
JobsEntities db = new JobsEntities();
db.Positions.Add(add);
db.SaveChanges();
}
public void Add(JobCatalog add)
{
JobsEntities db = new JobsEntities();
db.JobCatalogs.Add(add);
db.SaveChanges();
}
public void Add(InfoUser add)
{
JobsEntities db = new JobsEntities();
db.InfoUsers.Add(add);
db.SaveChanges();
}
public void Delete(Position add)
{
JobsEntities db = new JobsEntities();
db.Positions.Attach(add);
db.Entry(add).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
public void Edit(InfoUser add)
{
JobsEntities db = new JobsEntities();
db.InfoUsers.Attach(add);
db.Entry(add).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public Admin Login(string username, string pass)
{
using (JobsEntities db = new JobsEntities())
{
Admin ad = db.sp_Login(username, pass).SingleOrDefault();
return(ad);
}
}
public void Edit(CompanyInfo add)
{
JobsEntities db = new JobsEntities();
db.CompanyInfoes.Attach(add);
db.Entry(add).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public void Delete(JobCatalog add)
{
JobsEntities db = new JobsEntities();
db.JobCatalogs.Attach(add);
db.Entry(add).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
public List <Education> getlist()
{
JobsEntities db = new JobsEntities();
return(db.Educations.ToList());
}
public List <Position> getlist()
{
JobsEntities db = new JobsEntities();
return(db.Positions.ToList());
}
public List <JobCatalog> getlist()
{
JobsEntities db = new JobsEntities();
return(db.JobCatalogs.ToList());
}
public void GetImagesByUrl(string url)
{
try
{
var imagesFolder = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Images");
var randomFileName = Path.GetRandomFileName();
var tempDirectory = Path.Combine(imagesFolder, randomFileName);
Directory.CreateDirectory(tempDirectory);
using (var client = new WebClient())
{
var html = client.DownloadString(url);
var doc = new HtmlDocument();
doc.LoadHtml(html);
var imageNodes = doc.DocumentNode.SelectNodes("//img").Where(node => node.Name == "img").ToList();
foreach (var node in imageNodes)
{
if (node.Attributes.Contains("src"))
{
var src = node.Attributes["src"].Value;
if (!IsNullOrEmpty(src))
{
if (src.StartsWith("http"))
{
var fileName = Guid.NewGuid() + Path.GetExtension(src);
var outputFile = Path.Combine(tempDirectory, fileName);
client.DownloadFile(src, outputFile);
var size = new FileInfo(outputFile).Length;
int width;
int height;
using (var stream = new FileStream(outputFile, FileMode.Open, FileAccess.Read))
{
var image = Image.FromStream(stream);
width = image.Width;
height = image.Height;
}
using (var context = new JobsEntities())
{
var imageInfo = new ImageInfo
{
ContentType = MimeMapping.GetMimeMapping(fileName),
LocalUrl =
ConfigurationManager.AppSettings["imagesUrl"] + randomFileName + "/" +
fileName,
RemoteUrl = src,
JobId = Convert.ToInt32(JobContext.JobId),
Size = size,
Height = width,
Width = height
};
context.ImageInfoes.Add(imageInfo);
context.SaveChanges();
}
}
}
}
}
}
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
throw;
}
}
public void SignIn(string name, string pass, string email, string sdt)
{
JobsEntities db = new JobsEntities();
db.sp_Signin(name, pass, sdt, email);
}
public List <CompanyInfo> search(string search)
{
JobsEntities db = new JobsEntities();
return(db.CompanyInfoes.Where(p => p.ComName.Contains(search)).ToList());
}
public List <InfoUser> getlist()
{
JobsEntities db = new JobsEntities();
return(db.InfoUsers.ToList());
}
public List <InfoUser> Search(string search)
{
JobsEntities db = new JobsEntities();
return(db.InfoUsers.Where(p => p.USERNAME.Contains(search)).ToList());
}
public List <CompanyInfo> getlist()
{
JobsEntities db = new JobsEntities();
return(db.CompanyInfoes.ToList());
}
public List <City> getlist()
{
JobsEntities db = new JobsEntities();
return(db.Cities.ToList());
}
