public VictoriaDavydova.ThreeLayer.SSU.Entities.Award GetAwardByID(int idAward) { VictoriaDavydova.ThreeLayer.SSU.Entities.Award newAward = null; foreach (var award in baseAwards.GetAllAwards()) { if (award.idAward == idAward) { newAward = new VictoriaDavydova.ThreeLayer.SSU.Entities.Award(award.idAward, award.title); } } return(newAward); }
public VictoriaDavydova.ThreeLayer.SSU.Entities.Award GetAwardByID(int idAward) { VictoriaDavydova.ThreeLayer.SSU.Entities.Award award = null; using (var connection = new SqlConnection(_myConnectionString)) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "FindAwardByID"; command.Parameters.Add("@IDUser", SqlDbType.NChar).Value = idAward; using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { award = new VictoriaDavydova.ThreeLayer.SSU.Entities.Award((string)dataReader["Title"]); } } } return(award); }
public string AddAward(VictoriaDavydova.ThreeLayer.SSU.Entities.Award award) { using (var connection = new SqlConnection(_myConnectionString)) { connection.Open(); try { SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "AddAward"; command.Parameters.Add("Title", SqlDbType.Char).Value = award.title; var rowCount = command.ExecuteNonQuery(); return("Award successfully added. Rows Added = " + rowCount); } catch (Exception exception) { return(exception.StackTrace); } } }