public int Insert(InvoiceDomain newItem) { var sql = Sql.Builder.Append(" INSERT INTO Invoice (TypeId, ClientId, InvoiceNumber, IssueDate) ") .Append(" VALUES (@0, @1, @2, @3) ", EnumHelper.EnumTextToInt(newItem.InvoiceType, typeof(Enums.InvoiceType)), newItem.Client.Id, newItem.InvoiceNumber, newItem.IssueDate); sql.Append(" SELECT SCOPE_IDENTITY() "); return DataContext.ExecuteScalar<int>(sql); }
public void Update(InvoiceDomain editedItem) { var sql = Sql.Builder.Append("UPDATE Invoice ") .Append(" SET TypeId = @0, ClientId = @1, InvoiceNumber = @2, IssueDate = @3 ", EnumHelper.EnumTextToInt(editedItem.InvoiceType, typeof(Enums.InvoiceType)), editedItem.Client.Id, editedItem.InvoiceNumber, editedItem.IssueDate) .Append(" WHERE ID = @0 ", editedItem.Id); DataContext.Execute(sql); }