/// <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); }