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);
}
