public static void LoadAnaliticDetailsK(string accname, TempoDataBaseContext context, ContoAll conto)
{
if (!accname.Contains("/"))
{
int num;
if (int.TryParse(accname, out num))
{
var model = AllAccounts.FirstOrDefault(e => e.Num == num && e.SubNum == 0);
if (model != null)
{
conto.Conto.CreditAccount = model.Id;
}
var list = context.LoadAllAnaliticfields(model.Id);
conto.ItemsCredit = new List <SaldoItem>(LoadCreditAnaliticAtributes(list.ToList(), 1));
foreach (SaldoItem saldoItem in conto.ItemsCredit)
{
if (saldoItem.Type == SaldoItemTypes.Date)
{
saldoItem.Value = conto.Conto.Data.ToShortDateString();
}
}
if (conto.ItemsCredit.Count == 0)
{
conto.ItemsCredit = null;
}
}
}
else
{
int num, subnum;
var ac = accname.Split('/');
if (int.TryParse(ac[0], out num) && int.TryParse(ac[1], out subnum))
{
var model = AllAccounts.FirstOrDefault(e => e.Num == num && e.SubNum == subnum);
if (model != null)
{
conto.Conto.CreditAccount = model.Id;
var list = context.LoadAllAnaliticfields(model.Id);
conto.ItemsCredit = new List <SaldoItem>(LoadCreditAnaliticAtributes(list.ToList(), 1));
foreach (SaldoItem saldoItem in conto.ItemsCredit)
{
if (saldoItem.Type == SaldoItemTypes.Date)
{
saldoItem.Value = conto.Conto.Data.ToShortDateString();
}
}
if (conto.ItemsCredit.Count == 0)
{
conto.ItemsCredit = null;
}
}
}
}
}
public void PopulateContoFromFile()
{
Entrence.ConnectionString =
"User ID=sysdba;Password=masterkey;Database=localhost:E:\\Samples\\Tempo2012MVVM\\Tempo2012\\Tempo2012.UI.WPF\\bin\\Debug\\data\\TEMPO2012.FDB;DataSource=localhost;";
ObservableCollection <SaldoItem> ItemsCredit = new ObservableCollection <SaldoItem>();
ObservableCollection <SaldoItem> ItemsDebit = new ObservableCollection <SaldoItem>();
TempoDataBaseContext context = new TempoDataBaseContext();
ObservableCollection <WraperConto> AllWrapedConto = new ObservableCollection <WraperConto>();
var AllAccountsK =
new ObservableCollection <AccountsModel>(
context.GetAllAccounts(1));
var Lookups = new ObservableCollection <LookUpMetaData>(context.GetAllLookups(" where NAMEENG='k'"));
}
private static void serialiseConto(TempoDataBaseContext context)
{
var Allconto = context.GetAllConto(1, 2000, 20);
ContoAll contoAll = new ContoAll();
contoAll.Conto = Allconto.First();
contoAll.ItemsDebit =
new List <SaldoItem>(DbHelper.LoadCreditAnaliticAtributes(context.LoadContoDetails(contoAll.Conto.Id, 1), 1));
contoAll.ItemsCredit =
new List <SaldoItem>(DbHelper.LoadCreditAnaliticAtributes(context.LoadContoDetails(contoAll.Conto.Id, 2), 2));
SerializeUtil.SerializeToXML <ContoAll>("test.xml", contoAll);
}
static void Main(string[] args)
{
try
{
ConfigTempoSinglenton currentconfig = ConfigTempoSinglenton.GetInstance();
Entrence.ConnectionString = string.Format(currentconfig.ConectionString, AppDomain.CurrentDomain.BaseDirectory);
LoadConfig();
var context = new TempoDataBaseContext();
FirmaId = ConfigTempoSinglenton.GetInstance().ActiveFirma;
KindDocLookup = new ObservableCollection <LookUpSpecific>(context.GetAllDocTypes());
TypeDocuments = new ObservableCollection <LookUpSpecific>(context.GetAllDocTypes());
ItemsDdsDnevPurchases = new ObservableCollection <DdsItemModel>(context.GetAllDnevItems(1));
ItemsDdsDnevSales = new ObservableCollection <DdsItemModel>(context.GetAllDnevItems(0));
// Test if input arguments were supplied:
if (args.Length < 1)
{
System.Console.WriteLine("Невалидни Параметри");
return;
}
string path = args[0];
string command = "2";
if (args.Length > 1)
{
command = args[1];
}
int num;
switch (command)
{
case "1":
{
serialiseConto(context);
break;
}
case "2":
{
InsertConto(context, path);
break;
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.ReadKey();
}
//serialiseConto(context);
}
private IEnumerable <SaldoItem> LoadDetails(int contoid, int typeconto, TempoDataBaseContext context)
{
if (contoid == 0)
{
return(new List <SaldoItem>());
}
var items = ContoRepository.Instance.ContoItems(string.Format("{0}-{1}", contoid, typeconto));
if (items != null)
{
return(items);
}
var itemsforcache = LoadCreditAnaliticAtributes(context.LoadContoDetails(contoid, typeconto), typeconto,
context);
ContoRepository.Instance.Add(string.Format("{0}-{1}", contoid, typeconto), itemsforcache.ToList());
return(itemsforcache);
}
private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
var Context = new TempoDataBaseContext();
var sen = (sender as Button);
if (sen != null)
{
var cp = sen.CommandParameter as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
current.Add(new FieldValuePair
{
Name = item.Name,
Value = "",
Length = item.Length,
ReadOnly = (item.NameEng == "Id") ? false : true,
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
});
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
lookup.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
if (!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id))
{
MessageBoxWrapper.Show("Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
if (dc != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
}
if (dat != null && dat.Count > 5)
{
if (dc != null)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
}
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
}
private void Calculate()
{
var Context = new TempoDataBaseContext();
var cp = this.DataContext as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
string search = Entrence.ConfigFirmaToLookup.GetField(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,
cp.Relookup);
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup):Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
var nf = new FieldValuePair
{
Name = item.Name,
Length = item.Length,
Value = i == 1 && string.IsNullOrWhiteSpace(search)?searcher.Text:"",
ReadOnly = item.NameEng != "Id",
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
};
if (item.NameEng == search)
{
nf.Value = searcher.Text;
}
current.Add(nf);
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
if (!cp.SysLookup)
{
lookup.Fields.Add(new TableField
{
DbField = "integer",
GROUP = 4,
Id = 4,
Length = 4,
IsRequared = false,
NameEng = "FIRMAID",
Name = "Фирма Номер"
});
}
bool sys = cp.SysLookup?!Context.SaveRow(ds.GetNewFields(), lookup):!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
if (sys)
{
MessageBoxWrapper.Show(
"Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
if (dat != null && dat.Count > 5)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
dc.LiD = 0;
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
public IEnumerable <SaldoItem> LoadCreditAnaliticAtributes(IEnumerable <SaldoAnaliticModel> fields, int typecpnto,
TempoDataBaseContext context)
{
List <SaldoItem> saldoItems = new List <SaldoItem>();
foreach (SaldoAnaliticModel analiticalFields in fields)
{
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = analiticalFields.VAL,
Fieldkey = analiticalFields.ACCFIELDKEY,
IsK = typecpnto == 0,
IsD = typecpnto == 1,
Id = analiticalFields.ID,
KursDif = analiticalFields.KURSD,
ValueKurs = analiticalFields.KURS,
MainKurs = analiticalFields.KURSM,
ValueVal = analiticalFields.VALVAL,
ValueCredit = analiticalFields.VALUEMONEY,
Lookupval = analiticalFields.LOOKUPVAL
};
if (analiticalFields.ACCFIELDKEY == 29 || analiticalFields.ACCFIELDKEY == 30 ||
analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.IsDK = true;
if (analiticalFields.ACCFIELDKEY == 30)
{
saldoItem.InfoTitle = "Валутен курс";
saldoItem.IsVal = true;
}
if (analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.InfoTitle = "Единичнa цена";
saldoItem.IsKol = true;
}
}
if (analiticalFields.LOOKUPID != 0)
{
saldoItem.Key = analiticalFields.LOOKUPFIELDKEY.ToString();
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.LOOKUPID;
LookupModel lm = context.GetLookup(analiticalFields.LOOKUPID);
var list = context.GetLookup(lm.LookUpMetaData.Tablename,
1);
int k = 0;
foreach (IEnumerable <string> enumerable in list)
{
int i = 0;
SaldoItem saldoitem = new SaldoItem();
saldoitem.Name = saldoItem.Name;
foreach (string s in enumerable)
{
if (i == 2)
{
saldoitem.Value = s;
}
if (i == 1)
{
saldoitem.Key = s;
}
if (k == 0 && i == 1)
{
k++;
}
if (k == 1 && i == 2)
{
k++;
}
i++;
}
saldoItem.LookUp.Add(saldoitem);
saldoItem.SelectedLookupItem =
saldoItem.LookUp.FirstOrDefault(e => e.Value == saldoItem.Value);
}
}
saldoItems.Add(saldoItem);
}
return(saldoItems);
}
private static void InsertConto(TempoDataBaseContext context, string path)
{
ContoAll allconto = new ContoAll();
allconto.Conto = new Conto();
allconto.Conto.UserId = Entrence.UserId;
allconto.Conto.FirmId = FirmaId;
var lines = File.ReadAllLines(path, Encoding.GetEncoding("Windows-1251"));
foreach (string line in lines)
{
var command = line.Split('|');
if (command.Length > 1)
{
var oper = command[0];
switch (oper)
{
case "A":
DateTime date = DateTime.Now;
if (DateTime.TryParse(command[1], out date))
{
allconto.Conto.Data = date;
}
else
{
var c = command[1].Split('.');
if (c.Length > 2)
{
date = new DateTime(int.Parse(c[2]), int.Parse(c[1]), int.Parse(c[0]));
allconto.Conto.Data = date;
}
else
{
allconto.Conto.Data = DateTime.Now;
}
}
AllAccounts = new ObservableCollection <AccountsModel>(context.GetAllAccounts(FirmaId, allconto.Conto.Data.Year));
break;
case "Z":
DateTime date1 = DateTime.Now;
if (DateTime.TryParse(command[1], out date1))
{
allconto.Conto.DataInvoise = date1;
}
else
{
var c = command[1].Split('.');
if (c.Length > 2)
{
date = new DateTime(int.Parse(c[2]), int.Parse(c[1]), int.Parse(c[0]));
allconto.Conto.DataInvoise = date1;
}
else
{
allconto.Conto.DataInvoise = DateTime.Now;
}
}
break;
case "C":
{
allconto.Conto.Oborot = mydecimal.Parse(command[1]);
break;
}
case "N":
allconto.Conto.DocNum = command[1];
break;
case "P":
allconto.Conto.Folder = command[1];
break;
case "O":
if (command.Length > 50)
{
command[1] = command[1].Substring(0, 50);
}
allconto.Conto.Reason = command[1];
break;
case "T":
if (command.Length > 50)
{
command[1] = command[1].Substring(0, 50);
}
allconto.Conto.Note = command[1];
break;
case "K":
allconto.Conto.KD = command[1];
break;
case "H":
allconto.KindDeal = command[1];
break;
case "W":
allconto.KindDds = command[1];
break;
case "Q":
allconto.CountActions = command[1];
break;
case "U":
int t = 0;
if (int.TryParse(command[1], out t))
{
allconto.Conto.UserId = t;
}
break;
case "S":
//дебит
LoadAnaliticDetailsD(command[1], context, allconto);
break;
case "D":
//кредит
LoadAnaliticDetailsK(command[1], context, allconto);
break;
case "I":
//кредит
allconto.NameClient = command[1];
break;
case "9":
allconto.Conto.NumberObject = int.Parse(command[1]);
break;
case "1":
SetAnaliticVal(command[1], context, allconto, 0);
break;
case "3":
SetAnaliticVal(command[1], context, allconto, 1);
break;
case "5":
SetAnaliticVal(command[1], context, allconto, 2);
break;
case "7":
SetAnaliticVal(command[1], context, allconto, 3);
break;
case "2":
SetAnaliticVal(command[1], context, allconto, 4);
break;
case "4":
SetAnaliticVal(command[1], context, allconto, 5);
break;
case "6":
SetAnaliticVal(command[1], context, allconto, 6);
break;
case "8":
SetAnaliticVal(command[1], context, allconto, 7);
break;
}
}
}
allconto.Conto.CDetails = "";
allconto.Conto.DDetails = "";
if (allconto.ItemsCredit != null)
{
foreach (SaldoItem currentsaldos in allconto.ItemsCredit)
{
if (currentsaldos.Fieldkey == 30)
{
allconto.Conto.OborotValutaK = currentsaldos.ValueVal;
allconto.Conto.CDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.ValueVal, currentsaldos.Lookupval);
currentsaldos.Value = currentsaldos.ValueVal.ToString(Vf.LevFormatUI);
}
else
{
if (currentsaldos.Fieldkey == 31)
{
allconto.Conto.OborotKolK = currentsaldos.ValueKol;
allconto.Conto.CDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.ValueKol, currentsaldos.Lookupval);
//currentsaldos.Value = currentsaldos.ValueVal.ToString(Vf.LevFormatUI);
}
else
{
allconto.Conto.CDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.Value, currentsaldos.Lookupval);
}
}
}
}
if (allconto.ItemsDebit != null)
{
foreach (SaldoItem currentsaldos in allconto.ItemsDebit)
{
if (currentsaldos.Fieldkey == 30)
{
allconto.Conto.OborotValutaD = currentsaldos.ValueVal;
allconto.Conto.DDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.ValueVal, currentsaldos.Lookupval);
currentsaldos.Value = currentsaldos.ValueVal.ToString(Vf.LevFormatUI);
}
else
{
if (currentsaldos.Fieldkey == 31)
{
allconto.Conto.OborotKolD = currentsaldos.ValueKol;
allconto.Conto.DDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.ValueKol, currentsaldos.Lookupval);
}
else
{
allconto.Conto.DDetails += string.Format("{0} - {1} {2}\n", currentsaldos.Name,
currentsaldos.Value, currentsaldos.Lookupval);
}
}
}
}
if (allconto.KindDeal == "2")
{
allconto.Conto.IsDdsSales = 1;
allconto.Conto.VopSales = allconto.KindDds;
allconto.Conto.IsSales = 1;
}
else
{
if (allconto.KindDeal == "1")
{
allconto.Conto.IsDdsPurchases = 1;
allconto.Conto.IsPurchases = 1;
allconto.Conto.VopPurchases = allconto.KindDds;
}
else
{
if (allconto.KindDeal == "3")
{
allconto.Conto.IsDdsSales = 1;
allconto.Conto.IsSales = 1;
allconto.Conto.IsPurchases = 1;
allconto.Conto.IsDdsPurchases = 1;
}
else
{
allconto.Conto.IsDdsSales = 0;
allconto.Conto.IsSales = 0;
allconto.Conto.IsPurchases = 0;
allconto.Conto.IsDdsPurchases = 0;
}
}
}
SaveMainConto(context, allconto);
if (allconto.KindDeal == "1" || allconto.KindDeal == "2" && allconto.CountActions != "3")
{
SaveDDS(context, allconto);
}
if (allconto.CountActions == "3")
{
var dds = SaveDDS(context, allconto);
allconto.Conto.IsDdsSales = 0;
allconto.Conto.IsSales = 0;
allconto.Conto.VopSales = "";
allconto.Conto.IsDdsPurchases = 0;
allconto.Conto.IsPurchases = 0;
allconto.Conto.VopPurchases = "";
allconto.Conto.Oborot = dds;
if (allconto.KindDeal == "2")
{
LoadAnaliticDetailsK(Entrence.DdsSmetkaK, context, allconto);
SaveMainConto(context, allconto);
}
else
{
if (allconto.KindDeal == "1")
{
LoadAnaliticDetailsD(Entrence.DdsSmetkaD, context, allconto);
SaveMainConto(context, allconto);
}
else
{
}
}
}
}
private static void SetAnaliticVal(string s, TempoDataBaseContext context, ContoAll allconto, int i)
{
SaldoItem item = null;
switch (i)
{
case 0:
if (allconto.ItemsDebit != null && allconto.ItemsDebit.Count > 0)
{
item = allconto.ItemsDebit[0];
}
Bulstad = s;
if (item == null)
{
var item1 = new SaldoItem {
SysLookup = false, Relookup = 17
};
var mainrez = item1.GetDictionary(
string.Format("AND \"{0}\"='{1}'", "BULSTAT", s),
string.Format(" order by \"{0}\"", "BULSTAT"));
if (mainrez.Count <= 1)
{
var lookupModel = context.GetLookup(17);
CodeClient = context.SelectMax(lookupModel.LookUpMetaData.Tablename, lookupModel.Fields[1].NameEng);
var lookupval = allconto.NameClient;
lookupModel.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
context.SaveRow(new List <string> {
CodeClient, CodeClient, lookupval, lookupval, s, s
}, lookupModel, FirmaId);
}
else
{
CodeClient = mainrez[1][0];
allconto.NameClient = mainrez[1][1];
int h = 0;
if (int.TryParse(mainrez[1][0], out h))
{
LiD = item1.GetLookUpId(0);
}
if (mainrez[1].Count > 4)
{
Bulstad = mainrez[1][3];
Vat = mainrez[1][4];
}
}
}
break;
case 1:
if (allconto.ItemsDebit != null && allconto.ItemsDebit.Count > 1)
{
item = allconto.ItemsDebit[1];
}
Factura = s;
break;
case 2:
if (allconto.ItemsDebit != null && allconto.ItemsDebit.Count > 2)
{
item = allconto.ItemsDebit[2];
}
DateTime date1;
if (DateTime.TryParse(s, out date1))
{
DataFactura = date1;
}
else
{
var c = s.Split('.');
if (c.Length > 2)
{
DataFactura = new DateTime(int.Parse(c[2]), int.Parse(c[1]), int.Parse(c[0]));
}
else
{
DataFactura = DateTime.Now;
}
}
break;
case 3:
if (allconto.ItemsDebit != null && allconto.ItemsDebit.Count > 3)
{
item = allconto.ItemsDebit[3];
}
break;
case 4:
if (allconto.ItemsCredit != null && allconto.ItemsCredit.Count > 0)
{
item = allconto.ItemsCredit[0];
}
Bulstad = s;
if (item == null)
{
var item1 = new SaldoItem {
SysLookup = false, Relookup = 17
};
var mainrez = item1.GetDictionary(
string.Format("AND \"{0}\"='{1}'", "BULSTAT", s),
string.Format(" order by \"{0}\"", "BULSTAT"));
if (mainrez.Count <= 1)
{
var lookupModel = context.GetLookup(17);
CodeClient = context.SelectMax(lookupModel.LookUpMetaData.Tablename, lookupModel.Fields[1].NameEng);
var lookupval = allconto.NameClient;
lookupModel.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
context.SaveRow(new List <string> {
CodeClient, CodeClient, lookupval, lookupval, s, s
}, lookupModel, FirmaId);
}
else
{
CodeClient = mainrez[1][1];
allconto.NameClient = mainrez[1][2];
int h = 0;
if (int.TryParse(mainrez[1][0], out h))
{
LiD = item1.GetLookUpId(0);
}
if (mainrez[1].Count > 4)
{
Bulstad = mainrez[1][3];
Vat = mainrez[1][4];
}
}
}
break;
case 5:
if (allconto.ItemsCredit != null && allconto.ItemsCredit.Count > 1)
{
item = allconto.ItemsCredit[1];
}
Factura = s;
break;
case 6:
if (allconto.ItemsCredit != null && allconto.ItemsCredit.Count > 2)
{
item = allconto.ItemsCredit[2];
}
DateTime date2;
if (DateTime.TryParse(s, out date2))
{
DataFactura = date2;
}
else
{
var c = s.Split('.');
if (c.Length > 2)
{
DataFactura = new DateTime(int.Parse(c[2]), int.Parse(c[1]), int.Parse(c[0]));
}
else
{
DataFactura = DateTime.Now;
}
}
break;
case 7:
if (allconto.ItemsCredit != null && allconto.ItemsCredit.Count > 3)
{
item = allconto.ItemsCredit[3];
}
break;
}
if (item != null)
{
if (!item.IsLookUp)
{
item.Value = s;
}
else
{
if (item.Name == "Контрагент")
{
var mainrez = item.GetDictionary(
string.Format("AND \"{0}\"='{1}'", "BULSTAT", s),
string.Format(" order by \"{0}\"", "BULSTAT"));
if (mainrez != null && mainrez.Count > 1)
{
item.Value = mainrez[1][0];
item.Lookupval = mainrez[1][1];
int h = 0;
if (int.TryParse(mainrez[1][0], out h))
{
item.LiD = item.GetLookUpId(0);
}
if (mainrez[1].Count > 4)
{
item.Bulstad = mainrez[1][3];
item.Vat = mainrez[1][4];
}
}
else
{
var lookupModel = context.GetLookup(17);
item.Value = context.SelectMax(lookupModel.LookUpMetaData.Tablename, lookupModel.Fields[1].NameEng);
item.Lookupval = allconto.NameClient;
item.Bulstad = s;
item.Vat = s;
lookupModel.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
context.SaveRow(new List <string> {
item.Value, item.Value, item.Lookupval, item.Lookupval, s, s
}, lookupModel, FirmaId);
}
}
}
}
}
private static void SaveMainConto(TempoDataBaseContext context, ContoAll allconto)
{
int ii = 0;
List <SaldoAnaliticModel> debit = new List <SaldoAnaliticModel>();
List <SaldoAnaliticModel> credit = new List <SaldoAnaliticModel>();
if (allconto.ItemsCredit != null)
{
foreach (SaldoItem currentsaldos in allconto.ItemsCredit)
{
SaldoAnaliticModel sa = new SaldoAnaliticModel();
sa.ACCFIELDKEY = currentsaldos.Fieldkey;
sa.ACCID = allconto.Conto.CreditAccount;
sa.DATA = DateTime.Now;
//if (currentsaldos.SelectedLookupItem != null && !string.IsNullOrWhiteSpace(currentsaldos.SelectedLookupItem.Key))
//{
// if (currentsaldos.SelectedLookupItem.Key != null)
// {
// int rez;
// sa.LOOKUPFIELDKEY = int.TryParse(currentsaldos.SelectedLookupItem.Key,out rez)?rez:0;
// sa.LOOKUPVAL = currentsaldos.SelectedLookupItem.Value;
// }
//}
sa.LOOKUPFIELDKEY = currentsaldos.LiD;
sa.LOOKUPVAL = currentsaldos.Lookupval;
sa.TYPEACCKEY = 0;
sa.VALUEDATE = currentsaldos.ValueDate;
sa.VAL = currentsaldos.Value;
sa.VALUEMONEY = currentsaldos.Valuedecimal;
sa.VALUENUM = currentsaldos.ValueInt;
sa.VALUED = currentsaldos.Valuedecimald;
sa.KURS = currentsaldos.IsKol ? currentsaldos.OnePrice : currentsaldos.ValueKurs;
sa.VALVAL = currentsaldos.IsKol ? currentsaldos.ValueKol : currentsaldos.ValueVal;
sa.KURSM = currentsaldos.MainKurs;
sa.KURSD = currentsaldos.KursDif;
sa.KURSD = currentsaldos.KursDif;
sa.TYPE = 2;
sa.LOOKUPID = currentsaldos.Relookup;
sa.CONTOID = allconto.Conto.Id;
sa.SORTORDER = ii;
debit.Add(sa);
ii++;
}
}
ii = 0;
if (allconto.ItemsDebit != null)
{
foreach (SaldoItem currentsaldos in allconto.ItemsDebit)
{
SaldoAnaliticModel sa = new SaldoAnaliticModel();
sa.ACCFIELDKEY = currentsaldos.Fieldkey;
sa.ACCID = allconto.Conto.DebitAccount;
sa.DATA = DateTime.Now;
sa.LOOKUPFIELDKEY = currentsaldos.LiD;
sa.TYPEACCKEY = 0;
sa.VALUEDATE = currentsaldos.ValueDate;
sa.VAL = currentsaldos.Value;
sa.VALUEMONEY = currentsaldos.Valuedecimal;
sa.VALUENUM = currentsaldos.ValueInt;
sa.VALUED = currentsaldos.Valuedecimald;
sa.KURS = currentsaldos.IsKol ? currentsaldos.OnePrice : currentsaldos.ValueKurs;
sa.VALVAL = currentsaldos.IsKol ? currentsaldos.ValueKol : currentsaldos.ValueVal;
sa.KURSM = currentsaldos.MainKurs;
sa.KURSD = currentsaldos.KursDif;
sa.KURSD = currentsaldos.KursDif;
sa.TYPE = 1;
sa.LOOKUPID = currentsaldos.Relookup;
sa.LOOKUPVAL = currentsaldos.Lookupval;
sa.CONTOID = allconto.Conto.Id;
sa.SORTORDER = ii;
credit.Add(sa);
ii++;
}
}
context.SaveConto(allconto.Conto, debit, credit);
}
private static decimal SaveDDS(TempoDataBaseContext context, ContoAll allconto)
{
var itemsDdsDnevPurchases = new List <DdsItemModel>(context.GetAllDnevItems(1));
var itemsDdsDnevSales = new List <DdsItemModel>(context.GetAllDnevItems(0));
var currItemDdsDnevPurchases = itemsDdsDnevPurchases.FirstOrDefault(e => e.Code == allconto.KindDds);
var currItemDdsDnevSales = itemsDdsDnevSales.FirstOrDefault(e => e.Code == allconto.KindDds);
int codeDnev = 2;
if (allconto.KindDeal == "1")
{
codeDnev = 1;
}
DdsDnevnikModel ddsDnevnikModel = context.LoadDenevnicItem(allconto.Conto.Id, codeDnev);
//ddsDnevnikModel.DocId = allconto.Conto.DocNum;
ddsDnevnikModel.Date = allconto.Conto.Data;
ddsDnevnikModel.DataF = allconto.Conto.Data;
ddsDnevnikModel.KindActivity = codeDnev;
ddsDnevnikModel.KindDoc = 1;
ddsDnevnikModel.Title = codeDnev == 1 ? "Дневник покупки" : "Дневник продажби";
ddsDnevnikModel.CodeDoc = allconto.Conto.KD;
ddsDnevnikModel.Stoke = allconto.Conto.Reason;
ddsDnevnikModel.DdsIncluded = allconto.IsDdsInclude ? "ВКЛЮЧЕН ДДС" : "НЕВКЛЮЧЕН ДДС";
if (codeDnev == 2)
{
if (allconto.ItemsCredit != null)
{
foreach (SaldoItem saldoItem in allconto.ItemsCredit)
{
if (saldoItem.IsLookUp && saldoItem.Name.Contains("Контрагент"))
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
ddsDnevnikModel.LookupElementID = saldoItem.LiD;
ddsDnevnikModel.ClNum = saldoItem.Value;
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
if (allconto.ItemsDebit != null)
{
foreach (SaldoItem saldoItem in allconto.ItemsDebit)
{
if (saldoItem.IsLookUp && saldoItem.Name.Contains("Контрагент"))
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
ddsDnevnikModel.LookupElementID = saldoItem.LiD;
ddsDnevnikModel.ClNum = saldoItem.Value;
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
}
else
{
if (allconto.ItemsDebit != null)
{
foreach (SaldoItem saldoItem in allconto.ItemsDebit)
{
if (saldoItem.IsLookUp && saldoItem.Name.Contains("Контрагент"))
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
ddsDnevnikModel.LookupElementID = saldoItem.LiD;
ddsDnevnikModel.ClNum = saldoItem.Value;
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
if (allconto.ItemsDebit != null)
{
foreach (SaldoItem saldoItem in allconto.ItemsCredit)
{
if (saldoItem.IsLookUp && saldoItem.Name.Contains("Контрагент"))
{
ddsDnevnikModel.LookupID = saldoItem.Relookup;
ddsDnevnikModel.LookupElementID = saldoItem.LiD;
ddsDnevnikModel.ClNum = saldoItem.Value;
}
if (saldoItem.Name.Contains("Дата на фактура"))
{
ddsDnevnikModel.DataF = saldoItem.ValueDate;
}
if (saldoItem.Name.Contains("Номер фактура"))
{
ddsDnevnikModel.DocId = saldoItem.Value;
}
}
}
}
if (allconto.ItemsCredit == null && allconto.ItemsDebit == null)
{
ddsDnevnikModel.DataF = DataFactura;
ddsDnevnikModel.Bulstat = Bulstad;
ddsDnevnikModel.Nzdds = Vat ?? Bulstad;
ddsDnevnikModel.DocId = Factura;
ddsDnevnikModel.LookupID = 17;
ddsDnevnikModel.ClNum = CodeClient;
}
decimal ddspercent = 0;
ddspercent = codeDnev == 1
? currItemDdsDnevPurchases != null ? currItemDdsDnevPurchases.DdsPercent : 0
: currItemDdsDnevSales != null ? currItemDdsDnevSales.DdsPercent : 0;
string name = codeDnev == 1
? currItemDdsDnevPurchases != null ? currItemDdsDnevPurchases.Name : ""
: currItemDdsDnevSales != null ? currItemDdsDnevSales.Name : "";
var vm = new DdsViewModel(ddsDnevnikModel, new DdsDnevnicItem
{
DdsPercent = ddspercent,
DdsSuma = allconto.Conto.Oborot,
Name = name,
In = true
});
vm.SaveCommand.Execute(null);
return(Decimal.Round(allconto.Conto.Oborot * ddspercent / 100, 2));
}
protected override void OnStartup(StartupEventArgs e)
{
// Get Reference to the current Process
bool retV;
theMutex = new Mutex(true, "Tempo-3e8c9b1f-7798-4c3c-be4f-f4a39c0d8eb1", out retV);
if (!retV)
{
MessageBoxWrapper.Show("Темпо е стартирано!");
theMutex = null;
Application.Current.Shutdown();
return;
}
// *******************************************************************
// TODO - Uncomment one of the lines of code that create a CultureInfo
// in order to see the application run with localized text in the UI.
// *******************************************************************
CultureInfo culture = new CultureInfo("bg-BG");
culture.NumberFormat.NumberDecimalSeparator = ".";
var context = new TempoDataBaseContext();
Vf.SetFormaters(context.GetSettings("LV"), context.GetSettings("KURS"), context.GetSettings("VAL"), context.GetSettings("KOL"));
// ITALIAN
// *******************************************************************
// Thanks to Corrado Cavalli for translating this application's display
// text to Italian, as spoken in Italy.
// Corrado's blog: http://blogs.ugidotnet.org/corrado/Default.aspx
//
//culture = new CultureInfo("it-IT");
// FRENCH
// *******************************************************************
// Thanks to Laurent Bugnion for translating this application's display
// text to French, as spoken in Switzerland.
// Laurent's blog: http://www.galasoft.ch/
//
//culture = new CultureInfo("fr-CH");
// GERMAN
// *******************************************************************
// Thanks to Marco Goertz , Microsoft Cider Team Senior Development Lead,
// for translating this application's display text to German, as spoken in Germany.
//
//culture = new CultureInfo("de-DE");
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
// Ensure the current culture passed into bindings is the OS culture.
// By default, WPF uses en-US as the culture, regardless of the system settings.
FrameworkElement.LanguageProperty.OverrideMetadata(
typeof(FrameworkElement),
new FrameworkPropertyMetadata(
XmlLanguage.GetLanguage(CultureInfo.CurrentCulture.IetfLanguageTag)));
// define application exception handler
Application.Current.DispatcherUnhandledException += new
DispatcherUnhandledExceptionEventHandler(
AppDispatcherUnhandledException);
EventManager.RegisterClassHandler(typeof(Window), Window.LoadedEvent,
new RoutedEventHandler(WindowLoaded));
//EventManager.RegisterClassHandler(typeof(UserControl), UserControl.LoadedEvent,
//new RoutedEventHandler(UserControlLoaded));
// defer other startup processing to base class
EventManager.RegisterClassHandler(typeof(DatePicker),
DatePicker.PreviewKeyDownEvent,
new KeyEventHandler(DatePicker_PreviewKeyDown));
base.OnStartup(e);
}
public void LoadFromDb()
{
var context = new TempoDataBaseContext();
mDictionary = context.LoadConfig();
}
