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); }
public List <CarType> Read() { string command = "Select * from CarType"; var db = new DataAccess.DatabaseManager(); var result = db.GetData(command); List <CarType> lstResult = new List <CarType>(); foreach (DataRow r in result.Rows) { CarType car = new CarType(); car.ID = Convert.ToInt64(r["ID"]); car.Name = r["Name"].ToString(); lstResult.Add(car); } return(lstResult); }