//public
public void UploadPortfolio(PortfolioBindingModel model, string Creator, string imageLocation)
{
try
{
PortfolioDataModel dataModel = new PortfolioDataModel
{
ImageLocation = imageLocation,
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
Email = Creator,
Age = model.Age,
EducationHighSchool = model.EducationHighSchool,
EducationCollege = model.EducationCollege,
Experience = model.Experience,
ExperienceYears = model.ExperienceYears,
AboutMe = model.AboutMe,
Services = model.Services,
Facebook = model.FacebookAccount,
Twitter = model.TwitterAccount,
CVLocation = ""
};
using (var context = new PortfolioDatabase())
{
if (context.Portfolio_table != null)
{
if (context.Portfolio_table
.FirstOrDefault(u => u.Email == Creator) == null)
{
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
else
{
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeletePortfolio(int?id)
{
if (id > -1)
{
using (var context = new PortfolioDatabase())
{
var result = context.Portfolio_table.FirstOrDefault(p => p.Id == id);
if (result != null)
{
System.IO.File.Delete(result.ImageLocation);
context.Portfolio_table.Remove(result);
context.SaveChanges();
}
}
}
}
public void UpdatePortfolio(PortfolioBindingModel model, string Creator, string ImageLocation)
{
try
{
PortfolioDataModel dataModel = new PortfolioDataModel
{
ImageLocation = ImageLocation,
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
Email = Creator,
Age = model.Age,
EducationHighSchool = model.EducationHighSchool,
EducationCollege = model.EducationCollege,
Experience = model.Experience,
ExperienceYears = model.ExperienceYears,
AboutMe = model.AboutMe,
Services = model.Services,
Facebook = model.FacebookAccount,
Twitter = model.TwitterAccount,
CVLocation = ""
};
using (var context = new PortfolioDatabase())
{
var result = context.Portfolio_table.FirstOrDefault(p => p.Email == Creator);
if (ImageLocation == "")
{
dataModel.ImageLocation = result.ImageLocation;
}
context.Portfolio_table.Remove(result);
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
