public ViewModel()
{
cFExRepository = new CFExRepository();
cFExRepository.progressChanged += ProgressChanged;
visitorCollection = new ObservableCollection <Visitor>();
displaySettingCollection = cFExRepository.DisplaySettingCollection;
dsColumnSettingCollection = cFExRepository.DsColumnSettingCollection;
selectedSetting = displaySettingCollection.Where(s => s.IsSelected == true).FirstOrDefault();
selectedCollumnSetting = dsColumnSettingCollection.Where(s => s.IsSelected == true).FirstOrDefault();
addDataFromFileToDatabase = new RelayCommand(c =>
{
OpenFileDialog openFileDialog = new OpenFileDialog();
_ProgressBar = new Progress_Bar {
Visible = true, Progress = 10, Status = "Start"
};
if (openFileDialog.ShowDialog() == true)
{
Task.Factory.StartNew(() =>
{
cFExRepository.initRepositoryFromFile(openFileDialog.FileName);
visitorCollection = cFExRepository.VisitorCollection;
_ProgressBar.Status = "All data added to database";
_ProgressBar.Progress = 0;
Thread.Sleep(3000);
_ProgressBar.Visible = false;
});
}
});
}
public DSCollumnSettingDTO AddOrUpdate(DSCollumnSettingDTO dSCollumnSettingDTO)
{
DSCollumnSetting dSCollumnSetting = mapper.Map <DSCollumnSetting>(dSCollumnSettingDTO);
if (dSCollumnSetting != null)
{
dSCollumnSettingDTO = mapper.Map <DSCollumnSettingDTO>
(dSCollumnSettingRepository.AddOrUpdateDSCollumnSetting(dSCollumnSetting));
}
return(dSCollumnSettingDTO);
}
public bool delDSCollumnSetting(DSCollumnSetting dscs)
{
try
{
context.DSCollumnSettings.Remove(dscs);
context.SaveChanges();
dsColumnSettingCollection.Remove(dscs);
}
catch { return(false); }
return(true);
}
public bool RemoveDSCollumnSetting(DSCollumnSetting dSCollumnSetting)
{
bool result;
try
{
var _dSCollumnSetting = context.DSCollumnSettings.
Where(s => s.Id == dSCollumnSetting.Id).FirstOrDefault();
context.DSCollumnSettings.Remove(_dSCollumnSetting);
context.SaveChanges();
result = true;
} catch { result = false; }
return(result);
}
public bool addDSCollumnSetting(DSCollumnSetting dscs)
{
try
{
context.DSCollumnSettings.Add(dscs);
context.SaveChanges();
var _dsColumnSettingRepository = context.DSCollumnSettings; dsColumnSettingCollection.Clear();
foreach (var c in _dsColumnSettingRepository)
{
dsColumnSettingCollection.Add(c);
}
}
catch { return(false); }
return(true);
}
AddOrUpdateDSCollumnSetting(DSCollumnSetting dSCollumnSetting)
{
context.DSCollumnSettings.AddOrUpdate(dSCollumnSetting);
context.SaveChanges();
//if (context.DSCollumnSettings.Where(d=>
//d.Name == dSCollumnSetting.Name&&
//d.Visible == dSCollumnSetting.Visible&&
//d.Width == dSCollumnSetting.Width).Count() == 0)
//{
// context.DSCollumnSettings.AddOrUpdate(dSCollumnSetting);
// context.SaveChanges();
//}
return(context.DSCollumnSettings.Where(d =>
d.Name == dSCollumnSetting.Name &&
d.Visible == dSCollumnSetting.Visible &&
d.Width == dSCollumnSetting.Width).FirstOrDefault());
}
