//string_v StreetName_v = tf.set_string(Address.StreetName); //string_v HouseNumber_v = tf.set_string(Address.HouseNumber); //string_v ZIP_v = tf.set_string(Address.ZIP); //string_v City_v = tf.set_string(Address.City); //string_v Country_v = tf.set_string(Address.Country); //string_v State_v = tf.set_string(Address.State); //string_v PhoneNumber_v = tf.set_string(PhoneNumber); //string_v FaxNumber_v = tf.set_string(FaxNumber); //string_v Email_v = tf.set_string(Email); //string_v HomePage_v = tf.set_string(HomePage); //string_v Logo_Hash_v = tf.set_string(Logo_Hash); //byte_array_v Logo_Image_Data_v = tf.set_byte_array(Logo); //string_v Logo_Description_v = tf.set_string(Logo_Description); public static bool Get( string_v Organisation_Name_v, string_v Tax_ID_v, string_v Registration_ID_v, 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 BankName_v, string_v TRR_v, string_v Logo_Hash_v, byte_array_v Logo_Image_Data_v, string_v Logo_Description_v, ref ID_v iD_v) { string Err = null; long_v Atom_Organisation_ID_v = null; long_v Atom_OrganisationData_ID_v = null; if (f_Atom_Organisation.Get( Organisation_Name_v, Tax_ID_v, Registration_ID_v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, BankName_v, TRR_v, Logo_Hash_v, Logo_Image_Data_v, Logo_Description_v, ref Atom_Organisation_ID_v, ref Atom_OrganisationData_ID_v )) { DataTable dt = new DataTable(); string sql_select = "select ID from Atom_myOrganisation where Atom_OrganisationData_ID = " + Atom_OrganisationData_ID_v.v.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, null, ref Err)) { if (dt.Rows.Count > 0) { if (iD_v == null) { iD_v = new ID_v(); } iD_v.v = (long)dt.Rows[0]["ID"]; return true; } else { long Atom_myOrganisation_id = -1; string sql_insert = " insert into Atom_myOrganisation (Atom_OrganisationData_ID) values (" + Atom_OrganisationData_ID_v.v.ToString() + ")"; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, null, ref Atom_myOrganisation_id, ref oret, ref Err, "Atom_myOrganisation")) { if (iD_v == null) { iD_v = new ID_v(); } iD_v.v = Atom_myOrganisation_id; return true; } else { LogFile.Error.Show("ERROR:Insert_Atom_myOrganisation:sql_insert:Err=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:myOrg:Insert_Atom_myOrganisation:sql_select=" + sql_select + "\r\nErr=" + Err); return false; } } else { return false; } }
internal static bool Get(PostAddress_v address_v, ref ID_v cAdressOrg_iD_v) { string Err = null; long_v cStreetName_Person_ID_v = null; long_v cHouseNumber_Person_ID_v = null; long_v cCity_Person_ID_v = null; long_v cZIP_Person_ID_v = null; long_v cCountry_Person_ID_v = null; long_v cState_Person_ID_v = null; if (f_cStreetName_Person.Get(address_v.StreetName_v, ref cStreetName_Person_ID_v)) { if (f_cHouseNumber_Person.Get(address_v.HouseNumber_v, ref cHouseNumber_Person_ID_v)) { if (f_cCity_Person.Get(address_v.City_v, ref cCity_Person_ID_v)) { if (f_cZIP_Person.Get(address_v.ZIP_v, ref cZIP_Person_ID_v)) { if (f_cCountry_Person.Get(address_v.Country_v, address_v.Country_ISO_3166_a2_v, address_v.Country_ISO_3166_a3_v, address_v.Country_ISO_3166_num_v, ref cCountry_Person_ID_v)) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string scond_cStreetName_Person_ID_v = " cStreetName_Person_ID is null "; string sval_cStreetName_Person_ID_v = "null"; if (cStreetName_Person_ID_v != null) { string spar_cStreetName_Person_ID_v = "@par_cStreetName_Person_ID_v"; SQL_Parameter par_cStreetName_Person_ID_v = new SQL_Parameter(spar_cStreetName_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cStreetName_Person_ID_v.v); lpar.Add(par_cStreetName_Person_ID_v); scond_cStreetName_Person_ID_v = " cStreetName_Person_ID = " + spar_cStreetName_Person_ID_v; sval_cStreetName_Person_ID_v = spar_cStreetName_Person_ID_v; } string scond_cHouseNumber_Person_ID_v = " cHouseNumber_Person_ID is null "; string sval_cHouseNumber_Person_ID_v = "null"; if (cHouseNumber_Person_ID_v != null) { string spar_cHouseNumber_Person_ID_v = "@par_cHouseNumber_Person_ID_v"; SQL_Parameter par_cHouseNumber_Person_ID_v = new SQL_Parameter(spar_cHouseNumber_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cHouseNumber_Person_ID_v.v); lpar.Add(par_cHouseNumber_Person_ID_v); scond_cHouseNumber_Person_ID_v = " cHouseNumber_Person_ID = " + spar_cHouseNumber_Person_ID_v; sval_cHouseNumber_Person_ID_v = spar_cHouseNumber_Person_ID_v; } string scond_cCity_Person_ID_v = " cCity_Person_ID is null "; string sval_cCity_Person_ID_v = "null"; if (cCity_Person_ID_v != null) { string spar_cCity_Person_ID_v = "@par_cCity_Person_ID_v"; SQL_Parameter par_cCity_Person_ID_v = new SQL_Parameter(spar_cCity_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cCity_Person_ID_v.v); lpar.Add(par_cCity_Person_ID_v); scond_cCity_Person_ID_v = " cCity_Person_ID = " + spar_cCity_Person_ID_v; sval_cCity_Person_ID_v = spar_cCity_Person_ID_v; } string scond_cZIP_Person_ID_v = " cZIP_Person_ID is null "; string sval_cZIP_Person_ID_v = "null"; if (cZIP_Person_ID_v != null) { string spar_cZIP_Person_ID_v = "@par_cZIP_Person_ID_v"; SQL_Parameter par_cZIP_Person_ID_v = new SQL_Parameter(spar_cZIP_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cZIP_Person_ID_v.v); lpar.Add(par_cZIP_Person_ID_v); scond_cZIP_Person_ID_v = " cZIP_Person_ID = " + spar_cZIP_Person_ID_v; sval_cZIP_Person_ID_v = spar_cZIP_Person_ID_v; } string scond_cCountry_Person_ID_v = " cCountry_Person_ID is null "; string sval_cCountry_Person_ID_v = "null"; if (cCountry_Person_ID_v != null) { string spar_cCountry_Person_ID_v = "@par_cCountry_Person_ID_v"; SQL_Parameter par_cCountry_Person_ID_v = new SQL_Parameter(spar_cCountry_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cCountry_Person_ID_v.v); lpar.Add(par_cCountry_Person_ID_v); scond_cCountry_Person_ID_v = " cCountry_Person_ID = " + spar_cCountry_Person_ID_v; sval_cCountry_Person_ID_v = spar_cCountry_Person_ID_v; } string scond_cState_Person_ID_v = " cState_Person_ID is null "; string sval_cState_Person_ID_v = "null"; if (cState_Person_ID_v != null) { string spar_cState_Person_ID_v = "@par_cState_Person_ID_v"; SQL_Parameter par_cState_Person_ID_v = new SQL_Parameter(spar_cState_Person_ID_v, SQL_Parameter.eSQL_Parameter.Bigint, false, cState_Person_ID_v.v); lpar.Add(par_cState_Person_ID_v); scond_cState_Person_ID_v = " cState_Person_ID = " + spar_cState_Person_ID_v; sval_cState_Person_ID_v = spar_cState_Person_ID_v; } string sql = "select ID from cAddress_Person where " + scond_cStreetName_Person_ID_v + " and " + scond_cHouseNumber_Person_ID_v + " and " + scond_cCity_Person_ID_v + " and " + scond_cZIP_Person_ID_v + " and " + scond_cCountry_Person_ID_v + " and " + scond_cState_Person_ID_v; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (cAdressOrg_iD_v == null) { cAdressOrg_iD_v = new ID_v(); } cAdressOrg_iD_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = "insert into cAddress_Person (cStreetName_Person_ID,cHouseNumber_Person_ID,cCity_Person_ID,cZIP_Person_ID,cCountry_Person_ID,cState_Person_ID) values (" + sval_cStreetName_Person_ID_v + "," + sval_cHouseNumber_Person_ID_v + "," + sval_cCity_Person_ID_v + "," + sval_cZIP_Person_ID_v + "," + sval_cCountry_Person_ID_v + "," + sval_cState_Person_ID_v + ")"; long cAddress_Person_ID = -1; object oret = null; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref cAddress_Person_ID, ref oret, ref Err, "cAddress_Person")) { if (cAdressOrg_iD_v == null) { cAdressOrg_iD_v = new ID_v(); } cAdressOrg_iD_v.v = cAddress_Person_ID; return true; } else { LogFile.Error.Show("ERROR:ShopA_dbfunc:dbfunc:get(ItemShopA m_ItemShopA, ref long atom_ItemShopA_ID) sql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:ShopA_dbfunc:dbfunc:get(ItemShopA m_ItemShopA, ref long atom_ItemShopA_ID) sql=" + sql + "\r\nErr=" + Err); return false; } } } } } } return false; }
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 Organisation_Name_v, string_v Tax_ID_v, string_v Registration_ID_v, 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 BankName_v, string_v TRR_v, string_v Image_Hash_v, byte_array_v Image_Data_v, string_v Image_Description_v, ref long_v Atom_Organisation_ID_v, ref long_v Atom_OrganisationData_ID_v) { string Err = null; string Name_condition = null; string Tax_ID_condition = null; string Registration_ID_condition = null; string sName_value = null; string sTaxID_value = null; string sRegistration_ID_value = null; List<SQL_Parameter> lpar = new List<SQL_Parameter>(); if (Organisation_Name_v != null) { SQL_Parameter par_Name = new SQL_Parameter("@par_Name", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Organisation_Name_v.v); lpar.Add(par_Name); Name_condition = " Name = " + par_Name.Name + " "; sName_value = "@par_Name"; } else { Name_condition = " Name is null "; sName_value = "null"; } if (Tax_ID_v != null) { SQL_Parameter par_Tax_ID = new SQL_Parameter("@par_Tax_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Tax_ID_v.v); lpar.Add(par_Tax_ID); Tax_ID_condition = " Tax_ID = " + par_Tax_ID.Name + " "; sTaxID_value = "@par_Tax_ID"; } else { Tax_ID_condition = " Tax_ID is null "; sTaxID_value = "null"; } if (Registration_ID_v != null) { SQL_Parameter par_Registration_ID = new SQL_Parameter("@par_Registration_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Registration_ID_v.v); lpar.Add(par_Registration_ID); Registration_ID_condition = " Registration_id = " + par_Registration_ID.Name + " "; sRegistration_ID_value = "@par_Registration_ID"; } else { Registration_ID_condition = " Registration_ID is null "; sRegistration_ID_value = "null"; } string sql_select = "select ID from Atom_Organisation where " + Name_condition + @" and " + Tax_ID_condition + @" and " + Registration_ID_condition; DataTable dt = new DataTable(); if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (Atom_Organisation_ID_v == null) { Atom_Organisation_ID_v = new long_v(); } Atom_Organisation_ID_v.v = (long)dt.Rows[0]["ID"]; return f_Atom_OrganisationData.Get(Atom_Organisation_ID_v.v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, Image_Hash_v, Image_Data_v, Image_Description_v, BankName_v, TRR_v, ref Atom_OrganisationData_ID_v); } else { string sql_insert = " insert into Atom_Organisation (Name,Tax_ID,Registration_ID) values (" + sName_value + "," + sTaxID_value + "," + sRegistration_ID_value + ")"; object oret = null; long Atom_Organisation_ID = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref Atom_Organisation_ID, ref oret, ref Err, "Atom_Organisation")) { if (Atom_Organisation_ID_v == null) { Atom_Organisation_ID_v = new long_v(); } Atom_Organisation_ID_v.v = Atom_Organisation_ID; return f_Atom_OrganisationData.Get(Atom_Organisation_ID_v.v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, Image_Hash_v, Image_Data_v, Image_Description_v, BankName_v, TRR_v, ref Atom_OrganisationData_ID_v); } else { LogFile.Error.Show("ERROR:f_Atom_Organisation:Get_Atom_Organisation:sql=" + sql_insert + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Organisation:Get_Atom_Organisation:sql=" + sql_select + "\r\nErr=" + Err); return false; } }
public static bool Get(long Customer_Org_ID, ref long_v Atom_Customer_Org_ID_v) { DataTable dt = new DataTable(); string sql = @"select orgd.Organisation_ID from Customer_Org corg inner join OrganisationData orgd on orgd.ID = corg.OrganisationData_ID where corg.ID = " + Customer_Org_ID.ToString(); string Err = null; if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { long Org_ID = (long)dt.Rows[0]["Organisation_ID"]; dt.Clear(); sql = @"select OrganisationData_$_org_$$Name, OrganisationData_$_org_$$Tax_ID, OrganisationData_$_org_$$Registration_ID, OrganisationData_$_orgt_$$OrganisationTYPE, OrganisationData_$_cadrorg_$_cstrnorg_$$StreetName, OrganisationData_$_cadrorg_$_chounorg_$$HouseNumber, OrganisationData_$_cadrorg_$_cziporg_$$ZIP, OrganisationData_$_cadrorg_$_ccitorg_$$City, OrganisationData_$_cadrorg_$_ccouorg_$$Country, OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2, OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3, OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num, OrganisationData_$_cadrorg_$_cstorg_$$State, OrganisationData_$_cphnnorg_$$PhoneNumber, OrganisationData_$_cfaxnorg_$$FaxNumber, OrganisationData_$_cemailorg_$$Email, OrganisationData_$_chomepgorg_$$HomePage, OrganisationData_$_logo_$$Image_Hash, OrganisationData_$_logo_$$Image_Data, OrganisationData_$_logo_$$Description from OrganisationData_VIEW where OrganisationData_$_org_$$ID = " + Org_ID.ToString(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { string_v Name_v = tf.set_string(dt.Rows[0]["OrganisationData_$_org_$$Name"]); string_v Tax_ID_v = tf.set_string(dt.Rows[0]["OrganisationData_$_org_$$Tax_ID"]); string_v Registration_ID_v = tf.set_string(dt.Rows[0]["OrganisationData_$_org_$$Registration_ID"]); string_v OrganisationTYPE_v = tf.set_string(dt.Rows[0]["OrganisationData_$_orgt_$$OrganisationTYPE"]); PostAddress_v Address_v = new PostAddress_v(); Address_v.StreetName_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_cstrnorg_$$StreetName"]); Address_v.HouseNumber_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_chounorg_$$HouseNumber"]); Address_v.ZIP_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_cziporg_$$ZIP"]); Address_v.City_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_ccitorg_$$City"]); Address_v.Country_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_ccouorg_$$Country"]); Address_v.Country_ISO_3166_a2_v= tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a2"]); Address_v.Country_ISO_3166_a3_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_a3"]); Address_v.Country_ISO_3166_num_v = tf.set_dshort(fs.MyConvertToShort(dt.Rows[0]["OrganisationData_$_cadrorg_$_ccouorg_$$Country_ISO_3166_num"])); Address_v.State_v = tf.set_dstring(dt.Rows[0]["OrganisationData_$_cadrorg_$_cstorg_$$State"]); string_v PhoneNumber_v = tf.set_string(dt.Rows[0]["OrganisationData_$_cphnnorg_$$PhoneNumber"]); string_v FaxNumber_v = tf.set_string(dt.Rows[0]["OrganisationData_$_cfaxnorg_$$FaxNumber"]); string_v Email_v = tf.set_string(dt.Rows[0]["OrganisationData_$_cemailorg_$$Email"]); string_v HomePage_v = tf.set_string(dt.Rows[0]["OrganisationData_$_chomepgorg_$$HomePage"]); string_v Image_Hash_v = tf.set_string(dt.Rows[0]["OrganisationData_$_logo_$$Image_Hash"]); byte_array_v Image_Data_v = tf.set_byte_array(dt.Rows[0]["OrganisationData_$_logo_$$Image_Data"]); string_v Description_v = tf.set_string(dt.Rows[0]["OrganisationData_$_logo_$$Description"]); string_v BankName_v = null; string_v TRR_v = null; sql = @"select oacc.Description as OrganisationAccount_Description o.Name, bacc.TRR, bacc.Active from OrganisationAccount oacc inner join BankAccount bacc on oacc.BankAccount_ID = bacc.ID inner join Bank b on bacc.Bank_ID == b.ID inner join Organisation o on b.Organisation_ID = o.ID where oacc.Organisation_ID = " + Org_ID.ToString() + " and bacc.Active = 1"; dt.Rows.Clear(); dt.Columns.Clear(); dt.Clear(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count > 0) { BankName_v = tf.set_string(dt.Rows[0]["Name"]); TRR_v = tf.set_string(dt.Rows[0]["TRR"]); } } long_v Atom_Organisation_ID_v = null; long_v Atom_OrganisationData_ID_v = null; if (f_Atom_Organisation.Get(Name_v, Tax_ID_v, Registration_ID_v, OrganisationTYPE_v, Address_v, PhoneNumber_v, FaxNumber_v, Email_v, HomePage_v, BankName_v, TRR_v, Image_Hash_v, Image_Data_v, Description_v, ref Atom_Organisation_ID_v, ref Atom_OrganisationData_ID_v)) { sql = "select ID from Atom_Customer_Org where Atom_Organisation_ID = " + Atom_Organisation_ID_v.v.ToString(); dt.Clear(); if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err)) { if (dt.Rows.Count == 1) { if (Atom_Customer_Org_ID_v == null) { Atom_Customer_Org_ID_v = new long_v(); } Atom_Customer_Org_ID_v.v = (long)dt.Rows[0]["ID"]; return true; } else { sql = "insert into Atom_Customer_Org (Atom_Organisation_ID) values (" + Atom_Organisation_ID_v.v.ToString() + ")"; object ores = null; long id = -1; if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, null, ref id, ref ores, ref Err, "Atom_Customer_Org")) { if (Atom_Customer_Org_ID_v == null) { Atom_Customer_Org_ID_v = new long_v(); } Atom_Customer_Org_ID_v.v = id; return true; } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Get:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Get:\r\nsql=" + sql + "\r\nErr=" + Err); return false; } } else { return false; } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Get:sql=" + sql + "\ndt.Rows.Count!=1"); return false; } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Get:sql=" + sql + "\ndt.Rows.Count!=1"); return false; } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Customer_Org_ID = " + Customer_Org_ID.ToString() + " not found in table Customer_Org !"); return false; } } else { LogFile.Error.Show("ERROR:f_Atom_Customer_Org:Get:sql=" + sql + "\ndt.Rows.Count!=1"); return false; } }
public static PostAddress_v Copy(PostAddress_v xpa) { if (xpa != null) { return xpa.Clone(); } else { return null; } }
public PostAddress_v Clone() { PostAddress_v pa = new PostAddress_v(); pa.StreetName_v = dstring_v.Copy(this.StreetName_v); pa.HouseNumber_v = dstring_v.Copy(this.HouseNumber_v); pa.ZIP_v = dstring_v.Copy(this.ZIP_v); pa.City_v = dstring_v.Copy(this.City_v); pa.Country_v = dstring_v.Copy(this.Country_v); pa.State_v = dstring_v.Copy(this.State_v); pa.Country_ISO_3166_a2_v = dstring_v.Copy(this.Country_ISO_3166_a2_v); pa.Country_ISO_3166_a3_v = dstring_v.Copy(this.Country_ISO_3166_a3_v); pa.Country_ISO_3166_num_v = dshort_v.Copy(this.Country_ISO_3166_num_v); return pa; }