/// <summary> /// Add a new entry to the DeliveryDriver table /// </summary> public static DeliveryDriver Add(int driversEmployeeId, int cashiersEmployeeId, double amountBankrolled) { DeliveryDriver result = null; DateTime startTime = DateTime.Now; SqlConnection cn = GetConnection(); string cmd = "AddDeliveryDriver"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@DeliveryDriverEmployeeId", SqlDbType.Int, driversEmployeeId); BuildSqlParameter(sqlCmd, "@DeliveryDriverCashierEmployeeId", SqlDbType.Int, cashiersEmployeeId); BuildSqlParameter(sqlCmd, "@DeliveryDriverStart", SqlDbType.DateTime, startTime); BuildSqlParameter(sqlCmd, "@DeliveryDriverEnd", SqlDbType.DateTime, null); BuildSqlParameter(sqlCmd, "@DeliveryDriverAmountBankrolled", SqlDbType.Float, amountBankrolled); BuildSqlParameter(sqlCmd, "@DeliveryDriverId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new DeliveryDriver(Convert.ToInt32(sqlCmd.Parameters["@DeliveryDriverId"].Value), driversEmployeeId, cashiersEmployeeId, amountBankrolled, startTime, null, null); } } FinishedWithConnection(cn); return(result); }
/// <summary> /// Update an entry in the DeliveryDriver table /// </summary> public static bool Update(DeliveryDriver deliveryDriver) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, deliveryDriver); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the DeliveryDriver table /// </summary> public static DeliveryDriver Get(int id) { DeliveryDriver result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static DeliveryDriver Get(SqlConnection cn, int id) { DeliveryDriver result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM DeliveryDriver WHERE DeliveryDriverId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildDeliveryDriver(rdr); } } } return(result); }
/// <summary> /// Delete an entry from the DeliveryDriver table /// </summary> public static bool Delete(int id) { Int32 rowsAffected = 0; SqlConnection cn = GetConnection(); DeliveryDriver deliveryDriver = Get(cn, id); if (deliveryDriver != null) { using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "DELETE FROM DeliveryDriver WHERE DeliveryDriverId=" + id; rowsAffected = sqlCmd.ExecuteNonQuery(); } } FinishedWithConnection(cn); return(rowsAffected != 0); }
private static bool Update(SqlConnection cn, DeliveryDriver deliveryDriver) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE DeliveryDriver SET DeliveryDriverEmployeeId=@DeliveryDriverEmployeeId,DeliveryDriverCashierEmployeeId=@DeliveryDriverCashierEmployeeId,DeliveryDriverAmountBankrolled=@DeliveryDriverAmountBankrolled,DeliveryDriverStart=@DeliveryDriverStart,DeliveryDriverLastDelivery=@DeliveryDriverLastDelivery,DeliveryDriverEnd=@DeliveryDriverEnd WHERE DeliveryDriverId=@DeliveryDriverId"; BuildSqlParameter(sqlCmd, "@DeliveryDriverId", SqlDbType.Int, deliveryDriver.Id); BuildSqlParameter(sqlCmd, "@DeliveryDriverEmployeeId", SqlDbType.Int, deliveryDriver.DriversEmployeeId); BuildSqlParameter(sqlCmd, "@DeliveryDriverCashierEmployeeId", SqlDbType.Int, deliveryDriver.CashiersEmployeeId); BuildSqlParameter(sqlCmd, "@DeliveryDriverAmountBankrolled", SqlDbType.Float, deliveryDriver.AmountBankrolled); BuildSqlParameter(sqlCmd, "@DeliveryDriverStart", SqlDbType.DateTime, deliveryDriver.StartTime); BuildSqlParameter(sqlCmd, "@DeliveryDriverLastDelivery", SqlDbType.DateTime, deliveryDriver.LastDelivery); BuildSqlParameter(sqlCmd, "@DeliveryDriverEnd", SqlDbType.DateTime, deliveryDriver.EndTime); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }