public static Festival GetActiveFestival(DateTime dt) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Festivals where (m.FromDate <= dt) && (m.ToDate >= dt) select m; return q.FirstOrDefault(); } }
public static List<BankStoryExam_Question> GetExamsQuestion(int? QuestionId) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.BankStoryExam_Question.Include("BankStoryExam") where (!QuestionId.HasValue || m.QuestionId == QuestionId.Value) select m; return q.ToList(); } }
public static IEnumerable<SystemRole> GetRolesWithUsers(int? roleId) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.SystemRoles.Include("SystemUsers") where (!roleId.HasValue || m.RoleId == roleId.Value) select m; return q.ToList(); } }
public static List<ScoreTypeCategory> GetScoreTypeCategory(int? ScoreTypeCatId = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.ScoreTypeCategories where (!ScoreTypeCatId.HasValue || m.CategoryId == ScoreTypeCatId.Value) select m; return q.ToList(); } }
public static SystemUser GetValidSystemUser(string SSOUserName) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.SystemUsers.Include("SystemRoles") where (m.SSOUserName == SSOUserName) && (m.Active) select m; return q.FirstOrDefault(); } }
public static List<SystemRole> GetRoles(int? roleId = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.SystemRoles where (!roleId.HasValue || m.RoleId == roleId.Value) select m; return q.ToList(); } }
public static List<QuestionnaireForms_ResponseItems> GetQuestionnaireForms_ResponseItem(long? ItemId = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.QuestionnaireForms_ResponseItems.Include("QuestionnaireForm_Questions") where (!ItemId.HasValue || m.ItemId == ItemId.Value) select m; return q.ToList(); } }
public static List<Config> GetConfig(string ConfigName = null) { using (var ctx = new BMIKidsEntities(BaseDataProvider.ConnectionString)) { var q = from m in ctx.Configs where (string.IsNullOrEmpty(ConfigName) || m.ConfigName == ConfigName) select m; return q.ToList(); } }
public static List<Festival_Pictures> GetFestivalPics(out int PageCount, Festival Curentfsv, bool? Approved = null, int Currentpage = 1, int PageSize = DefaultPageSize) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Festival_Pictures where (m.FestivalId == Curentfsv.FestivalId) && (!Approved.HasValue || m.IsApproved == Approved.Value) select m; PageCount = q.Count(); return q.OrderBy(x => Guid.NewGuid()).Skip((Currentpage - 1) * PageSize).Take(PageSize).ToList(); } }
public static List<FAQCategory> GetFAQCategory(int? FAQCatId = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.FAQCategories where (!FAQCatId.HasValue || m.CategoryId == FAQCatId.Value) orderby m.SortOrderId descending select m; return q.ToList(); } }
public static List<QuestionnaireForm> GetQuestionnaireForm(long? FormId = null, QuestionnaireStatusType? Status = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.QuestionnaireForms.Include("QuestionnaireForm_Questions").Include("QuestionnaireForm_Questions.QuestionnaireForms_ResponseItems") where (!FormId.HasValue || m.FormId == FormId.Value) && (!Status.HasValue || m.Status == (int)Status.Value) select m; return q.ToList(); } }
public static IEnumerable<ScoreType> GetScoresTypes(long? ScoreTypeId = null, long? ScoreTypeCategoryId = null, string ScoreEnName = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.ScoreTypes where (!ScoreTypeId.HasValue || m.Id == ScoreTypeId.Value) && (!ScoreTypeCategoryId.HasValue || m.CategoryId == ScoreTypeCategoryId.Value) && (string.IsNullOrEmpty(ScoreEnName) || m.ScoreEnName == ScoreEnName) select m; return q.ToList(); } }
public static List<BankStoryExam> GetExams(int? ExamId = null, DateTime? CurrentdateTime = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.BankStoryExams.Include("BankStoryExam_Question") where (!ExamId.HasValue || m.ExamId == ExamId.Value) && ( !CurrentdateTime.HasValue || (m.IsActiveFromDate <= CurrentdateTime.Value && m.IsActiveToDate >= CurrentdateTime.Value) ) select m; return q.ToList(); } }
public static IEnumerable<Kids_Scores> GetKids_Scores(long? KidsUserId = null, int? ScoreTypeId = null, DateTime? FromDate = null, DateTime? ToDate = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Kids_Scores where (!KidsUserId.HasValue || m.KidsUserId == KidsUserId.Value) && (!ScoreTypeId.HasValue || m.ScoreTypeId == ScoreTypeId.Value) && (!FromDate.HasValue || m.CreateDateTime >= FromDate.Value) && (!ToDate.HasValue || m.CreateDateTime <= ToDate.Value) select m; return q.ToList(); } }
public static List<SystemUser> GetSystemUser(string SSOUserName = null, long? UserId = null, string FirstName = null, string LastName = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.SystemUsers.Include("SystemRoles") where (string.IsNullOrEmpty(SSOUserName) || m.SSOUserName.Contains(SSOUserName)) && (!UserId.HasValue || m.UserId == UserId.Value) && (string.IsNullOrEmpty(FirstName) || m.Name == FirstName) && (string.IsNullOrEmpty(LastName) || m.Family == LastName) select m; return q.ToList(); } }
public static List<Game> GetGame(out long PageCount, int? GameId = null, string GameName = null, int Currentpage = 1, int PageSize = DefaultPageSize) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Games.Include("ScoreTypes") where (!GameId.HasValue || m.GameId == GameId.Value) && (string.IsNullOrEmpty(GameName) || m.Name.Contains(GameName)) orderby m.GameId descending select m; PageCount = q.LongCount(); return q.Skip((Currentpage - 1) * PageSize).Take(PageSize).ToList(); } }
public static List<Wish> GetWish(out int PageCount, int? WishId = null, string WishName = null, int Currentpage = 1, int PageSize = DefaultPageSize) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Wishes where (!WishId.HasValue || m.WishId == WishId.Value) && (string.IsNullOrEmpty(WishName) || m.WishName == WishName) orderby m.WishId descending select m; PageCount = q.Count(); return q.Skip((Currentpage - 1) * PageSize).Take(PageSize).ToList(); } }
public static List<PollQuestion> GetPoll(long? QuestionId = null, bool? IsActive = null) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.PollQuestions.Include("PollResponseItems") where (!IsActive.HasValue || m.IsActive == IsActive.Value) && (!QuestionId.HasValue || m.QuestionId == QuestionId.Value) orderby m.CreateDateTime descending select m; return q.ToList(); } }
public static void SavePostalCard(PostalCard PostalCard) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.PostalCards.ApplyChanges(PostalCard); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("PostalCard_DataProvider_DataProvider", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void Save(FAQCategory faqCat) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.FAQCategories.ApplyChanges(faqCat); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("faqCat_DataProvider_DataProvider", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static IEnumerable<UserResponsResult> GetPollUserResponse(PollQuestion Question, out long? TotalUserResp) { using (var ctx = new BMIKidsEntities(ConnectionString)) { TotalUserResp = ctx.PollUserResponses.LongCount(o => (long?)o.QuestionId == Question.QuestionId); var q = from m in ctx.PollUserResponses.Where(o => o.QuestionId == Question.QuestionId).GroupBy(o => o.ResponseItemId) select new UserResponsResult { itemId = m.Key, count = m.Count(), }; return q.ToList(); } }
public static void SaveSystemUser(SystemUser user) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.SystemUsers.ApplyChanges(user); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("SaveSystemUser_DataProvider_UpdateTransaction", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void SaveUserResponse(QuestionnaireForm_UserResponses resp) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.QuestionnaireForm_UserResponses.ApplyChanges(resp); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("Poll_DataProvider_SavePoll", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void SavePollResponse(PollUserResponse UserResp) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { UserResp.Serial = Guid.NewGuid(); ctx.PollUserResponses.ApplyChanges(UserResp); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("Poll_DataProvider_SavePollResponse", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static long SavePoll(PollQuestion p) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.PollQuestions.ApplyChanges(p); ctx.SaveChanges(); return p.QuestionId; } catch (Exception ex) { LogUtility.WriteEntryEventLog("Poll_DataProvider_SavePoll", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static int SaveExam(BankStoryExam Exam) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.BankStoryExams.ApplyChanges(Exam); ctx.SaveChanges(); return Exam.ExamId; } catch (Exception ex) { LogUtility.WriteEntryEventLog("BankStory_DataProvider_SaveExam", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void SaveExamQuestion(BankStoryExam_Question Question) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { ctx.BankStoryExam_Question.ApplyChanges(Question); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("BankStory_DataProvider_SaveExamQuestion", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void SaveFestival(Festival festival) { using (var ctx = new BMIKidsEntities(ConnectionString)) { try { if (festival.ChangeTracker.State == ObjectState.Unchanged) festival.MarkAsModified(); ctx.Festivals.ApplyChanges(festival); ctx.SaveChanges(); } catch (Exception ex) { LogUtility.WriteEntryEventLog("Festival_DataProvider_DataProvider", ex, EventLogEntryType.Information); if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static void SaveConfig(Config c) { using (var ctx = new BMIKidsEntities(BaseDataProvider.ConnectionString)) { try { if (c.ChangeTracker.State == ObjectState.Unchanged) c.MarkAsModified(); ctx.Configs.ApplyChanges(c); ctx.SaveChanges(); c.AcceptChanges(); } catch (Exception ex) { if (ex.InnerException != null) throw ex.InnerException; throw; } } }
public static List<Festival> GetFestival(out int PageCount, int? FestivalId = null, string FestivalName = null, DateTime? FromDate = null, DateTime? ToDate = null, int Currentpage = 1, int PageSize = DefaultPageSize) { using (var ctx = new BMIKidsEntities(ConnectionString)) { var q = from m in ctx.Festivals where (!FestivalId.HasValue || m.FestivalId == FestivalId.Value) && (!FromDate.HasValue || m.FromDate >= FromDate.Value) && (!ToDate.HasValue || m.ToDate >= ToDate.Value) && (!FestivalId.HasValue || m.FestivalId == FestivalId.Value) && (string.IsNullOrEmpty(FestivalName) || m.Name.Contains(FestivalName)) orderby m.FestivalId descending select m; PageCount = q.Count(); return q.Skip((Currentpage - 1) * PageSize).Take(PageSize).ToList(); } }