/// <summary>
/// Insert a Customer object into DB.
/// </summary>
/// <param name="c">Customer object.</param>
/// <returns>Bool indicate if succeed.</returns>
public static bool InsertCustomer(Customer c)
{
// set DBObject
string sql = "INSERT INTO Customer(FirstName,LastName,Phone,City) VALUES(@FN,@LN,@PH,@CT)";
dbo.ConnectionString = connectionString;
dbo.SetProvider("System.Data.SqlClient");
// set parameters (let database infer DBType)
var fNamePar = dbo.CreateParameter();
fNamePar.Value = c.FirstName;
fNamePar.ParameterName = "@FN";
var lNamePar = dbo.CreateParameter();
lNamePar.Value = c.LastName;
lNamePar.ParameterName = "@LN";
var phonePar = dbo.CreateParameter();
phonePar.Value = c.Phone;
phonePar.ParameterName = "@PH";
var cityPar = dbo.CreateParameter();
cityPar.Value = c.City;
cityPar.ParameterName = "@CT";
var parameters = new IDataParameter[] { fNamePar, lNamePar, phonePar, cityPar };
// call execute method
var rowsAffected = dbo.NonQuery(sql, CommandType.Text, parameters);
return(rowsAffected > 0 ? true : false);
}
public static bool LeaseSelectedSlip(Slip s, Customer c)
{
// set DBObject
string sql = "INSERT INTO Lease(SlipID,CustomerID) VALUES(@SlipID,@CustomerID)";
dbo.ConnectionString = connectionString;
dbo.SetProvider("System.Data.SqlClient");
// set parameters (let database infer DBType)
var slipIDPar = dbo.CreateParameter();
slipIDPar.Value = s.SlipID;
slipIDPar.ParameterName = "@SlipID";
var custIDPar = dbo.CreateParameter();
custIDPar.Value = c.CustomerID;
custIDPar.ParameterName = "@CustomerID";
var parameters = new IDataParameter[] { slipIDPar, custIDPar };
// call execute method
var rowsAffected = dbo.NonQuery(sql, CommandType.Text, parameters);
return(rowsAffected > 0 ? true : false);
}
