public Form_myOrg_Person_Edit(long xOffice_ID,NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; usrc_NavigationButtons1.Init(nav); m_Office_ID = xOffice_ID; tbl_myOrganisation_Person = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(myOrganisation_Person))); lngRPM.s_myOrganisation_Person_Data.Text(this); this.Icon = Properties.Resources.Person; this.usrc_EditTable1.Title = lngRPM.s_Edit_Office_Data.s; string selection = @" myOrganisation_Person_$_per_$_cfn_$$FirstName, myOrganisation_Person_$_per_$_cln_$$LastName, myOrganisation_Person_$_per_$$DateOfBirth, myOrganisation_Person_$_per_$$Tax_ID, myOrganisation_Person_$_per_$$Registration_ID, myOrganisation_Person_$_office_$_mo_$_orgd_$_org_$$Name, myOrganisation_Person_$_office_$$Name, myOrganisation_Person_$_office_$$ShortName, ID "; long_v Office_ID_v = null; if (m_Office_ID >= 0) { Office_ID_v = new long_v(m_Office_ID); } if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_myOrganisation_Person, selection, ColumnToOrderBy, false, " where myOrganisation_Person_$_office_$$ID = " + m_Office_ID.ToString() + " ", null, false,nav)) { usrc_EditTable1.FillInitialData(); } else { bclose = true; } }
public Form_myOrg_Office(NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; usrc_NavigationButtons1.Init(nav); lngRPM.s_Edit_Office_Data.Text(btn_Office_Data_And_FVI_SLO_RealEstateBP); if (myOrg.ID_v != null) { myOrganisation_ID = myOrg.ID_v.v; tbl_Office = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Office))); this.Text = lngRPM.s_Edit_Offices.s; this.usrc_EditTable1.Title = lngRPM.s_Edit_Offices.s; long_v myOrganisation_ID_v = new long_v(myOrganisation_ID); string selection = "Office_$$Name,Office_$$ShortName,Office_$_mo_$_orgd_$_org_$$Name,Office_$_mo_$_orgd_$_orgt_$$OrganisationTYPE,Office_$_mo_$_orgd_$_org_$$Tax_ID,ID"; string where_condition = " where Office_$_mo_$$ID = " + myOrganisation_ID.ToString() + " "; if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_Office, selection, ColumnToOrderBy, false, null, null, false,nav)) { usrc_EditTable1.FillInitialData(); } else { bclose = true; } } else { LogFile.Error.Show("ERROR:Tangenta:Form_myOrg_Offices_Edit():myOrg.ID_v is not defined!"); bclose = true; } }
public Form_ShopC_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, Control xParentControl) { InitializeComponent(); dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; ParentControl = xParentControl; if (ParentControl != null) { if (ParentControl is usrc_StockEditForSelectedStockTake) { m_usrc_StockEditForSelectedStockTake = (usrc_StockEditForSelectedStockTake)ParentControl; } } this.Text = lngRPM.s_Items.s; rdb_OnlyInOffer.Checked = true; lngRPM.s_OnlyInOffer.Text(this.rdb_OnlyInOffer); lngRPM.s_AllItems.Text(this.rdb_All); lngRPM.s_OnlyNotInOffer.Text(this.rdb_OnlyNotInOffer); if (nav==null) { nav = new NavigationButtons.Navigation(); nav.m_eButtons = NavigationButtons.Navigation.eButtons.OkCancel; nav.eExitResult = NavigationButtons.Navigation.eEvent.NOTHING; usrc_NavigationButtons1.Init(nav); } }
public static bool GetOneFrom_Item_ID(long Item_ID, ref long_v PurchasePrice_Item_ID) { string Err = null; int iLimit = 1; string sql = @"select " + DBSync.DBSync.sTop(iLimit) + @"ppi.ID from PurchasePrice_Item ppi inner join PurchasePrice pp on pp.ID = ppi.PurchasePrice_ID where ppi.Item_ID = " + Item_ID.ToString() + " order by pp.PurchasePriceDate desc " + DBSync.DBSync.sLimit(iLimit); DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { if (PurchasePrice_Item_ID == null) { PurchasePrice_Item_ID = new long_v(); } PurchasePrice_Item_ID.v = (long)dt.Rows[0]["ID"]; } else { PurchasePrice_Item_ID = null; } return true; } else { LogFile.Error.Show("ERROR:f_PurchasePrice_Item:GetOneFrom_Item_ID:sql=" + sql + "\r\nErr=" + Err); return false; } }
public bool Get(long_v xOffice_Data_ID_v) { string Err = null; ID_v = null; Office_Data_ID_v = null; BuildingNumber_v = null; BuildingSectionNumber_v = null; Community_v = null; CadastralNumber_v = null; ValidityDate_v = null; ClosingTag_v = null; SoftwareSupplier_TaxNumber_v = null; PremiseType_v = null; if (xOffice_Data_ID_v != null) { string sql = @"SELECT ID, Office_Data_ID, BuildingNumber, BuildingSectionNumber, Community, CadastralNumber, ValidityDate, ClosingTag, SoftwareSupplier_TaxNumber, PremiseType FROM FVI_SLO_RealEstateBP where Office_Data_ID = " + xOffice_Data_ID_v.v.ToString(); DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { ID_v = tf.set_long(dt.Rows[0]["ID"]); Office_Data_ID_v = tf.set_long(dt.Rows[0]["Office_Data_ID"]); BuildingNumber_v = tf.set_int(dt.Rows[0]["BuildingNumber"]); BuildingSectionNumber_v = tf.set_int(dt.Rows[0]["BuildingSectionNumber"]); Community_v = tf.set_string(dt.Rows[0]["Community"]); CadastralNumber_v = tf.set_int(dt.Rows[0]["CadastralNumber"]); ValidityDate_v = tf.set_DateTime(dt.Rows[0]["ValidityDate"]); ClosingTag_v = tf.set_string(dt.Rows[0]["ClosingTag"]); SoftwareSupplier_TaxNumber_v = tf.set_string(dt.Rows[0]["SoftwareSupplier_TaxNumber"]); PremiseType_v = tf.set_string(dt.Rows[0]["PremiseType"]); } return true; } else { LogFile.Error.Show("ERROR:myOrg_Office:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:myOrg_Office:Get:(Office_ID_v == null)"); return false; } }
public PersonAccount_EditForm(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID) { InitializeComponent(); dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; this.Text = lngRPM.s_Items.s; }
internal static bool Get(string_v OrgTYPE_v, ref long_v cOrgTYPE_ID_v) { if (OrgTYPE_v != null) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string spar = "@par"; SQL_Parameter par = new SQL_Parameter(spar, SQL_Parameter.eSQL_Parameter.Nvarchar, false, OrgTYPE_v.v); lpar.Add(par); string sql = @"select ID from cOrgTYPE where OrganisationTYPE = @par"; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (cOrgTYPE_ID_v == null) { cOrgTYPE_ID_v = new long_v(); } cOrgTYPE_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = @"insert into cOrgTYPE (OrganisationTYPE) values (@par)"; long cOrgTYPE_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref cOrgTYPE_ID, ref oret, ref Err, "cOrgTYPE")) { if (cOrgTYPE_ID_v == null) { cOrgTYPE_ID_v = new long_v(); } cOrgTYPE_ID_v.v = cOrgTYPE_ID; return true; } else { LogFile.Error.Show("ERROR:TangentaDB:f_cOrgTYPE:Get(string_v OrgTYPE_v, ref long_v cOrgTYPE_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:TangentaDB:f_cOrgTYPE:Get(string_v OrgTYPE_v, ref long_v cOrgTYPE_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:TangentaDB:f_cOrgTYPE:Get(string_v OrgTYPE_v, ref long_v cOrgTYPE_ID_v) OrgTYPE_v may not be null!"); return false; } }
public static bool Get( long_v Organisation_ID_v, ref long_v Bank_ID_v) { string Err = null; string Organisation_ID_v_cond = "Organisation_ID is null"; string Organisation_ID_v_Value = "null"; if (Organisation_ID_v != null) { Organisation_ID_v_Value = Organisation_ID_v.v.ToString(); Organisation_ID_v_cond = "Organisation_ID = " + Organisation_ID_v.v.ToString(); } string sql_select = "select ID from Bank where " + Organisation_ID_v_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, null, ref Err)) { if (dt.Rows.Count > 0) { if (Bank_ID_v == null) { Bank_ID_v = new long_v(); } Bank_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @"insert into Bank (Organisation_ID) values ( " + Organisation_ID_v_Value + ")"; object oret = null; long Bank_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, null, ref Bank_ID, ref oret, ref Err, "Bank")) { if (Bank_ID_v == null) { Bank_ID_v = new long_v(); } Bank_ID_v.v = Bank_ID; return true; } else { LogFile.Error.Show("ERROR:f_Bank:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_Bank:Get:sql=" + sql_select + "\r\nErr=" + Err); } return false; }
internal static bool Get(string_v country_v, ref long_v cState_Person_ID_v) { if (country_v != null) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string spar = "@par"; SQL_Parameter par = new SQL_Parameter(spar, SQL_Parameter.eSQL_Parameter.Nvarchar, false, country_v.v); lpar.Add(par); string sql = @"select ID from cState_Person where State = @par"; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (cState_Person_ID_v == null) { cState_Person_ID_v = new long_v(); } cState_Person_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = @"insert into cState_Person (State) values (@par)"; long cState_Person_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref cState_Person_ID, ref oret, ref Err, "cState_Person")) { if (cState_Person_ID_v == null) { cState_Person_ID_v = new long_v(); } cState_Person_ID_v.v = cState_Person_ID; return true; } else { LogFile.Error.Show("ERROR:TangentaDB:f_cState_Person:Get(string_v country_v, ref long_v atom_cState_Person_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:TangentaDB:f_cState_Person:Get(string_v country_v, ref long_v atom_cState_Person_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } else { cState_Person_ID_v = null; return true; } }
public Form_Customer_Person_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID) { InitializeComponent(); dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; this.Text = lngRPM.s_Items.s; this.usrc_EditTable.Title = xtbl.lngTableName.s; }
public Form_PersonData_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; this.Text = lngRPM.s_Items.s; }
public Form_Templates(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; this.Text = lngRPM.s_Items.s; rdb_OnlyInOffer.Checked = true; this.rdb_OnlyInOffer.Text = lngRPM.s_OnlyInOffer.s; this.rdb_All.Text = lngRPM.s_AllItems.s; this.rdb_OnlyNotInOffer.Text = lngRPM.s_OnlyNotInOffer.s; }
public static bool Get(long Stock_id, long stock_type_id, DateTime dEventTime, decimal dQuantity, ref long_v JOURNAL_Stock_ID) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string spar_JOURNAL_Stock_Type_ID = "@par_JOURNAL_Stock_Type_ID"; SQL_Parameter par_JOURNAL_Stock_Type_ID = new SQL_Parameter(spar_JOURNAL_Stock_Type_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, stock_type_id); lpar.Add(par_JOURNAL_Stock_Type_ID); string spar_Stock_ID = "@par_Stock_ID"; SQL_Parameter par_Stock_ID = new SQL_Parameter(spar_Stock_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, Stock_id); lpar.Add(par_Stock_ID); string spar_EventTime = "@par_EventTime"; SQL_Parameter par_EventTime = new SQL_Parameter(spar_EventTime, SQL_Parameter.eSQL_Parameter.Datetime, false, dEventTime); lpar.Add(par_EventTime); long Atom_WorkPeriod_id = GlobalData.Atom_WorkPeriod_ID; string spar_Atom_WorkPeriod_ID = "@par_Atom_WorkPeriod_ID"; SQL_Parameter par_Atom_WorkPeriod_ID = new SQL_Parameter(spar_Atom_WorkPeriod_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, Atom_WorkPeriod_id); lpar.Add(par_Atom_WorkPeriod_ID); string spar_dQuantity = "@par_dQuantity"; SQL_Parameter par_dQuantity = new SQL_Parameter(spar_dQuantity, SQL_Parameter.eSQL_Parameter.Decimal, false, dQuantity); lpar.Add(par_dQuantity); string table_name = "JOURNAL_Stock"; string sql = "insert into " + table_name + " (JOURNAL_Stock_Type_ID,Stock_ID,EventTime,Atom_WorkPeriod_ID,dQuantity)values(" + spar_JOURNAL_Stock_Type_ID + "," + spar_Stock_ID + "," + spar_EventTime + "," + spar_Atom_WorkPeriod_ID + "," + spar_dQuantity + ")"; long id = -1; object oret = null; string Err = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref id, ref oret, ref Err, table_name)) { if (JOURNAL_Stock_ID == null) { JOURNAL_Stock_ID = new long_v(); } JOURNAL_Stock_ID.v = id; return true; } else { LogFile.Error.Show("ERROR:f_JOURNAL_Stock:Get:sql=" + sql + "\r\nErr=" + Err); return false; } }
public static bool Get(long_v Language_ID_v, string doc_page_type_Name, string doc_page_type_Description, decimal Page_Width, decimal Page_Height, ref long doc_page_type_ID, string doc_type_Name, string doc_type_Description, ref long doc_type_ID, string doc_Name, string doc_Description, byte[] doc, bool Compressed, bool Active, bool Default, ref long doc_ID ) { string_v doc_page_type_Description_v = new string_v(doc_page_type_Description); decimal_v Width_v = new decimal_v(Page_Width); decimal_v Height_v = new decimal_v(Page_Height); if (f_doc_page_type.Get(doc_page_type_Name, doc_page_type_Description_v, Width_v, Height_v, ref doc_page_type_ID)) { string_v doc_type_Description_v = new string_v(doc_type_Description); long_v doc_page_type_ID_v = new long_v(doc_page_type_ID); if (f_doc_type.Get(doc_type_Name, doc_type_Description_v, Language_ID_v, doc_page_type_ID_v, ref doc_type_ID)) { long_v doc_type_ID_v = new long_v(doc_type_ID); string_v doc_Description_v = new string_v(doc_Description); if (Get(doc_Name, doc_Description_v, doc, doc_type_ID_v, Compressed, Active, Default, ref doc_ID)) { return true; } } } return false; }
public static bool Get(long myOrganisation_id, ref List<myOrg_Office> myOrg_Office_list) { DataTable dt = new DataTable(); myOrg_Office_list.Clear(); string sql = null; sql = @"select ID FROM Office where myOrganisation_ID = " + myOrganisation_id.ToString(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { int i = 0; int iCount = dt.Rows.Count; for (i = 0; i < iCount; i++) { DataRow dr = dt.Rows[i]; long Office_ID = (long)dr["ID"]; myOrg_Office moffice = new myOrg_Office(); long_v Office_ID_v = new long_v(Office_ID); if (moffice.Get(Office_ID_v)) { myOrg_Office_list.Add(moffice); } } } return true; } else { LogFile.Error.Show("ERROR:TangentaDB:myOrg_Office_List:Get:sql=" + sql + "\r\nErr=" + Err); return false; } }
public bool Update_Customer_Remove() { string sql = "update DocInvoice set Atom_Customer_Org_ID = null,Atom_Customer_Person_ID = null where ID = " + this.Doc_ID.ToString(); string Err = null; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQL(sql, null, ref ores, ref Err)) { this.Atom_Customer_Org_ID_v = null; this.Atom_Customer_Person_ID_v = null; return true; } else { LogFile.Error.Show("ERROR:CurrentInvoice:Update_Customer_Remove:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } }
public bool Update_Customer_Person(string DocInvoice, long Customer_Person_ID, ref long_v xAtom_Customer_Person_ID_v) { if (f_Atom_Customer_Person.Get(Customer_Person_ID, ref xAtom_Customer_Person_ID_v)) { if (xAtom_Customer_Person_ID_v != null) { string sql = "update "+DocInvoice+" set Atom_Customer_Person_ID = " + xAtom_Customer_Person_ID_v.v.ToString() + ",Atom_Customer_Org_ID = null where ID = " + this.Doc_ID.ToString(); string Err = null; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQL(sql, null, ref ores, ref Err)) { if (Atom_Customer_Person_ID_v == null) { Atom_Customer_Person_ID_v = new long_v(); } Atom_Customer_Person_ID_v.v = xAtom_Customer_Person_ID_v.v; Atom_Customer_Org_ID_v = null; return true; } else { LogFile.Error.Show("ERROR:CurrentInvoice:Update_Customer_Person:\r\nsql=" + sql + "\r\nErr=" + Err); } } } return false; }
public bool Storno(ref long Storno_DocInvoice_ID, bool bStorno, string sReason,ref DateTime retissue_time) { object ores = null; string Err = null; DataTable dt_ProfInv = new DataTable(); string sql = @"select Draft, DraftNumber, FinancialYear, NumberInFinancialYear, NetSum, Discount, EndSum, TaxSum, GrossSum, Atom_Customer_Person_ID, Atom_Customer_Org_ID, WarrantyExist, WarrantyConditions, WarrantyDurationType, WarrantyDuration, DocDuration, DocDurationType, TermsOfPayment_ID, PaymentDeadline, MethodOfPayment_ID Paid, Storno, Invoice_Reference_ID, Invoice_Reference_Type from DocInvoice where DocInvoice.ID = " + Doc_ID.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt_ProfInv, sql, ref Err)) { int_v DraftNumber_v = tf.set_int(dt_ProfInv.Rows[0]["DraftNumber"]); int_v FinancialYear_v = tf.set_int(dt_ProfInv.Rows[0]["FinancialYear"]); decimal_v NetSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["NetSum"]); decimal_v Discount_v = tf.set_decimal(dt_ProfInv.Rows[0]["Discount"]); decimal_v EndSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["EndSum"]); decimal_v TaxSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["TaxSum"]); decimal_v GrossSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["GrossSum"]); long_v Atom_Customer_Person_ID_v = tf.set_long(dt_ProfInv.Rows[0]["Atom_Customer_Person_ID"]); long_v Atom_Customer_Org_ID_v = tf.set_long(dt_ProfInv.Rows[0]["Atom_Customer_Org_ID"]); bool_v WarrantyExist_v = tf.set_bool(dt_ProfInv.Rows[0]["WarrantyExist"]); string_v WarrantyConditions_v = tf.set_string(dt_ProfInv.Rows[0]["WarrantyConditions"]); int_v WarrantyDurationType_v = tf.set_int(dt_ProfInv.Rows[0]["WarrantyDurationType"]); int_v WarrantyDuration_v = tf.set_int(dt_ProfInv.Rows[0]["WarrantyDuration"]); long_v DocDuration_v = tf.set_long(dt_ProfInv.Rows[0]["DocDuration"]); int_v DocDurationType_v = tf.set_int(dt_ProfInv.Rows[0]["DocDurationType"]); long_v TermsOfPayment_ID_v = tf.set_long(dt_ProfInv.Rows[0]["TermsOfPayment_ID"]); int iNewNumberInFinancialYear = -1; GetNewNumberInFinancialYear(ref iNewNumberInFinancialYear); int_v iNewNumberInFinancialYear_v = new int_v(iNewNumberInFinancialYear); long_v Storno_Invoice_ID_v = new long_v(Doc_ID); NetSum_v.v = -NetSum_v.v; TaxSum_v.v = -TaxSum_v.v; GrossSum_v.v = -GrossSum_v.v; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); sql = @"insert into DocInvoice ( Draft, DraftNumber, FinancialYear, NumberInFinancialYear, NetSum, Discount, EndSum, TaxSum, GrossSum, Atom_Customer_Person_ID, Atom_Customer_Org_ID, WarrantyExist, WarrantyConditions, WarrantyDurationType, WarrantyDuration, DocDuration, DocDurationType, TermsOfPayment_ID, Invoice_Reference_ID, Storno, Invoice_Reference_Type ) values ( 0," + GetParam("DraftNumber", ref lpar, DraftNumber_v) + "," + GetParam("FinancialYear", ref lpar, FinancialYear_v) + "," + GetParam("NumberInFinancialYear", ref lpar, iNewNumberInFinancialYear_v) + "," + GetParam("NetSum", ref lpar, NetSum_v) + "," + GetParam("Discount", ref lpar, Discount_v) + "," + GetParam("EndSum", ref lpar, EndSum_v) + "," + GetParam("TaxSum", ref lpar, TaxSum_v) + "," + GetParam("GrossSum", ref lpar, GrossSum_v) + "," + GetParam("Atom_Customer_Person_ID", ref lpar, Atom_Customer_Person_ID_v) + "," + GetParam("Atom_Customer_Org_ID", ref lpar, Atom_Customer_Org_ID_v) + "," + GetParam("WarrantyExist", ref lpar, WarrantyExist_v) + "," + GetParam("WarrantyConditions", ref lpar, WarrantyConditions_v) + "," + GetParam("WarrantyDurationType", ref lpar, WarrantyDurationType_v) + "," + GetParam("WarrantyDuration", ref lpar, WarrantyDuration_v) + "," + GetParam("DocDuration", ref lpar, DocDuration_v) + "," + GetParam("DocDurationType", ref lpar, DocDurationType_v) + "," + GetParam("TermsOfPayment_ID", ref lpar, TermsOfPayment_ID_v) + "," + GetParam("Invoice_Reference_ID", ref lpar, Storno_Invoice_ID_v) + @", 1, 'STORNO' )"; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Storno_DocInvoice_ID, ref ores, ref Err, "DocInvoice")) { string sBit = "0"; if (bStorno) { sBit = "1"; } sql = " update Docinvoice set Storno = " + sBit + @", Invoice_Reference_ID = " + Storno_DocInvoice_ID.ToString() + @", Invoice_Reference_Type = 'STORNO' where ID = " + this.Doc_ID.ToString(); if (DBSync.DBSync.ExecuteNonQuerySQL(sql, null, ref ores, ref Err)) { long Journal_DocInvoice_ID = -1; DateTime_v issue_time = new DateTime_v(DateTime.Now); retissue_time = issue_time.v; if (f_Journal_DocInvoice.Write(Storno_DocInvoice_ID, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceStornoTime.ID, issue_time, ref Journal_DocInvoice_ID)) { return true; } return false; } else { LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err); return false; } }
public void Set_SelectedShopB_Items(string DocInvoice,DataGridView dgv_SelectedSimpleItems, DataTable dt_SelectedSimpleItem, DataGridView dgv_SimpleItem, DataTable dt_SimpleItems) { long Atom_SimpleItem_ID; long DocInvoice_ShopB_Item_DocInvoice_ID; long DocInvoice_ShopB_Item_SimpleItem_ID; long DocInvoice_ShopB_Item_Atom_SimpleItem_Name_ID; long_v DocInvoice_ShopB_Item_Atom_SimpleItem_Image_ID_v; long DocInvoice_ShopB_Item_Atom_Taxation_ID; int DocInvoice_ShopB_Item_Quantity; string DocInvoice_ShopB_Item_Atom_SimpleItem_Atom_SimpleItem_Name; string DocInvoice_ShopB_Item_Atom_SimpleItem_Atom_SimpleItem_Abbreviation; decimal DocInvoice_ShopB_Item_RetailSimpleItemPrice; decimal DocInvoice_ShopB_Item_Discount; string DocInvoice_ShopB_Item_Atom_Taxation_Name; decimal DocInvoice_ShopB_Item_Atom_Taxation_Rate; decimal DocInvoice_ShopB_Item_TaxPrice; decimal DocInvoice_ShopB_Item_RetailSimpleItemPriceWithDiscount; decimal DocInvoice_ShopB_Item_PriceWithoutTax; decimal DocInvoice_ShopB_Item_ExtraDiscount; dt_SelectedSimpleItem.Clear(); foreach (DataRow drsa in dtCurrent_Atom_Price_ShopBItem.Rows) { Atom_SimpleItem_ID = (long)drsa["ID"]; DocInvoice_ShopB_Item_DocInvoice_ID = (long)drsa[DocInvoice+"_ID"]; DocInvoice_ShopB_Item_SimpleItem_ID = (long)drsa["SimpleItem_ID"]; DocInvoice_ShopB_Item_Atom_SimpleItem_Name_ID = (long)drsa["Atom_SimpleItem_Name_ID"]; if (drsa["Atom_SimpleItem_Image_ID"] is long) { DocInvoice_ShopB_Item_Atom_SimpleItem_Image_ID_v = new long_v(); DocInvoice_ShopB_Item_Atom_SimpleItem_Image_ID_v.v = (long)drsa["Atom_SimpleItem_Image_ID"]; } else { DocInvoice_ShopB_Item_Atom_SimpleItem_Image_ID_v = null; } DocInvoice_ShopB_Item_Atom_Taxation_ID = (long)drsa["Atom_Taxation_ID"]; DocInvoice_ShopB_Item_Quantity = (int)drsa["iQuantity"]; DocInvoice_ShopB_Item_Atom_SimpleItem_Atom_SimpleItem_Name = (string)drsa["Name"]; DocInvoice_ShopB_Item_Atom_SimpleItem_Atom_SimpleItem_Abbreviation = (string)drsa["Abbreviation"]; DocInvoice_ShopB_Item_RetailSimpleItemPrice = (decimal)drsa["RetailSimpleItemPrice"]; DocInvoice_ShopB_Item_Discount = (decimal)drsa["Discount"]; DocInvoice_ShopB_Item_ExtraDiscount = (decimal)drsa["ExtraDiscount"]; DocInvoice_ShopB_Item_Atom_Taxation_Name = (string)drsa["Atom_Taxation_Name"]; DocInvoice_ShopB_Item_Atom_Taxation_Rate = (decimal)drsa["Atom_Taxation_Rate"]; DocInvoice_ShopB_Item_TaxPrice = (decimal)drsa["TaxPrice"]; DocInvoice_ShopB_Item_RetailSimpleItemPriceWithDiscount = (decimal)drsa["RetailSimpleItemPriceWithDiscount"]; DocInvoice_ShopB_Item_PriceWithoutTax = DocInvoice_ShopB_Item_RetailSimpleItemPriceWithDiscount - DocInvoice_ShopB_Item_TaxPrice; DataRow dr = dt_SelectedSimpleItem.NewRow(); dr[DBtcn.column_SelectedShopBItem_dt_ShopBItem_Index] = Find_dt_SimpleItem_Index(dt_SimpleItems, DocInvoice_ShopB_Item_SimpleItem_ID); dr[DBtcn.column_Selected_Atom_Price_ShopBItem_ID] = Atom_SimpleItem_ID; dr[DBtcn.column_SelectedShopBItem_ShopBItem_ID] = DocInvoice_ShopB_Item_SimpleItem_ID; dr[DBtcn.column_SelectedShopBItem_Count] = DocInvoice_ShopB_Item_Quantity; dr[DBtcn.column_SelectedShopBItemName] = DocInvoice_ShopB_Item_Atom_SimpleItem_Atom_SimpleItem_Name; dr[DBtcn.column_SelectedShopBItemPriceWithoutTax] = DocInvoice_ShopB_Item_PriceWithoutTax; dr[DBtcn.column_SelectedShopBItemPriceTax] = DocInvoice_ShopB_Item_TaxPrice; dr[DBtcn.column_SelectedShopBItem_TaxName] = DocInvoice_ShopB_Item_Atom_Taxation_Name; dr[DBtcn.column_SelectedShopBItem_TaxRate] = DocInvoice_ShopB_Item_Atom_Taxation_Rate; dr[DBtcn.column_SelectedShopBItem_ExtraDiscount] = DocInvoice_ShopB_Item_ExtraDiscount; dr[DBtcn.column_SelectedShopBItemPrice] = DocInvoice_ShopB_Item_RetailSimpleItemPriceWithDiscount; dt_SelectedSimpleItem.Rows.Add(dr); int index = dt_SelectedSimpleItem.Rows.IndexOf(dr); if (DocInvoice_ShopB_Item_ExtraDiscount != 0) { try { dgv_SelectedSimpleItems.Rows[index].Cells["btn_discount"].Value = DocInvoice_ShopB_Item_ExtraDiscount; } catch { dgv_SelectedSimpleItems.Rows[index].Cells["SelectedSimpleItem_ExtraDiscount"].Value = DocInvoice_ShopB_Item_ExtraDiscount; } } } m_InvoiceDB.Set_dgv_selected_ShopB_Items_Columns(dgv_SelectedSimpleItems); }
public static bool Get(GlobalData.ePaymentType ePaymentType, long_v BankAccount_ID_v, ref long MethodOfPayment_ID) { string sPaymentType = null; MethodOfPayment_ID = -1; sPaymentType = GlobalData.Get_sPaymentType(ePaymentType); List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Err = null; DataTable dt = new DataTable(); string scond_PaymentType = " PaymentType is null "; string sval_PaymentType = " null "; string scond_Atom_BankAccount_ID = " Atom_BankAccount_ID is null "; string sval_Atom_BankAccount_ID = " null "; string spar_PaymentType = "@par_PaymentType"; SQL_Parameter par_PaymentType = new SQL_Parameter(spar_PaymentType, SQL_Parameter.eSQL_Parameter.Nvarchar, false, sPaymentType); lpar.Add(par_PaymentType); scond_PaymentType = " PaymentType = " + spar_PaymentType; sval_PaymentType = " " + spar_PaymentType + " "; string spar_Atom_BankAccount_ID = "@par_Atom_BankAccount_ID"; if (BankAccount_ID_v != null) { SQL_Parameter par_Atom_BankAccount_ID = new SQL_Parameter(spar_Atom_BankAccount_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, BankAccount_ID_v.v); lpar.Add(par_Atom_BankAccount_ID); scond_Atom_BankAccount_ID = " Atom_BankAccount_ID = " + spar_Atom_BankAccount_ID; sval_Atom_BankAccount_ID = " " + spar_Atom_BankAccount_ID + " "; } string sql = " select ID from MethodOfPayment where " + scond_PaymentType + " and " + scond_Atom_BankAccount_ID; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { MethodOfPayment_ID = (long)dt.Rows[0]["ID"]; return true; } else { sql = @" insert into MethodOfPayment (PaymentType,Atom_BankAccount_ID) values (" + sval_PaymentType +","+ sval_Atom_BankAccount_ID + ")"; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref MethodOfPayment_ID, ref oret, ref Err, "MethodOfPayment")) { return true; } else { LogFile.Error.Show("ERROR:f_MethodOfPayment:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_MethodOfPayment:Get:sql=" + sql + "\r\nErr=" + Err); return false; } }
public static bool Get( string_v TRR_v, bool_v Active_v, string_v BankAccount_Description_v, long_v Bank_ID_v, ref long_v BankAccount_ID_v) { string Err = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string TRR_v_cond = "TRR is null"; string TRR_v_Value = "null"; if (TRR_v != null) { TRR_v_Value = "@par_TRR"; SQL_Parameter par_Organisation_BankAccount_Description = new SQL_Parameter(TRR_v_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, TRR_v.v); lpar.Add(par_Organisation_BankAccount_Description); TRR_v_cond = " TRR = " + TRR_v_Value; } string BankAccount_Description_v_cond = "Description is null"; string BankAccount_Description_v_Value = "null"; if (BankAccount_Description_v != null) { BankAccount_Description_v_Value = "@par_BankAccount_Description"; SQL_Parameter par_Organisation_BankAccount_BankAccount_Description = new SQL_Parameter(BankAccount_Description_v_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, BankAccount_Description_v.v); lpar.Add(par_Organisation_BankAccount_BankAccount_Description); BankAccount_Description_v_cond = " Description = " + BankAccount_Description_v_Value; } string Active_v_cond = "Active is null"; string Active_v_Value = "null"; if (Active_v != null) { string sbinVal = "0"; if (Active_v.v) { sbinVal = "1"; } Active_v_Value = sbinVal; Active_v_cond = "Active = " + Active_v_Value; } string Bank_ID_v_cond = "Bank_ID is null"; string Bank_ID_v_Value = "null"; if (Bank_ID_v != null) { Bank_ID_v_Value = Bank_ID_v.v.ToString(); Bank_ID_v_cond = "Bank_ID = " + Bank_ID_v.v.ToString(); } string sql_select = "select ID from BankAccount where " + Bank_ID_v_cond + @" and " + TRR_v_cond + @" and " + BankAccount_Description_v_cond + @" and " + Active_v_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (BankAccount_ID_v == null) { BankAccount_ID_v = new long_v(); } BankAccount_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @"insert into BankAccount (TRR,Active,Description,Bank_ID) values ( " + TRR_v_Value + @", " + Active_v_Value + @", " + BankAccount_Description_v_Value + @", " + Bank_ID_v_Value + ")"; object oret = null; long BankAccount_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref BankAccount_ID, ref oret, ref Err, "BankAccount")) { if (BankAccount_ID_v == null) { BankAccount_ID_v = new long_v(); } BankAccount_ID_v.v = BankAccount_ID; return true; } else { LogFile.Error.Show("ERROR:f_BankAccount:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_BankAccount:Get:sql=" + sql_select + "\r\nErr=" + Err); } return false; }
public bool Get(long_v Office_ID_v) { string Err = null; ID_v = null; ID_v = null; Name_v = null; Address_v.StreetName_v = null; Address_v.HouseNumber_v = null; Address_v.ZIP_v = null; Address_v.City_v = null; Address_v.Country_v = null; Address_v.Country_ISO_3166_a2_v = null; Address_v.Country_ISO_3166_a3_v = null; Address_v.Country_ISO_3166_num_v = null; myOrg_Office_FVI_SLO_RealEstate.ID_v = null; myOrg_Office_FVI_SLO_RealEstate.Office_Data_ID_v = null; myOrg_Office_FVI_SLO_RealEstate.BuildingNumber_v = null; myOrg_Office_FVI_SLO_RealEstate.BuildingSectionNumber_v = null; myOrg_Office_FVI_SLO_RealEstate.Community_v = null; myOrg_Office_FVI_SLO_RealEstate.CadastralNumber_v = null; myOrg_Office_FVI_SLO_RealEstate.ValidityDate_v = null; myOrg_Office_FVI_SLO_RealEstate.ClosingTag_v = null; myOrg_Office_FVI_SLO_RealEstate.SoftwareSupplier_TaxNumber_v = null; myOrg_Office_FVI_SLO_RealEstate.PremiseType_v = null; if (Office_ID_v != null) { string sql = @"SELECT ID, Name, ShortName FROM Office where ID = " + Office_ID_v.v.ToString(); DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { ID_v = tf.set_long(dt.Rows[0]["ID"]); Name_v = tf.set_string(dt.Rows[0]["Name"]); ShortName_v = tf.set_string(dt.Rows[0]["ShortName"]); dt.Columns.Clear(); dt.Clear(); sql = @"SELECT Office_Data.ID, Office_Data_$_office.ID AS Office_Data_$_office_$$ID, Office_Data_$_office.Name AS Office_Data_$_office_$$Name, Office_Data_$_office.Name AS Office_Data_$_office_$$ShortName, Office_Data_$_cadrorg.ID AS Office_Data_$_cadrorg_$$ID, Office_Data_$_cadrorg_$_cstrnorg.StreetName AS Office_Data_$_cadrorg_$_cstrnorg_$$StreetName, Office_Data_$_cadrorg_$_chounorg.HouseNumber AS Office_Data_$_cadrorg_$_chounorg_$$HouseNumber, Office_Data_$_cadrorg_$_ccitorg.City AS Office_Data_$_cadrorg_$_ccitorg_$$City, Office_Data_$_cadrorg_$_cziporg.ZIP AS Office_Data_$_cadrorg_$_cziporg_$$ZIP, Office_Data_$_cadrorg_$_cstorg.Country AS Office_Data_$_cadrorg_$_ccouorg_$$Country, Office_Data_$_cadrorg_$_cstorg.Country_ISO_3166_a2 AS Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2, Office_Data_$_cadrorg_$_cstorg.Country_ISO_3166_a3 AS Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3, Office_Data_$_cadrorg_$_cstorg.Country_ISO_3166_num AS Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num, Office_Data_$_cadrorg_$_ccouorg.State AS Office_Data_$_cadrorg_$_cstorg_$$State, Office_Data.Description AS Office_Data_$$Description FROM Office_Data INNER JOIN Office Office_Data_$_office ON Office_Data.Office_ID = Office_Data_$_office.ID LEFT JOIN cAddress_Org Office_Data_$_cadrorg ON Office_Data.cAddress_Org_ID = Office_Data_$_cadrorg.ID LEFT JOIN cStreetName_Org Office_Data_$_cadrorg_$_cstrnorg ON Office_Data_$_cadrorg.cStreetName_Org_ID = Office_Data_$_cadrorg_$_cstrnorg.ID LEFT JOIN cHouseNumber_Org Office_Data_$_cadrorg_$_chounorg ON Office_Data_$_cadrorg.cHouseNumber_Org_ID = Office_Data_$_cadrorg_$_chounorg.ID LEFT JOIN cCity_Org Office_Data_$_cadrorg_$_ccitorg ON Office_Data_$_cadrorg.cCity_Org_ID = Office_Data_$_cadrorg_$_ccitorg.ID LEFT JOIN cZIP_Org Office_Data_$_cadrorg_$_cziporg ON Office_Data_$_cadrorg.cZIP_Org_ID = Office_Data_$_cadrorg_$_cziporg.ID LEFT JOIN cCountry_Org Office_Data_$_cadrorg_$_cstorg ON Office_Data_$_cadrorg.cCountry_Org_ID = Office_Data_$_cadrorg_$_cstorg.ID LEFT JOIN cState_Org Office_Data_$_cadrorg_$_ccouorg ON Office_Data_$_cadrorg.cState_Org_ID = Office_Data_$_cadrorg_$_ccouorg.ID where Office_Data_$_office.ID = " + Office_ID_v.v.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { Office_Data_ID_v = tf.set_long(dt.Rows[0]["ID"]); Description_v = tf.set_string(dt.Rows[0]["Office_Data_$$Description"]); Address_v.StreetName_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_office_$$Name"]); Address_v.HouseNumber_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_chounorg_$$HouseNumber"]); Address_v.ZIP_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_cziporg_$$ZIP"]); Address_v.City_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_ccitorg_$$City"]); Address_v.Country_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_ccouorg_$$Country"]); Address_v.Country_ISO_3166_a2_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2"]); Address_v.Country_ISO_3166_a3_v = tf.set_dstring(dt.Rows[0]["Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3"]); Address_v.Country_ISO_3166_num_v = tf.set_dshort(fs.MyConvertToShort(dt.Rows[0]["Office_Data_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num"])); myOrg_Office_FVI_SLO_RealEstate.Get(Office_Data_ID_v); } return true; } else { LogFile.Error.Show("ERROR:myOrg_Office:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:myOrg_Office:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:myOrg_Office:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { return false; } }
internal static bool Get(string_v houseNumber_v, ref long_v atom_cHouseNumber_Person_ID_v) { if (houseNumber_v != null) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string spar = "@par"; SQL_Parameter par = new SQL_Parameter(spar, SQL_Parameter.eSQL_Parameter.Nvarchar, false, houseNumber_v.v); lpar.Add(par); string sql = @"select ID from Atom_cHouseNumber_Person where HouseNumber = @par"; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (atom_cHouseNumber_Person_ID_v == null) { atom_cHouseNumber_Person_ID_v = new long_v(); } atom_cHouseNumber_Person_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = @"insert into Atom_cHouseNumber_Person (HouseNumber) values (@par)"; long Atom_cHouseNumber_Person_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Atom_cHouseNumber_Person_ID, ref oret, ref Err, "Atom_cHouseNumber_Person")) { if (atom_cHouseNumber_Person_ID_v == null) { atom_cHouseNumber_Person_ID_v = new long_v(); } atom_cHouseNumber_Person_ID_v.v = Atom_cHouseNumber_Person_ID; return true; } else { LogFile.Error.Show("ERROR:TangentaDB:f_Atom_cHouseNumber_Person:Get(string_v houseNumber_v, ref long_v atom_cHouseNumber_Person_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:TangentaDB:f_Atom_cHouseNumber_Person:Get(string_v houseNumber_v, ref long_v atom_cHouseNumber_Person_ID_v) sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:TangentaDB:f_Atom_cHouseNumber_Person:Get(string_v houseNumber_v, ref long_v atom_cHouseNumber_Person_ID_v) houseNumber_v may not be null!"); return false; } }
private static bool Find_Name_Abbreviation_ShopBItem_Image(long SimpleItem_ID, ref string Name,ref string Abbreviation, ref long_v SimpleItem_Image_id) { string Err = null; DataTable dt = new DataTable(); string sql = "select Name,Abbreviation,SimpleItem_Image_ID from SimpleItem where ID = " + SimpleItem_ID.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { object oAtom_SimpleItem_ID = dt.Rows[0]["SimpleItem_Image_ID"]; if (oAtom_SimpleItem_ID.GetType() == typeof(long)) { SimpleItem_Image_id = new long_v(); SimpleItem_Image_id.v = (long)oAtom_SimpleItem_ID; } Name = (string)dt.Rows[0]["Name"]; Abbreviation = (string)dt.Rows[0]["Abbreviation"]; return true; } else { LogFile.Error.Show("ERROR:f_Atom_SimpleItem:Find_SimpleItem_Image:No SimpleItem_Image Data for SimpleItem.ID = " + SimpleItem_ID.ToString()); return false; } } else { LogFile.Error.Show("ERROR:f_Atom_SimpleItem:Find_SimpleItem_Image:Err = " + Err); return false; } }
public static bool Get(Expiry_v expiry_v,ref long_v Expiry_ID_v) { if (expiry_v != null) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Err = null; DataTable dt = new DataTable(); string scond_ExpiryDescription = " ExpiryDescription is null "; string sval_ExpiryDescription = " null "; if (expiry_v.ExpiryDescription != null) { string spar_ExpiryDescription = "@par_ExpiryDescription"; SQL_Parameter par_ExpiryDescription = new SQL_Parameter(spar_ExpiryDescription, SQL_Parameter.eSQL_Parameter.Nvarchar,false, expiry_v.ExpiryDescription); lpar.Add(par_ExpiryDescription); scond_ExpiryDescription = " ExpiryDescription = "+ spar_ExpiryDescription; sval_ExpiryDescription = " " + spar_ExpiryDescription + " "; } string sql = " select ID from Expiry where ExpectedShelfLifeInDays = " + expiry_v.ExpectedShelfLifeInDays.ToString() + " and SaleBeforeExpiryDateInDays = " + expiry_v.SaleBeforeExpiryDateInDays.ToString() + " and DiscardBeforeExpiryDateInDays = " + expiry_v.DiscardBeforeExpiryDateInDays.ToString() + " and " + scond_ExpiryDescription; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (Expiry_ID_v == null) { Expiry_ID_v = new long_v(); } Expiry_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = @" insert into Expiry (ExpectedShelfLifeInDays, SaleBeforeExpiryDateInDays, DiscardBeforeExpiryDateInDays, ExpiryDescription) values (" + expiry_v.ExpectedShelfLifeInDays.ToString() + "," + expiry_v.SaleBeforeExpiryDateInDays.ToString() + "," + expiry_v.DiscardBeforeExpiryDateInDays.ToString() + "," + sval_ExpiryDescription + ")"; long Expiry_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Expiry_ID, ref oret, ref Err, "Expiry")) { if (Expiry_ID_v == null) { Expiry_ID_v = new long_v(); } Expiry_ID_v.v = Expiry_ID; return true; } else { LogFile.Error.Show("ERROR:f_Expiry:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Expiry:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { Expiry_ID_v = null; return true; } }
public static bool Get(long Organisation_ID, string_v OrganisationTYPE_v, PostAddress_v Address_v, string_v PhoneNumber_v, string_v FaxNumber_v, string_v Email_v, string_v HomePage_v, string_v Logo_Hash_v, byte_array_v Image_Data_v, string_v Logo_Description_v, ref ID_v cAdressAtom_Org_iD_v, ref long_v OrganisationData_ID_v) { string Err = null; // long_v Atom_Organisation_ID_v = null; long_v OrganisationTYPE_ID_v = null; if (f_cOrgTYPE.Get(OrganisationTYPE_v, ref OrganisationTYPE_ID_v)) { if (f_cAddress_Org.Get(Address_v, ref cAdressAtom_Org_iD_v)) { ID_v cHomePage_Org_ID_v = null; string cHomePage_Org_ID_v_cond = "cHomePage_Org_ID is null"; string cHomePage_Org_ID_v_Value = "null"; if (fs.Get_ID("cHomePage_Org", "HomePage", HomePage_v, ref cHomePage_Org_ID_v, ref Err)) { if (cHomePage_Org_ID_v != null) { cHomePage_Org_ID_v_Value = cHomePage_Org_ID_v.v.ToString(); cHomePage_Org_ID_v_cond = "cHomePage_Org_ID = " + cHomePage_Org_ID_v_Value; } } ID_v cEmail_Org_ID_v = null; string cEmail_Org_ID_v_cond = "cEmail_Org_ID is null"; string cEmail_Org_ID_v_Value = "null"; if (fs.Get_ID("cEmail_Org", "Email", Email_v, ref cEmail_Org_ID_v, ref Err)) { if (cEmail_Org_ID_v != null) { cEmail_Org_ID_v_Value = cEmail_Org_ID_v.v.ToString(); cEmail_Org_ID_v_cond = "cEmail_Org_ID = " + cEmail_Org_ID_v_Value; } } ID_v cPhoneNumber_Org_ID_v = null; string cPhoneNumber_Org_ID_v_cond = "cPhoneNumber_Org_ID is null"; string cPhoneNumber_Org_ID_v_Value = "null"; if (fs.Get_ID("cPhoneNumber_Org", "PhoneNumber", PhoneNumber_v, ref cPhoneNumber_Org_ID_v, ref Err)) { if (cPhoneNumber_Org_ID_v != null) { cPhoneNumber_Org_ID_v_Value = cPhoneNumber_Org_ID_v.v.ToString(); cPhoneNumber_Org_ID_v_cond = "cPhoneNumber_Org_ID = " + cPhoneNumber_Org_ID_v_Value; } } ID_v cFaxNumber_Org_ID_v = null; string cFaxNumber_Org_ID_v_cond = "cFaxNumber_Org_ID is null"; string cFaxNumber_Org_ID_v_Value = "null"; if (fs.Get_ID("cFaxNumber_Org", "FaxNumber", FaxNumber_v, ref cFaxNumber_Org_ID_v, ref Err)) { if (cFaxNumber_Org_ID_v != null) { cFaxNumber_Org_ID_v_Value = cFaxNumber_Org_ID_v.v.ToString(); cFaxNumber_Org_ID_v_cond = "cFaxNumber_Org_ID = " + cFaxNumber_Org_ID_v_Value; } } long_v Logo_ID_v = null; string Logo_ID_cond = "Logo_ID is null"; string Logo_ID_Value = "null"; // = null; //if (Logo != null) //{ // Image_Data_v = new byte_array_v(); // Image_Data_v.v = DBtypesFunc.imageToByteArray(Logo, Logo.RawFormat); //} if (f_Logo.Get(Logo_Hash_v, Image_Data_v, Logo_Description_v, ref Logo_ID_v)) { if (Logo_ID_v != null) { Logo_ID_Value = Logo_ID_v.v.ToString(); Logo_ID_cond = "Logo_ID = " + Logo_ID_Value; } } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); //if (BankName_v != null) //{ // BankName_Value = "@par_BankName"; // SQL_Parameter par_BankName = new SQL_Parameter(BankName_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, BankName_v.v); // lpar.Add(par_BankName); // BankName_condition = " BankName = " + par_BankName.Name + " "; //} //else //{ // BankName_condition = " BankName is null "; // BankName_Value = "null"; //} //if (TRR_v != null) //{ // TRR_Value = "@par_TRR"; // SQL_Parameter par_TRR = new SQL_Parameter(TRR_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, TRR_v.v); // lpar.Add(par_TRR); // TRR_condition = " TRR = " + par_TRR.Name + " "; //} //else //{ // TRR_condition = " TRR is null "; // TRR_Value = "null"; //} string cOrgTYPE_ID_condition = null; string cOrgTYPE_ID_value = null; if (OrganisationTYPE_ID_v != null) { cOrgTYPE_ID_condition = " cOrgTYPE_ID = " + cAdressAtom_Org_iD_v.v.ToString(); cOrgTYPE_ID_value = cAdressAtom_Org_iD_v.v.ToString(); } else { cOrgTYPE_ID_condition = " cOrgTYPE_ID is null "; cOrgTYPE_ID_value = "null"; } string cAddress_Org_ID_condition = null; if (cAdressAtom_Org_iD_v != null) { cAddress_Org_ID_condition = " cAddress_Org_ID = " + cAdressAtom_Org_iD_v.v.ToString(); } else { cAddress_Org_ID_condition = " cAddress_Org_ID is null "; } string sql_select = "select ID from OrganisationData where Organisation_ID =" + Organisation_ID.ToString() + @" and " + cOrgTYPE_ID_condition + @" and " + cAddress_Org_ID_condition + @" and " + cHomePage_Org_ID_v_cond + @" and " + cEmail_Org_ID_v_cond + @" and " + cPhoneNumber_Org_ID_v_cond + @" and " + cFaxNumber_Org_ID_v_cond + @" and " + Logo_ID_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (OrganisationData_ID_v == null) { OrganisationData_ID_v = new long_v(); } OrganisationData_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { string sql_insert = @"insert into OrganisationData (Organisation_ID,cOrgTYPE_ID,cAddress_Org_ID,cHomePage_Org_ID,cEmail_Org_ID,cPhoneNumber_Org_ID,cFaxNumber_Org_ID,Logo_ID) values ( " + Organisation_ID.ToString() + @", " + cOrgTYPE_ID_value + @", " + cAdressAtom_Org_iD_v.v.ToString() + @", " + cHomePage_Org_ID_v_Value + @", " + cEmail_Org_ID_v_Value + @", " + cPhoneNumber_Org_ID_v_Value + @", " + cFaxNumber_Org_ID_v_Value + @", " + Logo_ID_Value + ")"; object oret = null; long OrganisationData_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref OrganisationData_ID, ref oret, ref Err, "OrganisationData")) { if (OrganisationData_ID_v == null) { OrganisationData_ID_v = new long_v(); } OrganisationData_ID_v.v = OrganisationData_ID; return true; } else { LogFile.Error.Show("ERROR:f_OrganisationData:Get:sql=" + sql_insert + "\r\nErr=" + Err); } } } else { LogFile.Error.Show("ERROR:f_OrganisationData:Get:sql=" + sql_select + "\r\nErr=" + Err); } } } return false; }
public static bool Get(string_v StreetName_v, string_v HouseNumber_v, string_v ZIP_v, string_v City_v, string_v Country_v, string_v Country_ISO_3166_a2_v, string_v Country_ISO_3166_a3_v, short_v Country_ISO_3166_num_v, string_v State_v, ref long_v cAddress_Person_ID_v) { if ((StreetName_v == null) || (HouseNumber_v == null) || (ZIP_v == null) || (City_v == null) || (Country_v == null)) { cAddress_Person_ID_v = null; return true; } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); long_v cStreetName_Person_ID_v = null; if (!f_cStreetName_Person.Get(StreetName_v, ref cStreetName_Person_ID_v)) { return false; } string cStreetName_Person_ID_cond = null; string cStreetName_Person_ID_value = null; if (!fs.AddPar("cStreetName_Person_ID", ref lpar, cStreetName_Person_ID_v, ref cStreetName_Person_ID_cond, ref cStreetName_Person_ID_value)) { return false; } long_v cHouseNumber_Person_ID_v = null; if (!f_cHouseNumber_Person.Get(HouseNumber_v, ref cHouseNumber_Person_ID_v)) { return false; } string cHouseNumber_Person_ID_cond = null; string cHouseNumber_Person_ID_value = null; if (!fs.AddPar("cHouseNumber_Person_ID", ref lpar, cHouseNumber_Person_ID_v, ref cHouseNumber_Person_ID_cond, ref cHouseNumber_Person_ID_value)) { return false; } long_v cZIP_Person_ID_v = null; if (!f_cZIP_Person.Get(ZIP_v, ref cZIP_Person_ID_v)) { return false; } string cZIP_Person_ID_cond = null; string cZIP_Person_ID_value = null; if (!fs.AddPar("cZIP_Person_ID", ref lpar, cZIP_Person_ID_v, ref cZIP_Person_ID_cond, ref cZIP_Person_ID_value)) { return false; } long_v cCity_Person_ID_v = null; if (!f_cCity_Person.Get(City_v, ref cCity_Person_ID_v)) { return false; } string cCity_Person_ID_cond = null; string cCity_Person_ID_value = null; if (!fs.AddPar("cCity_Person_ID", ref lpar, cCity_Person_ID_v, ref cCity_Person_ID_cond, ref cCity_Person_ID_value)) { return false; } long_v cCountry_Person_ID_v = null; if (!f_cCountry_Person.Get(Country_v, Country_ISO_3166_a2_v, Country_ISO_3166_a3_v, Country_ISO_3166_num_v, ref cCountry_Person_ID_v)) { return false; } string cCountry_Person_ID_cond = null; string cCountry_Person_ID_value = null; if (!fs.AddPar("cCountry_Person_ID", ref lpar, cCountry_Person_ID_v, ref cCountry_Person_ID_cond, ref cCountry_Person_ID_value)) { return false; } long_v cState_Person_ID_v = null; if (!f_cState_Person.Get(State_v, ref cState_Person_ID_v)) { return false; } string cState_Person_ID_cond = null; string cState_Person_ID_value = null; if (!fs.AddPar("cState_Person_ID", ref lpar, cState_Person_ID_v, ref cState_Person_ID_cond, ref cState_Person_ID_value)) { return false; } string sql = "select ID from cAddress_Person where " + cStreetName_Person_ID_cond + " and " + cHouseNumber_Person_ID_cond + " and " + cZIP_Person_ID_cond + " and " + cCity_Person_ID_cond + " and " + cCountry_Person_ID_cond + " and " + cState_Person_ID_cond + " order by ID desc"; DataTable dt = new DataTable(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (cAddress_Person_ID_v == null) { cAddress_Person_ID_v = new long_v(); } cAddress_Person_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = " insert into cAddress_Person (cStreetName_Person_ID,cHouseNumber_Person_ID,cZIP_Person_ID,cCity_Person_ID,cCountry_Person_ID,cState_Person_ID)values(" + cStreetName_Person_ID_value + "," + cHouseNumber_Person_ID_value + "," + cZIP_Person_ID_value + "," + cCity_Person_ID_value + "," + cCountry_Person_ID_value + "," + cState_Person_ID_value + ")"; long id = -1; object ores = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref id, ref ores, ref Err, "cAddress_Person")) { if (cAddress_Person_ID_v == null) { cAddress_Person_ID_v = new long_v(); } cAddress_Person_ID_v.v = id; return true; } else { LogFile.Error.Show("ERROR:f_Customer_Person:Get_cAddress_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Customer_Person:Get_cAddress_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } }
public static bool Get(string_v Logo_Hash_v, byte_array_v Logo_v, string_v Logo_Description_v, ref long_v Atom_Logo_ID_v) { string Err = null; if (Logo_Hash_v == null) { Atom_Logo_ID_v = null; return true; } if (Atom_Logo_ID_v == null) { Atom_Logo_ID_v = new long_v(); } List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string Image_Hash_Value = "null"; string Image_Hash_cond = "Image_Hash is null"; if (Logo_Hash_v != null) { if (Logo_Hash_v.v != null) { Image_Hash_Value = "@par_Image_Hash"; Image_Hash_cond = "Image_Hash = " + Image_Hash_Value; SQL_Parameter par_Image_Hash = new SQL_Parameter(Image_Hash_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Logo_Hash_v.v); lpar.Add(par_Image_Hash); } } string Image_Data_Value = "null"; if (Logo_v != null) { if (Logo_v.v != null) { Image_Data_Value = "@par_Image_Data"; SQL_Parameter par_Image_Data = new SQL_Parameter(Image_Data_Value, SQL_Parameter.eSQL_Parameter.Varbinary, false, Logo_v.v); lpar.Add(par_Image_Data); } } string Description_Value = "null"; string Description_cond = "Description is null"; if (Logo_Description_v != null) { if (Logo_Description_v.v != null) { Description_Value = "@par_Description"; Description_cond = "Description = " + Description_Value; SQL_Parameter par_Description = new SQL_Parameter(Description_Value, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Logo_Description_v.v); lpar.Add(par_Description); } } string sql = " select ID, Image_Hash,Image_Data,Description from Atom_Logo where " + Image_Hash_cond + " and " + Description_cond; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { Atom_Logo_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = " insert into Atom_Logo (Image_Hash,Image_Data,Description) values (" + Image_Hash_Value + "," + Image_Data_Value + "," + Description_Value + ")"; object oRet = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Atom_Logo_ID_v.v_, ref oRet, ref Err, "Atom_Logo")) { return true; } else { LogFile.Error.Show("ERROR:f_Atom_Logo:sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Logo:sql=" + sql + "\r\nErr=" + Err); return false; } }
public static bool Get(string Name, string_v Description_v, byte[] xDocument, long_v doc_type_ID_v,bool commpressed,bool Active,bool Default, ref long doc_ID) { string Err = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); //Table doc_page_type if (xDocument != null) { string xDocument_HASH = DBtypesFunc.GetHash_SHA1(xDocument); string spar_Name = "@par_Name"; SQL_Parameter par_Name = new SQL_Parameter(spar_Name, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Name); lpar.Add(par_Name); string sval_Description = "null"; if (Description_v != null) { string spar_Description = "@par_Description"; SQL_Parameter par_Description = new SQL_Parameter(spar_Description, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Description_v.v); lpar.Add(par_Description); sval_Description = spar_Description; } string sval_doc_type_ID = "null"; if (doc_type_ID_v != null) { string spar_doc_type_ID = "@par_doc_type_ID"; SQL_Parameter par_doc_type_ID = new SQL_Parameter(spar_doc_type_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, doc_type_ID_v.v); lpar.Add(par_doc_type_ID); sval_doc_type_ID = spar_doc_type_ID; } xDocument_HASH = DBtypesFunc.GetHash_SHA1(xDocument); string spar_xDocument_HASH = "@par_xDocument_HASH"; SQL_Parameter par_xDocument_HASH = new SQL_Parameter(spar_xDocument_HASH, SQL_Parameter.eSQL_Parameter.Nvarchar, false, xDocument_HASH); lpar.Add(par_xDocument_HASH); string sql = "select ID from doc where Name = " + spar_Name + " and Description = " + sval_Description + " and doc_type_ID = " + sval_doc_type_ID + " and xDocument_HASH = " + spar_xDocument_HASH; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { doc_ID = (long)dt.Rows[0]["ID"]; return true; } else { byte[] byte_data = xDocument; string sCompressed = "0"; if (commpressed) { sCompressed = "1"; byte_data = fs.Compress(xDocument); } string spar_xDocument = "@par_xDocument"; SQL_Parameter par_xDocument = new SQL_Parameter(spar_xDocument, SQL_Parameter.eSQL_Parameter.Varbinary, false, byte_data); lpar.Add(par_xDocument); string spar_bDefault = "@par_bDefault"; SQL_Parameter par_bDefault = new SQL_Parameter(spar_bDefault, SQL_Parameter.eSQL_Parameter.Bit, false, Default); lpar.Add(par_bDefault); sql = @"insert into doc (Name, Description, xDocument, xDocument_Hash, doc_type_ID, Compressed, Active, bDefault) values(" + spar_Name + "," + sval_Description + "," + spar_xDocument + "," + spar_xDocument_HASH + "," + sval_doc_type_ID + "," + sCompressed +@", 1,"+ spar_bDefault + ")"; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref doc_ID, ref oret, ref Err, "doc")) { return true; } else { LogFile.Error.Show("ERROR:f_doc:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_doc:Get:sql=" + sql + "\r\nErr=" + Err); return false; } } else { LogFile.Error.Show("ERROR:f_doc:Get:Error xDocument may not be null!"); return false; } }
public static bool InsertDefault() { string[] doc_page_type_A4_Name = new string[] { "A4", "A4" }; string[] doc_page_type_A4_Description = new string[] { "A4", "A4" }; string[] doc_page_type_Roll_80_Name = new string[] { "Roll 80mm", "Rola 80mm" }; string[] doc_page_type_Roll_80_Description = new string[] { "Roll 80mm", "Rola 80mm" }; string[] doc_page_type_Roll_58_Name = new string[] { "Roll 58mm", "Rola 58mm" }; string[] doc_page_type_Roll_58_Description = new string[] { "Roll 58mm", "Rola 58mm" }; string[] doc_type_Html_Invoice_Template_A4_Name = new string[] { "HTML Template Invoice A4", "HTML predloga računi A4" }; string[] doc_type_Html_Invoice_Template_A4_Description = new string[] { "HTML Template Invoice A4", "HTML predloga računi A4" }; string[] doc_type_Html_Proforma_Invoice_Template_A4_Name = new string[] { "HTML Template Proforma Invoice A4", "HTML predloga predračuni" }; string[] doc_type_Html_Proforma_Invoice_Template_A4_Description = new string[] { "HTML Template Proforma Invoice", "HTML predloga predračuni" }; string[] doc_Html_Invoice_Template_A4_Name = new string[] { "English HTML Template Invoice A4", "Slovenska HTML predloga računi A4" }; string[] doc_Html_Invoice_Template_A4_Description = new string[] { "English HTML Template Invoice", "Slovenska HTML predloga računi A4" }; string[] doc_Html_Proforma_Invoice_Template_A4_Name = new string[] { "English HTML Template Proforma Invoice A4", "Slovenska HTML predloga pred računi A4"}; string[] doc_Html_Proforma_Invoice_Template_A4_Description = new string[] { "English HTML Template Proforma Invoice A4", "Slovenska HTML predloga pred računi A4"}; string[] doc_type_Html_Invoice_Template_Roll58_Name = new string[] { "HTML Template Invoice Roll58", "HTML predloga računi Roll58" }; string[] doc_type_Html_Invoice_Template_Roll58_Description = new string[] { "HTML Template Invoice Roll58", "HTML predloga računi Roll58" }; string[] doc_type_Html_Proforma_Invoice_Template_Roll58_Name = new string[] { "HTML Template Proforma Invoice Roll58", "HTML predloga predračuni" }; string[] doc_type_Html_Proforma_Invoice_Template_Roll58_Description = new string[] { "HTML Template Proforma Invoice", "HTML predloga predračuni" }; string[] doc_Html_Invoice_Template_Roll58_Name = new string[] { "English HTML Template Invoice Roll58", "Slovenska HTML predloga računi Roll58" }; string[] doc_Html_Invoice_Template_Roll58_Description = new string[] { "English HTML Template Invoice", "Slovenska HTML predloga računi Roll58" }; string[] doc_Html_Proforma_Invoice_Template_Roll58_Name = new string[] { "English HTML Template Proforma Invoice Roll58", "Slovenska HTML predloga pred računi Roll58" }; string[] doc_Html_Proforma_Invoice_Template_Roll58_Description = new string[] { "English HTML Template Proforma Invoice Roll58", "Slovenska HTML predloga pred računi Roll58" }; string[] doc_type_Html_Invoice_Template_Roll80_Name = new string[] { "HTML Template Invoice Roll80", "HTML predloga računi Roll80" }; string[] doc_type_Html_Invoice_Template_Roll80_Description = new string[] { "HTML Template Invoice Roll80", "HTML predloga računi Roll80" }; string[] doc_type_Html_Proforma_Invoice_Template_Roll80_Name = new string[] { "HTML Template Proforma Invoice Roll80", "HTML predloga predračuni" }; string[] doc_type_Html_Proforma_Invoice_Template_Roll80_Description = new string[] { "HTML Template Proforma Invoice", "HTML predloga predračuni" }; string[] doc_Html_Invoice_Template_Roll80_Name = new string[] { "English HTML Template Invoice Roll80", "Slovenska HTML predloga računi Roll80" }; string[] doc_Html_Invoice_Template_Roll80_Description = new string[] { "English HTML Template Invoice", "Slovenska HTML predloga računi Roll80" }; string[] doc_Html_Proforma_Invoice_Template_Roll80_Name = new string[] { "English HTML Template Proforma Invoice Roll80", "Slovenska HTML predloga pred računi Roll80" }; string[] doc_Html_Proforma_Invoice_Template_Roll80_Description = new string[] { "English HTML Template Proforma Invoice Roll80", "Slovenska HTML predloga pred računi Roll80" }; long[] doc_type_A4_ID = new long[2]; long[] doc_ID_inv = new long[2]; long[] doc_ID_pinv = new long[2]; long[] languageID = new long[2]; long[] doc_page_type_A4_ID = new long[2]; int i =0; for (i = 0; i < LanguageControl.DynSettings.s_language.sTextArr.Length; i++) { if (LanguageControl.DynSettings.s_language.sTextArr[i] != null) { string_v Description_v = new string_v(LanguageControl.DynSettings.s_language.sTextArr[i]); if (f_Language.Get(LanguageControl.DynSettings.s_language.sTextArr[i], Description_v, ref languageID[i])) { long_v Language_ID_v = new long_v(languageID[i]); byte[] xDoc = null; if (i == 0) { byte[] bytes = Encoding.Default.GetBytes(Properties.Resources.htmlt_ENG_inv1_A4); string myString = Encoding.UTF8.GetString(bytes); xDoc = fs.GetBytes(myString); } else { byte[] bytes = Encoding.Default.GetBytes(Properties.Resources.htmlt_SLO_inv1_A4); string myString = Encoding.UTF8.GetString(bytes); xDoc = fs.GetBytes(myString); } long doc_page_type_ID = 0; long doc_type_ID = 0; long doc_ID = 0; if (!Get(Language_ID_v, doc_page_type_A4_Name[i], doc_page_type_A4_Description[i], 210, 297, ref doc_page_type_ID, doc_type_Html_Invoice_Template_A4_Name[i], doc_type_Html_Invoice_Template_A4_Description[i], ref doc_type_ID, doc_Html_Invoice_Template_A4_Name[i], doc_Html_Invoice_Template_A4_Description[i], xDoc, true, true, true, ref doc_ID ) ) { return false; } } else { return false; } } } return true; }