private string AwardLevel(string accessCode) { int wave = 1; string result = "silver"; Access myAccess = new Access(); string workerId = myAccess.GetWorkerId(accessCode); using (SignalAwardContext db = new SignalAwardContext()) { var design = db.Designs.FirstOrDefault(x => x.WorkerId == workerId); if (design != null) { if(wave == 1) { if (design.F2w1 == 2) result = "silver"; if (design.F2w1 == 3) result = "gold"; } if(wave == 2) { if (design.F2w2 == 2) result = "silver"; if (design.F2w2 == 3) result = "gold"; } } } return result; }