public ObservableCollection <DataFormType> GetDataFormTypes() { ObservableCollection <DataFormType> result = null; using (var context = new DataFormDataContext()) { var formTypes = context.DataFormTypes.Where(x => x.IsActive == true).ToList <DataFormType>(); if (formTypes != null) { result = new ObservableCollection <DataFormType>(formTypes); } } return(result); }
public ObservableCollection <SynchronizationRegistry> GetSynchronizationRegistries() { ObservableCollection <SynchronizationRegistry> result = null; using (var context = new DataFormDataContext()) { var registries = context.SynchronizationRegister.Where(x => x.IsActive == true).ToList <SynchronizationRegistry>(); if (registries != null) { result = new ObservableCollection <SynchronizationRegistry>(registries); } } return(result); }
public ObservableCollection <DataFormSubCategory> GetDataFormSubCategories() { ObservableCollection <DataFormSubCategory> result = null; using (var context = new DataFormDataContext()) { var subCategories = context.DataFormSubCategories.Where(x => x.IsActive == true).ToList <DataFormSubCategory>(); if (subCategories != null) { result = new ObservableCollection <DataFormSubCategory>(subCategories); } } return(result); }
public DataFormRepository() { try { using (var context = new DataFormDataContext()) { context.Database.CreateIfNotExists(); } } catch (Exception e) { Console.WriteLine(e.Message); } }
public bool AddDataFormSubCategory(DataFormSubCategory dataFormSubCategory) { bool result = false; using (var context = new DataFormDataContext()) { context.DataFormSubCategories.Add(dataFormSubCategory); int save = context.SaveChanges(); if (save > 0) { result = true; } } return(result); }
public bool AddSynchronizationRegistry(SynchronizationRegistry synchronizationRegistry) { bool result = false; using (var context = new DataFormDataContext()) { context.SynchronizationRegister.Add(synchronizationRegistry); int save = context.SaveChanges(); if (save > 0) { result = true; } } return(result); }
public bool AddDataFormType(DataFormType dataFormType) { bool result = false; using (var context = new DataFormDataContext()) { context.DataFormTypes.Add(dataFormType); int save = context.SaveChanges(); if (save > 0) { result = true; } } return(result); }
public bool RemoveDataFormCategory(DataFormCategory dataFormCategory) { bool result = false; using (var context = new DataFormDataContext()) { var category = context.DataFormCategories.Where(x => x.DataFormCategoryId == dataFormCategory.DataFormCategoryId).FirstOrDefault(); if (category != null) { context.DataFormCategories.Remove(category); int save = context.SaveChanges(); if (save > 0) { result = true; } } } return(result); }
public bool RemoveDataFormType(DataFormType dataFormType) { bool result = false; using (var context = new DataFormDataContext()) { var dtf = context.DataFormTypes.Where(x => x.DataFormTypeId == dataFormType.DataFormTypeId).FirstOrDefault(); if (dtf != null) { context.DataFormTypes.Remove(dtf); int save = context.SaveChanges(); if (save > 0) { result = true; } } } return(result); }