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);
}
}
}
