public void Delete(int id) { JobReceiveQAAttribute Temp = db.JobReceiveQAAttribute.Find(id); Temp.ObjectState = Model.ObjectState.Deleted; db.JobReceiveQAAttribute.Remove(Temp); }
public JobReceiveQALine Create(JobReceiveQAAttributeViewModel pt, string UserName) { JobReceiveQAHeader header = new JobReceiveQAHeader(); header = Mapper.Map <JobReceiveQAAttributeViewModel, JobReceiveQAHeader>(pt); _JobReceiveQAHeaderService.Create(header, UserName); JobReceiveQALine Line = Mapper.Map <JobReceiveQAAttributeViewModel, JobReceiveQALine>(pt); Line.Sr = new JobReceiveQALineService(db, _unitOfWork).GetMaxSr(Line.JobReceiveQAHeaderId); Line.FailQty = Line.QAQty - Line.Qty; Line.FailDealQty = Line.FailQty * Line.UnitConversionMultiplier; new JobReceiveLineStatusService(_unitOfWork).UpdateJobReceiveQtyOnQA(Mapper.Map <JobReceiveQALineViewModel>(Line), pt.DocDate, ref db); new JobReceiveQALineService(db, _unitOfWork).Create(Line, UserName); JobReceiveQALineExtended LineExtended = new JobReceiveQALineExtended(); LineExtended.JobReceiveQALineId = Line.JobReceiveQALineId; LineExtended.Length = pt.Length; LineExtended.Width = pt.Width; LineExtended.Height = pt.Height; LineExtended.ObjectState = ObjectState.Added; db.JobReceiveQALineExtended.Add(LineExtended); List <QAGroupLineLineViewModel> tem = pt.QAGroupLine; if (tem != null) { foreach (var item in tem) { JobReceiveQAAttribute pa = new JobReceiveQAAttribute(); pa.JobReceiveQALineId = Line.JobReceiveQALineId; pa.QAGroupLineId = item.QAGroupLineId; pa.Value = item.Value; pa.Remark = item.Remarks; pa.CreatedBy = UserName; pa.ModifiedBy = UserName; pa.CreatedDate = DateTime.Now; pa.ModifiedDate = DateTime.Now; pa.ObjectState = ObjectState.Added; db.JobReceiveQAAttribute.Add(pa); } } return(Line); }
public void Update(JobReceiveQAAttributeViewModel pt, string UserName) { JobReceiveQAHeader header = new JobReceiveQAHeaderService(db).Find(pt.JobReceiveQAHeaderId); header.DocDate = pt.DocDate; header.DocNo = pt.DocNo; header.QAById = pt.QAById; header.Remark = pt.Remark; _JobReceiveQAHeaderService.Update(header, UserName); JobReceiveQALine Line = new JobReceiveQALineService(db, _unitOfWork).Find(pt.JobReceiveQALineId); Line.Marks = pt.Marks; Line.PenaltyRate = pt.PenaltyRate; Line.PenaltyAmt = pt.PenaltyAmt; Line.Weight = pt.Weight; Line.UnitConversionMultiplier = pt.UnitConversionMultiplier; Line.DealQty = pt.DealQty; Line.FailQty = Line.QAQty - Line.Qty; Line.FailDealQty = Line.FailQty * Line.UnitConversionMultiplier; new JobReceiveLineStatusService(_unitOfWork).UpdateJobReceiveQtyOnQA(Mapper.Map <JobReceiveQALineViewModel>(Line), pt.DocDate, ref db); new JobReceiveQALineService(db, _unitOfWork).Update(Line, UserName); JobReceiveQALineExtended LineExtended = (from Ld in db.JobReceiveQALineExtended where Ld.JobReceiveQALineId == pt.JobReceiveQALineId select Ld).FirstOrDefault(); if (LineExtended != null) { LineExtended.Length = pt.Length; LineExtended.Width = pt.Width; LineExtended.Height = pt.Height; LineExtended.ObjectState = ObjectState.Modified; db.JobReceiveQALineExtended.Add(LineExtended); } List <QAGroupLineLineViewModel> tem = pt.QAGroupLine; if (tem != null) { foreach (var item in tem) { if (item.JobReceiveQAAttributeId != null && item.JobReceiveQAAttributeId != 0) { JobReceiveQAAttribute pa = Find((int)item.JobReceiveQAAttributeId); pa.QAGroupLineId = item.QAGroupLineId; pa.Value = item.Value; pa.Remark = item.Remarks; pa.ModifiedBy = UserName; pa.ModifiedDate = DateTime.Now; pa.ObjectState = ObjectState.Modified; db.JobReceiveQAAttribute.Add(pa); } else { JobReceiveQAAttribute pa = new JobReceiveQAAttribute(); pa.JobReceiveQALineId = Line.JobReceiveQALineId; pa.QAGroupLineId = item.QAGroupLineId; pa.Value = item.Value; pa.Remark = item.Remarks; pa.CreatedBy = UserName; pa.ModifiedBy = UserName; pa.CreatedDate = DateTime.Now; pa.ModifiedDate = DateTime.Now; pa.ObjectState = ObjectState.Added; db.JobReceiveQAAttribute.Add(pa); } } } }