public int UpdateOrderReturnDetail(OrderReturnDetails orderReturnDetail)
{
string sql = @"UPDATE [OrderReturnDetails] SET [OrderId] = @OrderId,
[ProductId] = @ProductId, [Quantity] = @Quantity, [CGST] = @CGST, [SGST] = @SGST,
[IGST] = @IGST, [Discount] = @Discount, [NetPrice] = @NetPrice, [OrderReturnGroup] = @OrderReturnGroup,
[OrderReturnElementCode] = @OrderReturnElementCode, [Comments] = @Comments, [LastUpdatedById] = @LastUpdatedById, [LastUpdatedDate] = @LastUpdatedDate WHERE [Id] = @Id";
var id = db.Connection.Query <int>(sql, orderReturnDetail).FirstOrDefault();
return(id);
}
public int InsertOrderReturnDetail(OrderReturnDetails orderReturnDetail)
{
string sql = @"INSERT INTO [OrderReturnDetails]
([OrderId],[ProductId],[Quantity],[CGST],[SGST],[IGST],[Discount],[NetPrice],
[OrderReturnGroup],[OrderReturnElementCode],[Comments], [CreatedById], [CreatedDate], [LastUpdatedById], [LastUpdatedDate])
VALUES
(@OrderId, @ProductId, @Quantity, @CGST, @SGST, @IGST, @Discount, @NetPrice,
@OrderReturnGroup, @OrderReturnElementCode, @Comments, @CreatedById, @CreatedDate, @LastUpdatedById, @LastUpdatedDate) ; SELECT CAST(SCOPE_IDENTITY() as int)" ;
var id = db.Connection.Query <int>(sql, orderReturnDetail).FirstOrDefault();
return(id);
}