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 void Delete(int id)
{
using (var entities = new TempDataEntities())
{
entities.Pieces.Remove(entities.Pieces.First(p => p.TempId == id));
entities.SaveChanges();
}
}
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();
}
}