public static SubscriptionDTO GetSubscriptionDetailsBySubscriptionId(int id) { using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities()) { Subscription Subscription = new Subscription(); Subscription = GSDE.Subscriptions.FirstOrDefault(x => x.Id == id); return(SubscriptionDTO.ConvertToDTO(Subscription)); } }
public static SubscriptionDTO GetCurrentSubscription(int studentId) { using (Gymnastics_Studio_DataEntities GSDE = new Gymnastics_Studio_DataEntities()) { StudentInSubscription CurrentstudentInSubscription = new StudentInSubscription(); CurrentstudentInSubscription = GSDE.StudentInSubscriptions.Where(x => x.StudentId == studentId && x.StartDate <= DateTime.Now && x.FinishDate >= DateTime.Now).FirstOrDefault(); Subscription currentSubscriptin = new Subscription(); if (CurrentstudentInSubscription != default) { currentSubscriptin = GSDE.Subscriptions.Where(x => x.Id == CurrentstudentInSubscription.SubscribtionId).FirstOrDefault(); return(SubscriptionDTO.ConvertToDTO(currentSubscriptin)); } else { return(null); } } }