public ChangeAgeResponse AgeImagesResponse(ChangeAgeEN pChangeAge, List <AgeImagesResponseEN> listImages) { List <AgeImagesCollectionResponse> _collectionImages = new List <AgeImagesCollectionResponse>(); AgeImagesCollectionResponse _ageResponse = new AgeImagesCollectionResponse(); ChangeAgeResponse changeAgeRes = new ChangeAgeResponse(); changeAgeRes.AgeID = pChangeAge.AgeID; changeAgeRes.Name = pChangeAge.Name; changeAgeRes.IconImage = pChangeAge.IconImage; changeAgeRes.MarkerG = (from ci in listImages where ci.SequenceID == 3 & ci.Name == "Marcadores" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.MarkerS = (from ci in listImages where ci.SequenceID == 2 && ci.Name == "Marcadores" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.MarkerB = (from ci in listImages where ci.SequenceID == 1 && ci.Name == "Marcadores" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.MarkerW = (from ci in listImages where ci.SequenceID == 4 && ci.Name == "Marcadores" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.WildcardMain = (from ci in listImages where ci.SequenceID == 1 && ci.Name == "Wildcard" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.WildcardWin = (from ci in listImages where ci.SequenceID == 2 && ci.Name == "Wildcard" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.WildcardLose = (from ci in listImages where ci.SequenceID == 3 && ci.Name == "Wildcard" select ci.ImgUrl).FirstOrDefault(); changeAgeRes.PrizeImage = (from ci in listImages where ci.Name == "Premios" select ci.ImgUrl).FirstOrDefault(); return(changeAgeRes); }
public ChangeAgeEN GetAgeImages(int AgeID, int ConsumerID, ref string error) { ChangeAgeEN result = new ChangeAgeEN(); try { cnn.Cnn.Open(); result = cnn.Cnn.Query <ChangeAgeEN>("SpGetAgeByID", new { AgeID = AgeID, ConsumerID = ConsumerID }, commandType: CommandType.StoredProcedure).FirstOrDefault(); } catch (Exception ex) { Console.WriteLine("Error AgeDAL: " + ex.Message); EventViewerLoggerDAL.LogError(ex.Message); } finally { cnn.Cnn.Close(); } return(result); }