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);
}
