public bool Insert()
{
string command = "INSERT into [CarType](name) values(@name)";
List <SqlParameter> parametersList = new List <SqlParameter>();
var nameParameter = new SqlParameter("@name", this.Name);
parametersList.Add(nameParameter);
var db = new DataAccess.DatabaseManager();
var result = db.ExecuteCommand(command, parametersList);
return(result);
}
public bool Delete()
{
string command = "delete from [CarType] where ID=@id";
List <SqlParameter> parametersList = new List <SqlParameter>();
var idParameter = new SqlParameter("@id", this.ID);
parametersList.Add(idParameter);
var db = new DataAccess.DatabaseManager();
var result = db.ExecuteCommand(command, parametersList);
return(result);
}
public bool Update()
{
string command = "Update [CarType] set [name]=@name where ID=@id";
List <SqlParameter> parametersList = new List <SqlParameter>();
var nameParameter = new SqlParameter("@name", this.Name);
var idParameter = new SqlParameter("@id", this.ID);
parametersList.Add(nameParameter);
parametersList.Add(idParameter);
var db = new DataAccess.DatabaseManager();
var result = db.ExecuteCommand(command, parametersList);
return(result);
}
