public static Jet updateJet(Jet jet) { string sql = @"update dbo.Jets set SerialNumber = @serialNumber, ModelName = @modelName where Id = @id;"; SqlAccess.SaveData(sql, jet); return(jet); }
public static List <Jet> CreateJet(string modelName, int serialNumber) { Jet jet = new Jet { modelName = modelName, serialNumber = serialNumber }; string sql = @"insert into dbo.Jets (ModelName, SerialNumber) values(@modelName, @serialNumber);"; SqlAccess.SaveData(sql, jet); string returnSql = @"select * from dbo.Jets where SerialNumber = " + serialNumber + ";"; return(SqlAccess.LoadData <Jet>(returnSql)); }