//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;
}
