// Sql Server Connector
// TODO - Make the CreateTaxiCentral method actually save to the database
/// <summary>
/// Saves a new Taxi central to the database
/// </summary>
/// <param name="model">The Taxi central information</param>
/// <returns>The Taxi Central information, including the unique identifier.</returns>
public TaxiCentralModel CreateTaxiCentral(TaxiCentralModel model)
{
using (IDbConnection connection = new Microsoft.Data.SqlClient.SqlConnection(
GlobalConfig.GetConnectionString("TDMSDatabase")))
{
var p = new DynamicParameters();
p.Add("@Name", model.Name);
p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spTaxiCentral_Insert", p, commandType: CommandType.StoredProcedure);
model.Id = p.Get <int>("@Id");
return(model);
}
}
public void DeleteData(string sql, object parameters)
{
using IDbConnection cnn = new Microsoft.Data.SqlClient.SqlConnection(ConnectionString);
cnn.Execute(sql, parameters);
}
