public void saveImage(string Name, string Path, string About, string Place, string People)
{
using (var db = new Model1Container())
{
PhotosVideos photovideo = new PhotosVideos()
{
Name = Name,
CreateDate = true,
Path = Path,
About = About
};
Place place = new Place()
{
Name = Place,
PhotosVideos = photovideo
};
db.PhotosVideosSet.Add(photovideo);
db.PlaceSet.Add(place);
string[] peopleList = People.Split(',');
foreach (var t in peopleList)
{
Person person = new Person()
{
Name = t.Trim(' '),
PhotosVideos = photovideo
};
db.PersonSet.Add(person);
}
db.SaveChanges();
/*try
* {
*
* context.SaveChanges();
* }
* catch (DbEntityValidationException e)
* {
* foreach (var eve in e.EntityValidationErrors)
* {
* Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
* eve.Entry.Entity.GetType().Name, eve.Entry.State);
* foreach (var ve in eve.ValidationErrors)
* {
* Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
* ve.PropertyName, ve.ErrorMessage);
* }
* }
* throw;
* }*/
}
}
public void deleteImage(string Path)
{
using (var db = new Model1Container())
{
PhotosVideos del = new PhotosVideos()
{
Path = Path,
CreateDate = false
};
var search = db.PhotosVideosSet.SingleOrDefault(p => p.Path == Path);
if (search != null)
{
search.Path = null;
}
db.SaveChanges();
}
}
public void UpdateImage1(string Name, string Path, string About, string Place, string People)
{
using (var db = new Model1Container())
{
int id = 0;
PhotosVideos pv = new PhotosVideos()
{
Id = id,
Name = Name,
CreateDate = true,
Path = Path,
About = About
};
var result = db.PhotosVideosSet.SingleOrDefault(p => p.Path == Path);
var searchPath = pv.Path;
var searchId = db.PhotosVideosSet.FirstOrDefault(f => f.Path == searchPath).Id;
if (result != null)
{
result.Path = Path;
result.Name = Name;
result.About = About;
db.SaveChanges();
}
Place plc = new Place()
{
Name = Place
};
var res = db.PlaceSet.SingleOrDefault(pl => pl.Id == searchId);
if (res != null)
{
res.Name = Place;
db.SaveChanges();
}
string[] pplList = People.Split(',');
int sizeOfList = pplList.Length;
for (var index = 0; index < pplList.Length; index++)
{
var t = pplList[index];
Person person = new Person()
{
Name = t.Trim(' '),
PhotosVideosId = searchId
};
var rsl = db.PersonSet.SingleOrDefault(pr => pr.PhotosVideosId == searchId);
if (sizeOfList == 1 || index == 0)
{
// var rsl = db.PersonSet.SingleOrDefault(pr => pr.PhotosVideosId == searchId);
if (rsl != null)
{
rsl.Name = People;
}
db.SaveChanges();
}
else if (sizeOfList > 1)
{
db.PersonSet.Add(person);
db.SaveChanges();
}
}
}
}
