public void Destroy(Shipping_RecordsViewModel Record)
{
if (!UpdateDatabase)
{
var target = Read().FirstOrDefault(e => e.RecordID == Record.RecordID);
if (target != null)
{
GetAll().Remove(target);
}
}
else
{
var entity = new Shipping_Records
{
RecordID = Record.RecordID
};
Entities.Shipping_Records.Attach(entity);
Entities.Shipping_Records.Remove(entity);
var record = Entities.Shipping_Records.Where(s => s.RecordID == entity.RecordID);
foreach (var e in record)
{
Entities.Shipping_Records.Remove(e);
}
Entities.SaveChanges();
}
}
public void Update(Shipping_RecordsViewModel Record)
{
//Record.Shipping_Catalog_Products = null;
if (!UpdateDatabase)
{
var target = One(e => e.RecordID == Record.RecordID);
if (target != null)
{
target.RecordTransfer = Record.RecordTransfer;
}
}
else
{
var entity = new Shipping_Records
{
RecordID = Record.RecordID,
RecordTransfer = Record.RecordTransfer,
ClientID = Record.ClientID,
ProductID = Record.ProductID,
RecordQuantity = Record.RecordQuantity,
RecordDate = Record.RecordDate,
RecordFedexTracking = Record.RecordFedexTracking,
RecordControlBoxNo = Record.RecordControlBoxNo,
RecordPieceBoxNo = Record.RecordPieceBoxNo,
ShipmentTypeID = Record.ShipmentTypeID,
RecordServiceType = Record.RecordServiceType,
RecordComment = Record.RecordComment,
RecordWorkOrder = Record.RecordWorkOrder,
RecordSerialNo = Record.RecordSerialNo,
RecordTrackingId = Record.RecordTrackingId,
RecordRework = Record.RecordRework,
RecordComment1 = Record.RecordComment1,
RecordComment2 = Record.RecordComment2,
RecordFAI = Record.RecordFAI,
RecordSeguritySeal1 = Record.RecordSeguritySeal1,
RecordSeguritySeal2 = Record.RecordSeguritySeal2,
RecordSeguritySeal3 = Record.RecordSeguritySeal3,
RecordSeguritySeal4 = Record.RecordSeguritySeal4
};
Entities.Shipping_Records.Add(entity);
Entities.Entry(entity).State = EntityState.Modified;
Entities.SaveChanges();
}
}
public void Create(Shipping_RecordsViewModel Record)
{
if (!UpdateDatabase)
{
var firts = Read().OrderByDescending(e => e.RecordID).FirstOrDefault();
var id = (firts != null) ? firts.RecordID : 0;
Record.RecordID = id + 1;
GetAll().Insert(0, Record);
}
else
{
var entity = new Shipping_Records
{
ClientID = Record.ClientID,
ProductID = Record.ProductID,
RecordQuantity = Record.RecordQuantity,
RecordDate = Record.RecordDate,
RecordFedexTracking = Record.RecordFedexTracking,
RecordControlBoxNo = Record.RecordControlBoxNo,
RecordPieceBoxNo = Record.RecordPieceBoxNo,
ShipmentTypeID = Record.ShipmentTypeID,
RecordServiceType = Record.RecordServiceType,
RecordComment = Record.RecordComment,
RecordWorkOrder = Record.RecordWorkOrder,
RecordSerialNo = Record.RecordSerialNo,
RecordTrackingId = Record.RecordTrackingId,
RecordRework = Record.RecordRework,
RecordComment1 = Record.RecordComment1,
RecordComment2 = Record.RecordComment2,
RecordFAI = Record.RecordFAI,
RecordTransfer = Record.RecordTransfer,
RecordSeguritySeal1 = Record.RecordSeguritySeal1
};
Entities.Shipping_Records.Add(entity);
Entities.SaveChanges();
Record.RecordID = entity.RecordID;
}
}
