public bool FindAndReplaceAdjustmentVoucherDetails(string voucherId, List <AdjustmentVoucherDetailsDTO> detailsList) { //delete existing records context.AdjustmentVouchersDetails.RemoveRange(context.AdjustmentVouchersDetails.Where(x => x.VoucherId == voucherId)); //replace records foreach (AdjustmentVoucherDetailsDTO newItem in detailsList) { AdjustmentVoucherDetailsEF d = new AdjustmentVoucherDetailsEF(); d.ItemCode = newItem.ItemCode; d.Quantity = newItem.Quantity; d.Reason = newItem.Reason; d.VoucherId = voucherId; context.AdjustmentVouchersDetails.Add(d); } context.SaveChanges(); return(false); }
public bool AddNewAdjustmentVoucherAndDetails(AdjustmentVoucherEF voucher, List <AdjustmentVoucherDetailsDTO> voucherDetailsList) { var existingRecord = context.AdjustmentVouchers.Find(voucher.VoucherId); if (existingRecord == null) { context.AdjustmentVouchers.Add(voucher); foreach (AdjustmentVoucherDetailsDTO newItem in voucherDetailsList) { AdjustmentVoucherDetailsEF d = new AdjustmentVoucherDetailsEF(); d.ItemCode = newItem.ItemCode; d.Quantity = newItem.Quantity; d.Reason = newItem.Reason; d.VoucherId = voucher.VoucherId; context.AdjustmentVouchersDetails.Add(d); } context.SaveChanges(); return(true); } return(false); }