public int Add(RawMaterialQcDto dto)
{
var entity = new RawMaterialQC();
try
{
dto.LastModified = DateTime.Now;
dto.QCVisualInspectionID = 1;
Mapper.Map(dto, entity);
_repository.Repository <RawMaterialQC>().Insert(entity);
_repository.Save();
}
catch (DbEntityValidationException valEx)
{
HandleValidationException(valEx);
}
catch (Exception ex)
{
LogException(ex);
throw;
}
return(entity.ID);
}
public ActionResult DeleteConfirmed(int id)
{
RawMaterialQC rawmaterialqc = db.RawMaterialQCs.Find(id);
db.RawMaterialQCs.Remove(rawmaterialqc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,PlantID,QCTechUserID,RawMaterialID,RawMaterialLotID,VisualInspection,SpecGrav,ColorCoA,ColorFS,MFCoA,MFFS,ACCoA,ACFS,MoistCoA,MoistFS,CBCoA,CBFS,BoxCarTested,Comments,DateEntered,EnteredBy,LastModified,ModifiedBy")] RawMaterialQC rawmaterialqc)
{
if (ModelState.IsValid)
{
db.Entry(rawmaterialqc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PlantID = new SelectList(db.Plants, "ID", "Code", rawmaterialqc.PlantID);
ViewBag.QCTechUserID = new SelectList(db.Users, "ID", "Username", rawmaterialqc.QCTechUserID);
return(View(rawmaterialqc));
}
// GET: /RawMaterialQCTest/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RawMaterialQC rawmaterialqc = db.RawMaterialQCs.Find(id);
if (rawmaterialqc == null)
{
return(HttpNotFound());
}
return(View(rawmaterialqc));
}
// GET: /RawMaterialRedandHold/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RawMaterialQC rawmaterialqc = db.RawMaterialQCs.Find(id);
if (rawmaterialqc == null)
{
return(HttpNotFound());
}
ViewBag.PlantID = new SelectList(db.Plants, "ID", "Code", rawmaterialqc.PlantID);
ViewBag.QCTechUserID = new SelectList(db.Users, "ID", "Username", rawmaterialqc.QCTechUserID);
return(View(rawmaterialqc));
}
public void Update(RawMaterialQCSpecificGravityDTO dto)
{
try
{
using (var context = new TPOMVCApplicationEntities())
{
// Save Specific gravity
var toUpdate = context.RawMaterialSpecificGravities.Find(dto.ID);
toUpdate.RawMaterialQCID = dto.RawMaterialQCID;
toUpdate.LabTechUserID = dto.LabTechUserID;
toUpdate.DenIso = dto.DenIso;
toUpdate.DateEntered = dto.DateEntered ?? DateTime.Now;
toUpdate.EnteredBy = dto.EnteredBy;
toUpdate.ModifiedBy = dto.ModifiedBy;
toUpdate.LastModified = DateTime.Now;
context.Entry(toUpdate).State = EntityState.Modified;
foreach (var detail in toUpdate.RawMaterialSpecificGravityDetails)
{
var dtoDetail = dto.RawMaterialSpecificGravityDetails.Where(d => d.ID == detail.ID);
if (dtoDetail.Any())
{
detail.Value = dtoDetail.First().Value;
detail.LastModified = DateTime.Now;
}
}
// TODO: Details
// Set Specific Gravity on Parent QC record.
RawMaterialQC toUpdateRawMaterialQC = context.RawMaterialQCs.Find(dto.RawMaterialQCID);
toUpdateRawMaterialQC.SpecGrav = dto.AverageGravity;
context.Entry(toUpdateRawMaterialQC).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
