// POST: api/Customer
public Customer Post([FromBody] Customer value)
{
var custIdTask = new GetCustomerIdTask();
custIdTask.Execute();
value.CustomerID = custIdTask.Out;
string date = DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss");
string ins =
string.Format(@"INSERT INTO DBA.Customers (CustomerID, BillCompany, BillFName, BillMI, BillLName, BillAddress, BillAddress2, BillCity, BillState, BillZip, BillCountry, BillPhone, BillExt, Misc1,Misc2, LastUpdate, DateCreated, EMail, ShipFName)
VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18})",
value.CustomerID.GetSqlCompatible(true),
value.Company.GetSqlCompatible(true),
value.FirstName.GetSqlCompatible(true),
value.MiddleInitial.GetSqlCompatible(true),
value.LastName.GetSqlCompatible(true),
value.Address1.GetSqlCompatible(true),
value.Address2.GetSqlCompatible(true),
value.City.GetSqlCompatible(true),
value.State.GetSqlCompatible(true),
value.Zip.GetSqlCompatible(true),
value.Country.GetSqlCompatible(true),
value.HomePhone.GetSqlCompatible(true),
value.PhoneExt.GetSqlCompatible(true),
value.CellPhone.GetSqlCompatible(true),
value.Misc2.GetSqlCompatible(true),
date.GetSqlCompatible(true),
date.GetSqlCompatible(true),
value.Email.GetSqlCompatible(),
value.FirstName.GetSqlCompatible()
);
SharedDb.PosimDb.Execute(ins);
return Get(value.CustomerID);
}
// POST: api/Customer
public Customer Post([FromBody] Customer value)
{
var custIdTask = new GetCustomerIdTask();
custIdTask.Execute();
value.CustomerID = custIdTask.Out;
string date = DateTime.Now.ToString("yyyy'-'MM'-'dd HH':'mm':'ss");
string ins =
string.Format(@"INSERT INTO DBA.Customers (CustomerID, BillCompany, BillFName, BillMI, BillLName, BillAddress, BillAddress2, BillCity, BillState, BillZip, BillCountry, BillPhone, BillExt, Misc1,Misc2, LastUpdate, DateCreated, EMail, ShipFName)
VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18})" ,
value.CustomerID.GetSqlCompatible(true),
value.Company.GetSqlCompatible(true),
value.FirstName.GetSqlCompatible(true),
value.MiddleInitial.GetSqlCompatible(true),
value.LastName.GetSqlCompatible(true),
value.Address1.GetSqlCompatible(true),
value.Address2.GetSqlCompatible(true),
value.City.GetSqlCompatible(true),
value.State.GetSqlCompatible(true),
value.Zip.GetSqlCompatible(true),
value.Country.GetSqlCompatible(true),
value.HomePhone.GetSqlCompatible(true),
value.PhoneExt.GetSqlCompatible(true),
value.CellPhone.GetSqlCompatible(true),
value.Misc2.GetSqlCompatible(true),
date.GetSqlCompatible(true),
date.GetSqlCompatible(true),
value.Email.GetSqlCompatible(),
value.FirstName.GetSqlCompatible()
);
SharedDb.PosimDb.Execute(ins);
return(Get(value.CustomerID));
}
