public Piece_Details Find(int id)
{
using (var entities = new TempDataEntities())
{
return(entities.Piece_Details.FirstOrDefault(detail => detail.TempId == id) ?? new Piece_Details());
}
}
public List <Pieces> FindAll()
{
using (TempDataEntities entities = new TempDataEntities())
{
return(entities.Pieces.ToList());
}
}
public void Upsert(Piece_Details pieceDetails)
{
using (var dataEntities = new TempDataEntities())
{
var newDetail = dataEntities.Piece_Details.FirstOrDefault(detail => detail.TempId == pieceDetails.TempId) ?? new Piece_Details();
newDetail.CoveredPieces = pieceDetails.CoveredPieces;
newDetail.Type = pieceDetails.Type;
newDetail.Author = pieceDetails.Author;
newDetail.Period = pieceDetails.Period;
newDetail.Culture = pieceDetails.Culture;
newDetail.Origin = pieceDetails.Origin;
newDetail.Shape = pieceDetails.Shape;
newDetail.Inscriptions = pieceDetails.Inscriptions;
newDetail.Description = pieceDetails.Description;
newDetail.Remarks = pieceDetails.Remarks;
newDetail.Collection = pieceDetails.Collection;
newDetail.ConservationType = pieceDetails.ConservationType;
newDetail.Valuation = pieceDetails.Valuation;
newDetail.RawMaterial = pieceDetails.RawMaterial;
newDetail.ManufacturingTechnique = pieceDetails.ManufacturingTechnique;
newDetail.DecorativeTechnique = pieceDetails.DecorativeTechnique;
newDetail.Provenance = pieceDetails.Provenance;
newDetail.AcquisitionMethod = pieceDetails.AcquisitionMethod;
newDetail.Location = pieceDetails.Location;
if (newDetail.TempId == default)
{
newDetail.TempId = pieceDetails.TempId;
dataEntities.Piece_Details.Add(newDetail);
}
dataEntities.SaveChanges();
}
}
public string GetIdentifier(int id, string type)
{
using (var entities = new TempDataEntities())
{
return(entities.Identifiers.FirstOrDefault(identifier => identifier.TempId == id && identifier.Type == type)?.Value);
}
}
public Users Find(Users user)
{
using (var dataEntities = new TempDataEntities())
{
return(dataEntities.Users.FirstOrDefault(u => u.Email == user.Email && u.Password == user.Password));
}
}
public string GetMeasure(int id, string type)
{
using (var entities = new TempDataEntities())
{
var measures = entities.Measures.FirstOrDefault(measure => measure.TempId == id && measure.Type == type);
return(measures?.Value.ToString(CultureInfo.InvariantCulture));
}
}
public void Delete(int id)
{
using (var entities = new TempDataEntities())
{
entities.Pieces.Remove(entities.Pieces.First(p => p.TempId == id));
entities.SaveChanges();
}
}
public Pieces Find(int id)
{
using (var dataEntities = new TempDataEntities())
{
return(dataEntities.Pieces.FirstOrDefault(piece => piece.TempId == id) ??
new Pieces()
{
TempId = dataEntities.Pieces.ToList().Count > 0 ? dataEntities.Pieces.Max(table => table.TempId) + 1: 1
});
}
}
public void Delete(int id, string type)
{
using (var entities = new TempDataEntities())
{
var measures = entities.Measures;
var identifier = measures.FirstOrDefault(i => i.Type.Equals(type) && i.TempId.Equals(id));
if (identifier != default)
{
measures.Remove(identifier);
entities.SaveChanges();
}
}
}
public void Upsert(int id, string type, float?value)
{
using (var entities = new TempDataEntities())
{
var measure = entities.Measures.FirstOrDefault(m => m.TempId == id && m.Type == type);
if (measure == default)
{
measure = new Measures();
entities.Measures.Add(measure);
}
measure.TempId = id;
measure.Type = type;
measure.Value = (float)(value ?? 0F);
entities.SaveChanges();
}
}
public void Upsert(int id, string type, string value)
{
using (var entities = new TempDataEntities())
{
var identifier = entities.Identifiers.FirstOrDefault(i => i.TempId == id && i.Type == type);
if (identifier == default)
{
identifier = new Identifiers();
entities.Identifiers.Add(identifier);
}
identifier.TempId = id;
identifier.Type = type;
identifier.Value = value;
entities.SaveChanges();
}
}
public void Upsert(Users user)
{
using (var dataEntities = new TempDataEntities())
{
var local = dataEntities.Users.FirstOrDefault(u => u.Email == user.Email) ?? new Users();
local.Email = user.Email;
local.Password = user.Password;
local.Name = user.Name;
local.Role = user.Role;
if (local.Id == default)
{
dataEntities.Users.Add(local);
}
dataEntities.SaveChanges();
}
}
public void Upsert(Pieces pieces)
{
using (var entities = new TempDataEntities())
{
var piece = entities.Pieces.FirstOrDefault(p => p.TempId == pieces.TempId) ?? new Pieces();
piece.Subject = pieces.Subject;
if (piece.TempId == default)
{
piece.TempId = pieces.TempId;
piece.CreatedBy = pieces.CreatedBy;
entities.Pieces.Add(piece);
}
entities.SaveChanges();
}
}
public void Export(int UserId, string path)
{
string serializedDatabase;
using (TempDataEntities entities = new TempDataEntities())
{
var pieces = entities.Pieces.ToList();
serializedDatabase = JsonConvert.SerializeObject(pieces, Formatting.Indented,
new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore,
NullValueHandling = NullValueHandling.Ignore,
ContractResolver = new CustomContractResolver()
});
}
var exportedDir = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Exported");
Directory.CreateDirectory(exportedDir);
File.WriteAllText(Path.Combine(exportedDir, "data.json"), serializedDatabase);
File.WriteAllText(Path.Combine(exportedDir, "CollectionTypes.json"), @"{""0"":""Arqueológico"",""1"":""Histórico"",""2"":""Paleontológico"",""3"":""Etnográfico"",""4"":""Contemporáneo""}");
File.WriteAllText(Path.Combine(exportedDir, "ConservationTypes.json"), @"{""0"":""No requiere intervencion"",""1"":""Requiere intervencion"",""2"":""Requiere intervencion urgente"",""3"":""En riesgo""}");
var files = Directory.GetFiles(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Images"), "*.*");
var p = piecesDataService.FindAll();
foreach (var file in files)
{
var name = new FileInfo(file).Name.Split('.')[0];
if (p.Where(piece => name.Equals(piece.TempId.ToString())).ToList().Count > 0)
{
var exported = Path.Combine(exportedDir, new FileInfo(file).Name);
File.Copy(file, exported, true);
}
}
ZipFile.CreateFromDirectory(exportedDir, path);
Directory.Delete(exportedDir, true);
}
