public void ReadContosFromFile()
{
var year = ConfigTempoSinglenton.GetInstance().WorkDate.Year;
ContoReader exportBuilderInput = new ContoReader();
var res = ExportBuilder.SqlScriptString(exportBuilderInput);
//SaveTofile(res, Path.Combine(AppDomain.CurrentDomain.BaseDirectory, exportBuilderInput.FileName));
}
private void Refresh()
{
_treeAcc = new ObservableCollection <TreeViewModel>();
AllAccounts =
new ObservableCollection <AccountsModel>(
Context.GetAllAccounts(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
int oldnum = 0;
//TreeViewModel curitem = new TreeViewModel();
//foreach (var item in AllAccounts)
//{
// TreeViewModel ni = new TreeViewModel();
// ni.CurrAcc = item;
// if (item.SubNum>0)
// {
// curitem.SubAccs.Add(ni);
// }
// else
// {
// _treeAcc.Add(ni);
// curitem = ni;
// oldnum = item.Num;
// }
//}
//OnPropertyChanged("Tree");
}
private void SaveConfig(object sender, DoWorkEventArgs e1)
{
var models = ConfigTempoSinglenton.GetInstance().DeclarConfigs;
if (models != null)
{
var mod = models.FirstOrDefault(e => e.FirmaId == model.FirmaId);
if (mod == null)
{
models.Add(model);
}
else
{
models.Remove(mod);
models.Add(model);
}
}
else
{
models = new List <DeclarConfigModel>();
models.Add(model);
ConfigTempoSinglenton.GetInstance().DeclarConfigs = models;
}
ConfigTempoSinglenton.GetInstance().SaveConfiguration();
}
public MainAccountsViewModel()
: base()
{
AllAccounts = new ObservableCollection <AccountsModel>(context.GetAllAccounts().Where(e => e.FirmaId == ConfigTempoSinglenton.GetInstance().CurrentFirma.Id&& e.SubNum == 0 && e.AnaliticalNum == 0 && e.PartidNum == 0));
if (AllAccounts.Count > 0)
{
_CurrentAccount = AllAccounts.Last();
}
else
{
_CurrentAccount = new AccountsModel
{
AnaliticalNum = 0,
LevelAccount = 1,
SubNum = 0,
FirmaId = ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,
Id = 1,
TypeSaldo = 1,
TypeAccount = 1,
Num = 1,
PartidNum = 0
};
AllAccounts.Add(_CurrentAccount);
}
AllNationalAccounts = new ObservableCollection <LookUpSpecific>(context.GetAllNationalAccounts());
}
public DeclarsViewModel()
{
model = ConfigTempoSinglenton.GetInstance().DeclarConfig;
model.FirmaId = ConfigTempoSinglenton.GetInstance().CurrentFirma.Id;
var models = ConfigTempoSinglenton.GetInstance().DeclarConfigs;
if (models != null)
{
var mod = models.FirstOrDefault(e => e.FirmaId == model.FirmaId);
if (mod != null)
{
model = mod;
}
else
{
models.Add(model);
}
}
else
{
models = new List <DeclarConfigModel>();
models.Add(model);
ConfigTempoSinglenton.GetInstance().DeclarConfigs = models;
}
_year = ConfigTempoSinglenton.GetInstance().WorkDate.Year;
_month = ConfigTempoSinglenton.GetInstance().WorkDate.Month;
Visible = Visibility.Hidden;
}
protected override void Update()
{
var conf = ConfigTempoSinglenton.GetInstance();
conf.SaveConfiguration();
App.LoadConfig();
}
public AccSelectorViewModel()
{
_ShowContragentSum = false;
_WithContragentSum = true;
FirmaId = ConfigTempoSinglenton.GetInstance().CurrentFirma.Id;
_allAccounts = new ObservableCollection <AccountsModel>(Context.GetAllAccounts(FirmaId));
}
public AccountsViewModel() : base()
{
AllNationalAccounts = new ObservableCollection <LookUpSpecific>(context.GetAllNationalAccounts());
AllAnaliticalAccount = new ObservableCollection <AnaliticalAccount>(context.GetAllAnaliticalAccount());
AllAnaliticTypes = new ObservableCollection <AnaliticalAccountType>(context.GetAllAnaliticalAccountType());
AllAnaliticalFields = new ObservableCollection <AnaliticalFields>(context.GetAllAnaliticalFields());
AllConnectors = new ObservableCollection <ConectorAnaliticField>(context.GetAllConnectorAnaliticField());
AllAccountsFirms = new ObservableCollection <AccountsModel>(context.GetAllAccounts());
AllAccounts = new ObservableCollection <AccountsModel>(context.GetAllAccounts().Where(e => e.FirmaId == ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
AllLookups = new ObservableCollection <LookUpMetaData>(context.GetAllLookups());
SelectedAnaliticalFields = new ObservableCollection <AnaliticalFields>();
if (AllAccounts.Count > 0)
{
_CurrentAccount = AllAccounts.Last();
}
else
{
_CurrentAccount = new AccountsModel
{
AnaliticalNum = 1,
LevelAccount = 1,
SubNum = 1,
FirmaId = ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,
Id = 1,
TypeSaldo = 1,
TypeAccount = 1,
Num = 1,
PartidNum = 0
};
AllAccounts.Add(_CurrentAccount);
}
}
protected override void Add()
{
HoldingViewModel holding =
new HoldingViewModel(new HoldingModel {
Name = "New", IpServer = "localhost", Nom = Holdings.Count + 1
});
var conf = ConfigTempoSinglenton.GetInstance();
holding.ConnectionString = string.Format(Entrence.ConectionStringTemplate, holding.IpServer, conf.BaseDbPath, "H" + holding.Nom);
Holdings.Add(holding);
if (
MessageBoxWrapper.Show("Копиране на празна база от темплейтите?", "Предупреждение",
MessageBoxWrapperButton.YesNo) == MessageBoxWrapperResult.Yes)
{
IoHelper.DirectoryCopy(ConfigTempoSinglenton.GetInstance().BaseTemplatePath,
Path.Combine(ConfigTempoSinglenton.GetInstance().BaseDbPath, "H" + holding.Nom), true);
}
foreach (var item in conf.ConfigNames)
{
var spliter = item.Split('|');
FirmSettingModel newsett = new FirmSettingModel();
newsett.Key = spliter[0];
newsett.Name = spliter[1];
newsett.Value = spliter[2];
newsett.FirmaId = 1;
newsett.HoldingId = holding.Nom;
conf.FirmSettings.Add(newsett);
}
conf.SaveConfiguration();
}
public HoldingsWindowViewModel()
{
//string[] lines=null;
//string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "holdings.txt");
//if (File.Exists(path))
//{
// lines = File.ReadAllLines(path);
//}
//else
//{
// lines =new string[]{ "Tehko|localhost|t" };
//}
//int i = 1;
Holdings = new ObservableCollection <HoldingViewModel>();
var hol = ConfigTempoSinglenton.GetInstance().Holdings;
foreach (HoldingModel holdingModel in hol)
{
Holdings.Add(new HoldingViewModel(holdingModel));
}
//foreach (string line in lines)
//{
// var splitline = line.Split('|');
// if (splitline.Length < 2) continue;
// HoldingViewModel item = new HoldingViewModel();
// item.Nom = i;
// item.Name = splitline[0].Trim();
// item.IpServer= splitline[1].Trim();
// item.Template=splitline[2].Trim();
// Holdings.Add(item);
// i++;
//}
}
private static DeclarConfigModel DeclarConfigModel(out List <DeclarConfigModel> models)
{
var model = ConfigTempoSinglenton.GetInstance().DeclarConfig;
models = ConfigTempoSinglenton.GetInstance().DeclarConfigs;
if (models != null)
{
var mod = models.FirstOrDefault(e => e.FirmaId == model.FirmaId);
if (mod != null)
{
model = mod;
}
else
{
models.Add(model);
}
}
else
{
models = new List <DeclarConfigModel>();
models.Add(model);
ConfigTempoSinglenton.GetInstance().DeclarConfigs = models;
}
return(model);
}
public AnaliticRegisterViewModelContrGrupaDocument()
{
var reportItems = new List <ReportItem>();
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "запис", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "номер", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "дата", Width = 10
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "папка", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "вид д.", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "сч.", Width = 3
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "обект", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "дата док.", Width = 10
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "оборот", Width = 12, IsSuma = true
});
//reportItems.Add(new ReportItem { Height = 30, IsShow = true, Name = "оборотк", Width = 12, IsSuma = true });
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "дебит сметка", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "кредит сметка", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "основание", Width = 30
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "забележка", Width = 20
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "транзакция", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "код контр.", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "контрагент", Width = 32
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "Забележка", Width = 32
});
ReportItems = reportItems;
Allacc = new List <AccountsModel>(Context.GetAllAccounts(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
}
public PeriodsViewModel()
{
Title = string.Format("Забранени периоди за фирма {0}", Entrence.CurrentFirma.Name);
Periods = new ObservableCollection <PeriodModel>(ConfigTempoSinglenton.GetInstance().Periods.Where(e => e.Firma == ConfigTempoSinglenton.GetInstance().ActiveFirma&& e.Holding == ConfigTempoSinglenton.GetInstance().ActiveHolding));
if (Periods.Count > 0)
{
Period = Periods[0];
}
}
public int FetchCount()
{
if (_Lookup == null)
{
return(0);
}
return(Context.GetFilteredLookupCount(LookupModelm.LookUpMetaData.Tablename,
ConfigTempoSinglenton.GetInstance().CurrentFirma.Id, SqlFilter));
}
private void AddAcc()
{
MainAcc mainAcc = new MainAcc(new AccountsModel {
FirmaId = ConfigTempoSinglenton.GetInstance().CurrentFirma.Id, TypeAccountEx = 1, LevelAccount = 1
}, EditMode.Add, true);
mainAcc.ShowDialog();
Refresh();
}
public Auto60vm()
: base()
{
StartAutoCommand = new DelegateCommand((o) => StartAuto(), (o) => this.CanStartAuto());
Allacc = new List <AccountsModel>(Context.GetAllAccounts(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
Data = new DateTime(ConfigTempoSinglenton.GetInstance().WorkDate.Year, 12, 31);
Visible = System.Windows.Visibility.Hidden;
ExDebit = "650";
}
public List <string> GetHeader()
{
var ret = new List <string>();
ret.Add(String.Format("Дата на извлечението: {0}", DateTime.Now.ToShortDateString()));
ret.Add(String.Format("За фирма : {0}", ConfigTempoSinglenton.GetInstance().CurrentFirma.Name));
ret.Add(String.Format("Съставил : {0}", Entrence.UserName));
return(ret);
}
//public void PopulateVariables()
//{
// Variables.Add("@A1", "10");
// Variables.Add("@A2", "20");
// Variables.Add("@A3", "35");
// Variables.Add("@A4", "53");
//}
public void PopulateSysVariables()
{
var context = new Tempo2012.EntityFramework.TempoDataBaseContext();
ContoVars = context.GetOborotnaVedTemplate(new DateTime(ConfigTempoSinglenton.GetInstance().WorkDate.Year, 1, 1), new DateTime(ConfigTempoSinglenton.GetInstance().WorkDate.Year, 12, 31));
ContoVars.Add("@@FirmaName", Entrence.CurrentFirma.Name);
ContoVars.Add("@@FirmaBulstat", Entrence.CurrentFirma.Bulstad);
ContoVars.Add("@@FirmaAddress", Entrence.CurrentFirma.Address);
ContoVars.Add("@@Operator", Entrence.UserName);
}
public AppSettingsViewModel()
{
var conf = ConfigTempoSinglenton.GetInstance().FirmSettings;
Settings = new ObservableCollection <FirmSettingViewModel>();
foreach (FirmSettingModel firmSettingModel in conf.Where(e => e.FirmaId == ConfigTempoSinglenton.GetInstance().CurrentFirma.Id&& e.HoldingId == ConfigTempoSinglenton.GetInstance().ActiveHolding))
{
Settings.Add(new FirmSettingViewModel(firmSettingModel));
}
}
public QuantityDialog()
{
var reportItems = new List <ReportItem>();
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "запис", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "номер", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "дата", Width = 10
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "папка", Width = 5
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "сч.", Width = 3
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "оборот лева", Width = 12, IsSuma = true
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "дебит сметка", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "кредит сметка", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "количество", Width = 12, IsSuma = true
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "Ед. цена", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "основание", Width = 30
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "забележка", Width = 20
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "код", Width = 10
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "материал", Width = 40
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "потребител", Width = 12
});
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "транзакция", Width = 15
});
ReportItems = reportItems;
Allacc = new List <AccountsModel>(Context.GetAllAccounts(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
}
public List <List <string> > GetItems()
{
List <string> newitem = null;
List <List <string> > result = new List <List <string> >();
var allconto = Context.GetAllContoWithDds(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id, Entrence.Mask, Tipdnev);
foreach (var conto in allconto.OrderBy(e => e.Data))
{
newitem = new List <string>();
newitem.Add(conto.Nd.ToString());
newitem.Add(conto.DocNum);
newitem.Add(conto.NumberObject.ToString());
newitem.Add(conto.Folder);
newitem.Add(conto.Data.ToShortDateString());
var firstOrDefault = AllAccountsK.FirstOrDefault(e => e.Id == conto.DebitAccount);
newitem.Add(firstOrDefault != null ? firstOrDefault.Short.Trim(' ') : "");
var accountsModel = AllAccountsK.FirstOrDefault(e => e.Id == conto.CreditAccount);
newitem.Add(accountsModel != null ? accountsModel.Short.Trim(' ') : "");
newitem.Add(conto.Oborot.ToString(Vf.LevFormatUI));
newitem.Add(conto.Reason);
string pok = "";
if (conto.IsPurchases == 1)
{
pok = conto.VopPurchases;
}
if (conto.IsSales == 1)
{
pok = conto.VopSales;
}
if (conto.IsPurchases == 1 && conto.IsSales == 1)
{
pok = string.Format("{0}/{1}", conto.VopPurchases, conto.VopSales);
}
newitem.Add(pok);
//newitem.Add(conto.Note);
//newitem.Add(conto.DataInvoise.ToShortDateString());
newitem.Add(conto.Contragent);
newitem.Add(conto.Vat);
newitem.Add(conto.KindDoc);
newitem.Add(conto.NomInvoise);
newitem.Add(conto.DataInvoiseDnev);
newitem.Add(conto.SumDds.ToString(Vf.LevFormatUI));
newitem.Add(conto.Sum.ToString(Vf.LevFormatUI));
newitem.Add((conto.Sum + conto.SumDds).ToString(Vf.LevFormatUI));
newitem.Add(conto.Pr1);
newitem.Add(conto.Pr2);
newitem.Add(conto.DDetails ?? "");
newitem.Add(conto.CDetails ?? "");
newitem.Add(conto.UserId.ToString());
newitem.Add(conto.Id.ToString());
result.Add(newitem);
}
return(result);
}
public List <string> GetHeader()
{
List <string> list = new List <string>();
list.Add(string.Format("за : {0}", Currentfilter));
list.Add(string.Format("за период : {0} до {1}", FromDate.ToShortDateString(), ToDate.ToShortDateString()));
list.Add(string.Format("Дата на извлечението : {0}", DateTime.Now.ToShortDateString()));
list.Add(string.Format("за фирма : {0}", ConfigTempoSinglenton.GetInstance().CurrentFirma.Name));
list.Add(string.Format("Счетоводител : {0}", Config.CurrentUser.Name));
return(list);
}
public MainViewModel()
{
ConfigTempoSinglenton currentconfig = ConfigTempoSinglenton.GetInstance();
ConfigParams = new ObservableCollection <ConfigParamModel>();
ConfigParams.Add(new ConfigParamModel {
Changer = "firm", Description = currentconfig.CurrentFirma.Bulstad, Name = "Фирма", Value = currentconfig.CurrentFirma.Name
});
ConfigParams.Add(new ConfigParamModel {
Changer = "data", Description = "Днес " + DateTime.Now.ToShortDateString(), Name = "Работна дата", Value = currentconfig.WorkDate.ToShortDateString()
});
}
public List <string> GetHeader()
{
var ret = new List <string>();
ret.Add(String.Format("За месец : {0} година {1}", Thread.CurrentThread.CurrentCulture.DateTimeFormat.MonthNames[ddsDnevnikModel.Month - 1], ddsDnevnikModel.Year));
ret.Add(String.Format("Дата на извлечението: {0}", DateTime.Now.ToShortDateString()));
ret.Add(String.Format("За фирма : {0}", ConfigTempoSinglenton.GetInstance().CurrentFirma.Name));
ret.Add(String.Format("Съставил : {0}", ConfigTempoSinglenton.GetInstance().CurrentFirma.Names));
ret.Add(String.Format("ИД.Номер по ЗДДС : {0}", ConfigTempoSinglenton.GetInstance().CurrentFirma.DDSnum));
ret.Add(String.Format("Даначеn период : {0}/{1}", ddsDnevnikModel.Month, ddsDnevnikModel.Year));
return(ret);
}
public CopyAccsFromYearToYearViewModel()
: base()
{
CopyCommand = new DelegateCommand((o) => this.CopyAccFromYtoY(), (o) => this.CanCopyAccFromYtoY());
Visible = Visibility.Hidden;
_fromYear = ConfigTempoSinglenton.GetInstance().WorkDate.Year;
_toYear = _fromYear + 1;
isCalculateSaldo = true;
isCalculateSaldoDetail = true;
isCopySmetkoplan = true;
isCalculateSaldoDetailZero = false;
excludeTotalZero = false;
}
protected override void Update()
{
List <HoldingModel> hm = new List <HoldingModel>();
foreach (HoldingViewModel holdingViewModel in Holdings)
{
hm.Add(holdingViewModel.HoldingModel);
}
var conf = ConfigTempoSinglenton.GetInstance();
conf.Holdings = hm;
conf.SaveConfiguration();
}
public List <string> GetHeader()
{
List <string> list = new List <string>();
list.Add(string.Format("Детайли за сметка : {0}", Acc.Short));
list.Add(string.Format("Дата на извлечението : {0}", DateTime.Now.ToShortDateString()));
list.Add(string.Format("за фирма : {0}",
ConfigTempoSinglenton.GetInstance().CurrentFirma.Name));
list.Add(string.Format("Счетоводител : {0}", Config.CurrentUser.Name));
list.Add(string.Format("Филтър : {0}", Filt));
list.Add(string.Format("До дата : {0}", EndDate.ToShortDateString()));
return(list);
}
public ReportDebit()
{
var reportItems = new List <ReportItem>();
reportItems.Add(new ReportItem {
Height = 30, IsShow = true, Name = "Сметка", Width = 30
});
reportItems.Add(new ReportItem {
Height = 10, IsShow = true, Name = "Сума Оборот", Width = 20, Sborno = true
});
ReportItems = reportItems;
Allacc = new List <AccountsModel>(Context.GetAllAccounts(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (CheckForPermition)
{
ConfigTempoSinglenton currentconfig = ConfigTempoSinglenton.GetInstance();
if (currentconfig.Periods.FirstOrDefault(e1 => e1.Fr <= dater.SelectedDate && e1.To >= dater.SelectedDate && e1.Firma == currentconfig.ActiveFirma && e1.Holding == currentconfig.ActiveHolding) != null)
{
MessageBoxWrapper.Show("Забранен период не може да се сетне датата " + dater.SelectedDate);
return;
}
}
DialogResult = true;
}
protected virtual DateTime GetDateFromForm(string title)
{
DateTime result = ConfigTempoSinglenton.GetInstance().WorkDate;
DataSelector ds = new DataSelector(result, title, false);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
result = ds.SelectedDate;
//confi.DataContext = vm.ConfigParams;
}
return(result);
}
