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 ActionResult Destroy([DataSourceRequest] DataSourceRequest request, Shipping_RecordsViewModel Datos)
{
RouteValueDictionary routeValues;
_SumarioEmbarquesService.Destroy(Datos);
routeValues = this.GridRouteValues();
return(Json(new[] { Datos }.ToDataSourceResult(request, ModelState)));
}
public Shipping_RecordsViewModel TakeLast()
{
var ultimo = GetAll().OrderByDescending(des => des.RecordID).Select(sel => new Shipping_RecordsViewModel
{
RecordControlBoxNo = sel.RecordControlBoxNo,
RecordFedexTracking = sel.RecordFedexTracking,
RecordPieceBoxNo = sel.RecordPieceBoxNo,
ClientID = sel.ClientID,
Clients = new ClientesViewModel()
{
ClientName = sel.Clients.ClientName,
ClientCompany = sel.Clients.ClientCompany
},
ShipmentTypeID = sel.ShipmentTypeID,
CatalogShipmentType = new CatalogShipmentTypeViewModel()
{
ShipmentType = sel.CatalogShipmentType.ShipmentType
},
RecordServiceType = sel.RecordServiceType,
RecordTransfer = sel.RecordTransfer,
RecordSeguritySeal1 = sel.RecordSeguritySeal1
}).FirstOrDefault();
if (ultimo == null)
{
ultimo = new Shipping_RecordsViewModel
{
RecordTransfer = "",
ClientID = 0,
ProductID = 0,
RecordQuantity = 0,
RecordDate = DateTime.Now,
RecordFedexTracking = 0,
RecordControlBoxNo = 0,
RecordPieceBoxNo = 0,
ShipmentTypeID = 0,
RecordServiceType = "",
RecordComment = "",
RecordWorkOrder = 0,
RecordSerialNo = "",
RecordTrackingId = 0,
RecordRework = false,
RecordComment1 = "",
RecordComment2 = "",
RecordFAI = false,
RecordSeguritySeal1 = "",
RecordSeguritySeal2 = "",
RecordSeguritySeal3 = "",
RecordSeguritySeal4 = ""
};
}
return(ultimo);
}
public ActionResult Update([DataSourceRequest] DataSourceRequest request, Shipping_RecordsViewModel Datos)
{
try
{
_SumarioEmbarquesService.Update(Datos);
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException ex)
{
Debug.WriteLine("ErrorMessage: " + ex.EntityValidationErrors);
return(RedirectToAction("Index"));
}
}
public ActionResult Create([Bind(Include = "RecordID,ClientID,ProductID,RecordQuantity,RecordDate,RecordFedexTracking,RecordControlBoxNo,RecordPieceBoxNo,ShipmentTypeID,RecordServiceType,RecordComment,RecordWorkOrder,RecordSerialNo,RecordTrackingId,RecordRework,RecordComment1,RecordComment2,RecordFAI,RecordTransfer,RecordSeguritySeal1,")] Shipping_RecordsViewModel Perro)
{
bool va1 = false;
bool va2 = false;
if (Perro != null && ModelState.IsValid)
{
if (Perro.RecordWorkOrder != null && !_ServiceSR.WOrderUnik((int)Perro.RecordWorkOrder))
{ /*Si es diferente de nulo y no esta repetido en la BD*/
ViewBag.showMs = 3; //WorkOrder
return(View("Create", Perro));
}
else
{
va1 = true;
}
if (Perro.RecordTrackingId != null && !_ServiceSR.TID((int)Perro.RecordTrackingId))
{
/*Si es diferente de nulo y no esta repetido en la BD*/
ViewBag.showMs = 4;
return(View("Create", Perro));
}
else
{
va2 = true;
}
if (va1 && va2)
{
ViewBag.showMs = 1;
_ServiceSR.Create(Perro);
ModelState.Clear();
Perro = _ServiceSR.TakeLast();
return(View("Create", Perro));
}
else
{
return(View("Create", Perro));
}
}
else
{
ViewBag.showMs = 2;
return(View("Create", Perro));
}
}
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;
}
}
public ActionResult Create()
{
Shipping_RecordsViewModel Perro = _ServiceSR.TakeLast();
return(View(Perro));
}