public ActionResult DeleteConfirmed(int id)
{
RawMaterialSpecificGravity rawmaterialspecificgravity = db.RawMaterialSpecificGravities.Find(id);
db.RawMaterialSpecificGravities.Remove(rawmaterialspecificgravity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,RawMaterialQCID,LabTechUserID,DenIso,DateEntered,EnteredBy,LastModified,ModifiedBy")] RawMaterialSpecificGravity rawmaterialspecificgravity)
{
if (ModelState.IsValid)
{
db.Entry(rawmaterialspecificgravity).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RawMaterialQCID = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID", rawmaterialspecificgravity.RawMaterialQCID);
ViewBag.LabTechUserID = new SelectList(db.Users, "ID", "Username", rawmaterialspecificgravity.LabTechUserID);
return(View(rawmaterialspecificgravity));
}
// GET: /RawMaterialQCForm/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RawMaterialSpecificGravity rawmaterialspecificgravity = db.RawMaterialSpecificGravities.Find(id);
if (rawmaterialspecificgravity == null)
{
return(HttpNotFound());
}
return(View(rawmaterialspecificgravity));
}
// GET: /RawMaterialQCForm/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RawMaterialSpecificGravity rawmaterialspecificgravity = db.RawMaterialSpecificGravities.Find(id);
if (rawmaterialspecificgravity == null)
{
return(HttpNotFound());
}
ViewBag.RawMaterialQCID = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID", rawmaterialspecificgravity.RawMaterialQCID);
ViewBag.LabTechUserID = new SelectList(db.Users, "ID", "Username", rawmaterialspecificgravity.LabTechUserID);
return(View(rawmaterialspecificgravity));
}
public int Add(RawMaterialSpecificGravityDto dto)
{
try
{
var entity = new RawMaterialSpecificGravity();
Mapper.Map(dto, entity);
_repository.Repository <RawMaterialSpecificGravity>().Insert(entity);
_repository.Save();
return(entity.ID);
}
catch (DbEntityValidationException valEx)
{
HandleValidationException(valEx);
return(-1);
}
catch (Exception ex)
{
LogException(ex);
throw;
}
}
public void DeleteComplete(int id)
{
try
{
//TPOFormulationRawMaterials handle
List <int> specificGravityList = new List <int>();
List <int> specificGravityDetailsList = new List <int>();
List <RawMaterialSpecificGravity> finalSpecificGravitys = new List <RawMaterialSpecificGravity>();
List <RawMaterialSpecificGravityDetail> finalSpecificGravitysDetails = new List <RawMaterialSpecificGravityDetail>();
List <RawMaterialQCRedHold> finalRedHolds = new List <RawMaterialQCRedHold>();
List <RawMaterialQC> rawMaterialQCList =
_repository.Repository <RawMaterialQC>()
.GetAll()
.Where(q => q.RawMaterialReceivedID == id)
.ToList();
List <TPOCurrentRawMaterial> tpoCurrentRawMaterialsList =
_repository.Repository <TPOCurrentRawMaterial>()
.GetAll().Where(q => q.RawMaterialReceivedID == id)
.ToList();
foreach (RawMaterialQC rawMaterialQC in rawMaterialQCList)
{
specificGravityList.Add(rawMaterialQC.ID);
}
foreach (int specific in specificGravityList)
{
RawMaterialQCRedHold redholdmodel =
_repository.Repository <RawMaterialQCRedHold>()
.GetAll()
.Where(q => q.RawMaterialQCID == specific && q.RawMaterialReceivedID == id)
.ToList()
.FirstOrDefault();
if (redholdmodel != null)
{
finalRedHolds.Add(redholdmodel);
}
RawMaterialSpecificGravity specificGravitymodel =
_repository.Repository <RawMaterialSpecificGravity>()
.GetAll()
.Where(q => q.RawMaterialQCID == specific)
.ToList()
.FirstOrDefault();
if (specificGravitymodel != null)
{
finalSpecificGravitys.Add(specificGravitymodel);
}
}
foreach (RawMaterialSpecificGravity specificGravity in finalSpecificGravitys)
{
specificGravityDetailsList.Add(specificGravity.ID);
}
foreach (int detail in specificGravityDetailsList)
{
RawMaterialSpecificGravityDetail specificGravityDetailmodel =
_repository.Repository <RawMaterialSpecificGravityDetail>()
.GetAll()
.Where(q => q.RawMaterialSpecGravID == detail)
.ToList()
.FirstOrDefault();
if (specificGravityDetailmodel != null)
{
finalSpecificGravitysDetails.Add(specificGravityDetailmodel);
}
}
foreach (RawMaterialSpecificGravityDetail specificGravityDetail in finalSpecificGravitysDetails)
{
Mapper.Map <RawMaterialSpecificGravityDetail, RawMaterialQcSpecificGravityDetailDto>(specificGravityDetail);
_repository.Repository <RawMaterialSpecificGravityDetail>().Delete(specificGravityDetail);
}
foreach (RawMaterialSpecificGravity specificGravity in finalSpecificGravitys)
{
Mapper.Map <RawMaterialSpecificGravity, RawMaterialSpecificGravityDto>(specificGravity);
_repository.Repository <RawMaterialSpecificGravity>().Delete(specificGravity);
}
foreach (RawMaterialQCRedHold redhold in finalRedHolds)
{
Mapper.Map <RawMaterialQCRedHold, RawMaterialQcRedHoldDto>(redhold);
_repository.Repository <RawMaterialQCRedHold>().Delete(redhold);
}
foreach (RawMaterialQC rawMaterialQC in rawMaterialQCList)
{
Mapper.Map <RawMaterialQC, RawMaterialQcDto>(rawMaterialQC);
_repository.Repository <RawMaterialQC>().Delete(rawMaterialQC);
}
foreach (TPOCurrentRawMaterial tpoCurrentRawMaterial in tpoCurrentRawMaterialsList)
{
Mapper.Map <TPOCurrentRawMaterial, TPOCurrentRawMaterialDto>(tpoCurrentRawMaterial);
_repository.Repository <TPOCurrentRawMaterial>().Delete(tpoCurrentRawMaterial);
}
_repository.Repository <RawMaterialReceived>().Delete(id);
_repository.Save();
}
catch (DbEntityValidationException valEx)
{
var sb = new StringBuilder();
foreach (var failure in valEx.EntityValidationErrors)
{
sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
foreach (var error in failure.ValidationErrors)
{
sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
sb.AppendLine();
}
}
throw new DbEntityValidationException(
"Entity Validation Failed - errors follow:\n" +
sb.ToString(), valEx
); // Add the original exception as the innerException
}
catch (Exception ex)
{
LogException(ex);
throw;
}
}
public RawMaterialQCSpecificGravityDTO GetByQCID(int id)
{
using (var context = new TPOMVCApplicationEntities())
{
var thisItem = (from a in context.RawMaterialSpecificGravities
where a.RawMaterialQCID == id
select a);
if (thisItem.Any())
{
return(MapToDTO(thisItem.FirstOrDefault()));
}
var newEntity = new RawMaterialSpecificGravity
{
RawMaterialQCID = id,
DenIso = 0.7851,
DateEntered = DateTime.Now,
EnteredBy = "acorrington",
LastModified = DateTime.Now,
ModifiedBy = "acorrington"
};
newEntity.RawMaterialQC = (from a in context.RawMaterialQCs
where a.ID == id
select a).FirstOrDefault();
for (int i = 0; i < 5; i++)
{
var dry = new TPO.DL.Models.RawMaterialSpecificGravityDetail
{
Order = (i + 1),
Submerged = false,
DateEntered = DateTime.Now,
EnteredBy = "acorrington",
LastModified = DateTime.Now,
ModifiedBy = "acorrington"
};
var submerged = new TPO.DL.Models.RawMaterialSpecificGravityDetail
{
Order = (i + 1),
Submerged = true,
DateEntered = DateTime.Now,
EnteredBy = "acorrington",
LastModified = DateTime.Now,
ModifiedBy = "acorrington"
};
newEntity.RawMaterialSpecificGravityDetails.Add(dry);
newEntity.RawMaterialSpecificGravityDetails.Add(submerged);
}
context.RawMaterialSpecificGravities.Add(newEntity);
context.SaveChanges();
var createdItem = (from a in context.RawMaterialSpecificGravities
where a.RawMaterialQCID == id
select a);
if (createdItem.Any())
{
return(MapToDTO(createdItem.FirstOrDefault()));
}
throw new Exception("Error creating Specific Gravity record.");
}
}
