static SalesOrderHeader Insert(DBConnectionWrapper conn, DBTransactionWrapper trans = null)
{
SalesOrderHeader order = new SalesOrderHeader
{
RevisionNumber = 8,
OrderDate = DateTime.Today,
DueDate = DateTime.Today.AddDays(7),
Status = 1,
OnlineOrderFlag = true,
CustomerID = 25252,
BillToAddressID = 20850,
ShipToAddressID = 20850,
ShipMethodID = 1,
SubTotal = 100m,
TaxAmt = 0m,
Freight = 0m,
Comment = "TEST",
Rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
int nor = conn.Insert(ref order, trans);
var id = conn.GetSingleValue <int>("SELECT @@IDENTITY", trans);
order.SalesOrderId = id;
Console.WriteLine(nor + " record inserted.");
return(order);
}
static Employee Insert(DBConnectionWrapper conn, DBTransactionWrapper trans = null)
{
Employee obj = new Employee
{
EMPLOYEE_ID = 207,
FIRST_NAME = "Kevin",
LAST_NAME = "Jin",
EMAIL = "kevin.jin",
PHONE_NUMBER = "123.456.7890",
HIRE_DATE = DateTime.Now,
JOB_ID = "AC_ACCOUNT",
SALARY = 8300m,
COMMISSION_PCT = null,
MANAGER_ID = 205,
DEPARTMENT_ID = 110
};
var ret = conn.Insert(ref obj, trans);
Console.WriteLine(ret + " rows inserted");
return(obj);
}
