public void Update(Domain.DTO.RawMaterialReceivedDTO rawMaterialReceived)
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var entity = (from d in context.RawMaterialReceiveds
where d.ID == rawMaterialReceived.ID
select d).SingleOrDefault();
//TODO: Add mapper
entity.DateEntered = rawMaterialReceived.DateEntered;
entity.EnteredBy = rawMaterialReceived.EnteredBy;
entity.LastModified = rawMaterialReceived.LastModified;
entity.LotNumber = rawMaterialReceived.LotNumber;
entity.ModifiedBy = rawMaterialReceived.ModifiedBy;
entity.PlantID = rawMaterialReceived.PlantID;
entity.RawMaterialID = rawMaterialReceived.RawMaterialID;
entity.QuantityNotReceived = rawMaterialReceived.QuantityNotReceived;
entity.QuantityReceived = rawMaterialReceived.QuantityReceived;
entity.QuantityShipped = rawMaterialReceived.QuantityShipped;
entity.QuantityUsedThisLot = rawMaterialReceived.QuantityUsedThisLot;
entity.CoA = rawMaterialReceived.CoA;
entity.ReceivedSizeLimitID = rawMaterialReceived.ReceivedSizeLimitID;
entity.UOMID = rawMaterialReceived.UoMID;
context.SaveChanges();
}
}
public void Add(Domain.DTO.RawMaterialReceivedDTO rawMaterialReceived)
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var newRawMaterialRecieved = MapToDBO(new DL.Models.RawMaterialReceived(), rawMaterialReceived);
context.RawMaterialReceiveds.Add(newRawMaterialRecieved);
context.SaveChanges();
}
}
public List <Domain.DTO.RawMaterialReceivedDTO> GetAll()
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var allItems = (from a in context.RawMaterialReceiveds
select a);
return(CreateList(allItems));
}
}
public List <Int32> GetAvailableRawMaterialIds()
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var allItems = (from a in context.RawMaterialReceiveds
select a.RawMaterialID)
.Distinct();
return(allItems.ToList());
}
}
public void Delete(int id)
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var del = (from d in context.RawMaterialReceiveds
where d.ID == id
select d).SingleOrDefault();
context.RawMaterialReceiveds.Remove(del);
context.SaveChanges();
}
}
public Domain.DTO.RawMaterialReceivedDTO GetById(int id)
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var item = (from a in context.RawMaterialReceiveds
where a.ID == id
select a).SingleOrDefault();
return(MapToDTO(item));
}
}
public List <Domain.DTO.RawMaterialReceivedDTO> GetAll(int plantId, int materialId)
{
using (var context = new DL.Models.TPOMVCApplicationEntities())
{
var allItems = (from a in context.RawMaterialReceiveds
where a.PlantID == plantId && a.RawMaterialID == materialId
select a);
return(CreateList(allItems));
}
}
