public static bool_v Copy(bool_v o_v)
{
if (o_v != null)
{
return o_v.Clone();
}
else
{
return null;
}
}
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 void Set(string DocInvoice, DataRow dria,
ref List<object> DocInvoice_ShopC_Item_Data_list)
{
Stock_Data stock_data = null;
int i = 0;
int iCount = DocInvoice_ShopC_Item_Data_list.Count;
Atom_Item_ID = tf.set_long(dria["Atom_Item_ID"]);
if (Atom_Item_ID != null)
{
for (i = 0; i < iCount; i++)
{
if (((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)DocInvoice_ShopC_Item_Data_list[i]).Atom_Item_ID.v == Atom_Item_ID.v)
{
stock_data = new Stock_Data();
stock_data.Set(dria);
((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)DocInvoice_ShopC_Item_Data_list[i]).m_ShopShelf_Source.Stock_Data_List.Add(stock_data);
return;
}
}
m_ShopShelf_Source.Clear();
DocInvoice_ShopC_Item_ID = tf.set_long(dria[DocInvoice+"_ShopC_Item_ID"]);
DocInvoice_ID = tf.set_long(dria[DocInvoice+"_ID"]);
Atom_Price_Item_ID = tf.set_long(dria["Atom_Price_Item_ID"]);
dQuantity_all = tf.set_decimal(dria["dQuantity"]);
RetailPricePerUnit = tf.set_decimal(dria["RetailPricePerUnit"]);
Discount = tf.set_decimal(dria["Discount"]);
RetailPriceWithDiscount = tf.set_decimal(dria["RetailPriceWithDiscount"]);
TaxPrice = tf.set_decimal(dria["TaxPrice"]);
ExtraDiscount = tf.set_decimal(dria["ExtraDiscount"]);
//dQuantity = tf.set_decimal(dria["dQuantity"]);
Atom_Item_UniqueName = tf.set_string(dria["Atom_Item_UniqueName"]);
Atom_Item_Name_Name = tf.set_string(dria["Atom_Item_Name_Name"]);
Atom_Item_barcode_barcode = tf.set_string(dria["Atom_Item_barcode_barcode"]);
Atom_Taxation_Name = tf.set_string(dria["Atom_Taxation_Name"]);
Atom_Taxation_Rate = tf.set_decimal(dria["Atom_Taxation_Rate"]);
Atom_Item_Description_Description = tf.set_string(dria["Atom_Item_Description_Description"]);
Atom_Warranty_ID = tf.set_long(dria["Atom_Warranty_ID"]);
Atom_Warranty_WarrantyDurationType = tf.set_short(dria["Atom_Warranty_WarrantyDurationType"]);
Atom_Warranty_WarrantyDuration = tf.set_int(dria["Atom_Warranty_WarrantyDuration"]);
Atom_Warranty_WarrantyConditions = tf.set_string(dria["Atom_Warranty_WarrantyConditions"]);
Atom_Expiry_ID = tf.set_long(dria["Atom_Expiry_ID"]);
Atom_Expiry_ExpectedShelfLifeInDays = tf.set_int(dria["Atom_Expiry_ExpectedShelfLifeInDays"]);
Atom_Expiry_SaleBeforeExpiryDateInDays = tf.set_int(dria["Atom_Expiry_SaleBeforeExpiryDateInDays"]);
Atom_Expiry_DiscardBeforeExpiryDateInDays = tf.set_int(dria["Atom_Expiry_DiscardBeforeExpiryDateInDays"]);
Atom_Expiry_ExpiryDescription = tf.set_string(dria["Atom_Expiry_ExpiryDescription"]);
Item_ID = tf.set_long(dria["Item_ID"]);
Atom_Unit_Name = tf.set_string(dria["Atom_Unit_Name"]);
Atom_Unit_Symbol = tf.set_string(dria["Atom_Unit_Symbol"]);
Atom_Unit_DecimalPlaces = tf.set_int(dria["Atom_Unit_DecimalPlaces"]);
Atom_Unit_Description = tf.set_string(dria["Atom_Unit_Description"]);
Atom_Unit_StorageOption = tf.set_bool(dria["Atom_Unit_StorageOption"]);
Atom_PriceList_Name = tf.set_string(dria["Atom_PriceList_Name"]);
Atom_Currency_Name = tf.set_string(dria["Atom_Currency_Name"]);
Atom_Currency_Abbreviation = tf.set_string(dria["Atom_Currency_Abbreviation"]);
Atom_Currency_Symbol = tf.set_string(dria["Atom_Currency_Symbol"]);
Atom_Currency_DecimalPlaces = tf.set_int(dria["Atom_Currency_DecimalPlaces"]);
Atom_Item_Image_Hash = tf.set_string(dria["Atom_Item_Image_Hash"]);
Atom_Item_Image_Data = tf.set_byte_array(dria["Atom_Item_Image_Data"]);
if (dria["s1_name"] is string)
{
s1_name = (string)dria["s1_name"];
}
if (dria["s2_name"] is string)
{
s2_name = (string)dria["s2_name"];
}
if (dria["s3_name"] is string)
{
s3_name = (string)dria["s3_name"];
}
stock_data = new Stock_Data();
stock_data.Set(dria);
m_ShopShelf_Source.Stock_Data_List.Add(stock_data);
DocInvoice_ShopC_Item_Data_list.Add(this);
}
else
{
LogFile.Error.Show("ERROR:DocInvoice_ShopC_Item_Data:Set(DataRow dria,..):Atom_Item_ID == null");
}
}
public void Set(object xusrc_Item, Item_Data xItem_Data,long xDocInvoice_ID, decimal xFactoryQuantity, decimal xStockQuantity, bool b_from_factory)
{
m_ShopShelf_Source.Clear();
DocInvoice_ShopC_Item_ID = null;
DocInvoice_ID = new long_v();
DocInvoice_ID.v = xDocInvoice_ID;
Atom_Price_Item_ID = null; // tf.set_long(dria["Atom_Price_Item_ID"]);
RetailPricePerUnit = (decimal_v)tf.Copy(xItem_Data.RetailPricePerUnit); //tf.set_decimal(dr[cpis.icol_RetailPricePerUnit]);
Discount = (decimal_v)tf.Copy(xItem_Data.Price_Item_Discount); // tf.set_decimal(dr[cpis.icol_Discount]);
decimal retail_price_with_discount = 0;
RetailPriceWithDiscount = tf.set_decimal(retail_price_with_discount);
//$$TODO
decimal tax_price = 0;
TaxPrice = tf.set_decimal(tax_price);
ExtraDiscount = tf.set_decimal(xItem_Data.ExtraDiscount);
Atom_Item_UniqueName = (string_v)tf.Copy(xItem_Data.Item_UniqueName);// tf.set_string(dr[cpis.icol_Item_UniqueName]);
Atom_Item_Name_Name = (string_v)tf.Copy(xItem_Data.Item_Name);//tf.set_string(dr[cpis.icol_Item_Name]);
Atom_Item_barcode_barcode = (string_v)tf.Copy(xItem_Data.Item_barcode);//tf.set_string(dr[cpis.icol_Item_barcode]);
Atom_Taxation_Name = (string_v)tf.Copy(xItem_Data.Taxation_Name);//tf.set_string(dr[cpis.icol_Taxation_Name]);
Atom_Taxation_Rate = (decimal_v)tf.Copy(xItem_Data.Taxation_Rate);//tf.set_decimal(dr[cpis.icol_Taxation_Rate]);
Atom_Item_Description_Description = (string_v)tf.Copy(xItem_Data.Item_Description);//tf.set_string(dr[cpis.icol_Item_Description]);
Atom_Warranty_ID = null; //tf.set_long(dria["Atom_Warranty_ID"]);
Atom_Warranty_WarrantyDurationType = (short_v)tf.Copy(xItem_Data.Warranty_WarrantyDurationType);//tf.set_short(dr[cpis.icol_Warranty_WarrantyDurationType]);
Atom_Warranty_WarrantyDuration = (int_v)tf.Copy(xItem_Data.Warranty_WarrantyDuration);//tf.set_int(dr[cpis.icol_Warranty_WarrantyDuration]);
Atom_Warranty_WarrantyConditions = (string_v)tf.Copy(xItem_Data.Warranty_WarrantyConditions);//tf.set_string(dr[cpis.icol_Warranty_WarrantyConditions]);
Atom_Expiry_ID = null; //tf.set_long(dr["Atom_Expiry_ID"]);
Atom_Expiry_ExpectedShelfLifeInDays = (int_v)tf.Copy(xItem_Data.Expiry_ExpectedShelfLifeInDays);//tf.set_int(dr[cpis.icol_Expiry_ExpectedShelfLifeInDays]);
Atom_Expiry_SaleBeforeExpiryDateInDays = (int_v)tf.Copy(xItem_Data.Expiry_SaleBeforeExpiryDateInDays);//tf.set_int(dr[cpis.icol_Expiry_SaleBeforeExpiryDateInDays]);
Atom_Expiry_DiscardBeforeExpiryDateInDays = (int_v)tf.Copy(xItem_Data.Expiry_DiscardBeforeExpiryDateInDays);//tf.set_int(dr[cpis.icol_Expiry_DiscardBeforeExpiryDateInDays]);
Atom_Expiry_ExpiryDescription = (string_v)tf.Copy(xItem_Data.Expiry_Description);//tf.set_string(dr[cpis.icol_Expiry_ExpiryDescription]);
Item_ID = (long_v)tf.Copy(xItem_Data.Item_ID);//tf.set_long(dr["Item_ID"]);
Atom_Unit_Name = (string_v)tf.Copy(xItem_Data.Unit_Name);//tf.set_string(dr[cpis.icol_Unit_Name]);
Atom_Unit_Symbol = (string_v)tf.Copy(xItem_Data.Unit_Symbol);//tf.set_string(dr[cpis.icol_Unit_Symbol]);
Atom_Unit_DecimalPlaces = (int_v)tf.Copy(xItem_Data.Unit_DecimalPlaces);//tf.set_int(dr[cpis.icol_Unit_DecimalPlaces]);
Atom_Unit_Description = (string_v)tf.Copy(xItem_Data.Unit_Description);//tf.set_string(dr[cpis.icol_Unit_Description]);
Atom_Unit_StorageOption = (bool_v)tf.Copy(xItem_Data.Unit_StorageOption);//tf.set_bool(dr[cpis.icol_Unit_StorageOption]);
Atom_PriceList_Name = (string_v)tf.Copy(xItem_Data.PriceList_Name);//tf.set_string(dr[cpis.icol_PriceList_Name]);
Atom_Currency_Name = (string_v)tf.Copy(xItem_Data.Currency_Name);// tf.set_string(dr[cpis.icol_Currency_Name]);
Atom_Currency_Abbreviation = (string_v)tf.Copy(xItem_Data.Currency_Abbreviation);//tf.set_string(dr[cpis.icol_Currency_Abbreviation]);
Atom_Currency_Symbol = (string_v)tf.Copy(xItem_Data.Currency_Symbol);//tf.set_string(dr[cpis.icol_Currency_Symbol]);
Atom_Currency_DecimalPlaces = (int_v)tf.Copy(xItem_Data.Currency_DecimalPlaces);//tf.set_int(dr[cpis.icol_Currency_DecimalPlaces]);
Atom_Item_Image_Hash = (string_v)tf.Copy(xItem_Data.Item_Image_Image_Hash);//tf.set_string(dr[cpis.icol_Currency_Symbol]);
Atom_Item_Image_Data = (byte_array_v)tf.Copy(xItem_Data.Item_Image_Image_Data);//Itemtf.set_byte_array(dr[cpis.icol_Item_Image_Image_Data]);
s1_name = xItem_Data.s1_name;
s2_name = xItem_Data.s2_name;
s3_name = xItem_Data.s3_name;
m_ShopShelf_Source.Add_Stock_Data(xItem_Data, xFactoryQuantity, xStockQuantity, b_from_factory);
}
public void set(object o)
{
this.type_v = null;
if (o == null) return;
if (o is bool)
{
this.type_v = new bool_v((bool)o);
}
else if (o is System.DBNull)
{
return;
}
else
{
LogFile.Error.Show("ERROR:DB_Types:set:WRONG TYPE:" + o.GetType().ToString() + " should be " + this.GetType().ToString());
}
}
public static bool_v set_bool(object p)
{
bool_v x = null;
if (p == null) return null;
if (p is bool)
{
x = new bool_v((bool)p);
}
else if (!(p is System.DBNull))
{
tf.ShowTypeError(p.GetType().ToString(), x.GetType().ToString());
}
return x;
}
public static bool Get(bool_v Person_Gender_v,
string_v FirstName_v,
string_v LastName_v,
DateTime_v DateOfBirth_v,
string_v Tax_ID_v,
string_v Registration_ID_v,
ref long_v Person_ID_v)
{
string Err = null;
string Gender_condition = null;
string sGender_value = null;
string cFirstName_ID_condition = null;
string cLastName_ID_condition = null;
string Tax_ID_condition = null;
string Registration_ID_condition = null;
string DateOfBirth_condition = null;
string scFirstName_ID_value = null;
string scLastName_ID_value = null;
string sTaxID_value = null;
string sRegistration_ID_value = null;
string sDateOfBirth_value = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
long cFirstName_ID = -1;
if (f_cFirstName.Get(FirstName_v, ref cFirstName_ID))
{
long cLastName_ID = -1;
if (f_cLastName.Get(LastName_v, ref cLastName_ID))
{
if (Person_Gender_v != null)
{
string spar_Gender = "@par_Gender";
SQL_Parameter par_Gender = new SQL_Parameter(spar_Gender, SQL_Parameter.eSQL_Parameter.Bit, false, Person_Gender_v.v);
lpar.Add(par_Gender);
Gender_condition = " Gender = " + spar_Gender + " ";
sGender_value = spar_Gender;
}
else
{
Gender_condition = " Gender is null ";
sGender_value = "null";
}
if (cFirstName_ID >= 0)
{
string spar_cFirstName_ID = "@par_cFirstName_ID";
SQL_Parameter par_FirstName = new SQL_Parameter(spar_cFirstName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cFirstName_ID);
lpar.Add(par_FirstName);
cFirstName_ID_condition = " cFirstName_ID = " + spar_cFirstName_ID + " ";
scFirstName_ID_value = spar_cFirstName_ID;
}
else
{
cFirstName_ID_condition = " cFirstName_ID is null ";
scFirstName_ID_value = "null";
}
if (cLastName_ID >= 0)
{
string spar_cLastName_ID = "@par_cLastName_ID";
SQL_Parameter par_LastName = new SQL_Parameter(spar_cLastName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cLastName_ID);
lpar.Add(par_LastName);
cLastName_ID_condition = " cLastName_ID = " + spar_cLastName_ID + " ";
scLastName_ID_value = spar_cLastName_ID;
}
else
{
cLastName_ID_condition = " cLastName_ID is null ";
scLastName_ID_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";
}
if (DateOfBirth_v != null)
{
string spar_DateOfBirth = "@par_DateOfBirth";
SQL_Parameter par_DateOfBirth = new SQL_Parameter(spar_DateOfBirth, SQL_Parameter.eSQL_Parameter.Datetime, false, DateOfBirth_v.v);
lpar.Add(par_DateOfBirth);
DateOfBirth_condition = " DateOfBirth = " + spar_DateOfBirth + " ";
sDateOfBirth_value = spar_DateOfBirth;
}
else
{
DateOfBirth_condition = " DateOfBirth is null ";
sDateOfBirth_value = "null";
}
string sql_select = "select ID from Person where " + Gender_condition + @" and
" + cFirstName_ID_condition + @" and
" + cLastName_ID_condition + @" and
" + DateOfBirth_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 (Person_ID_v == null)
{
Person_ID_v = new long_v();
}
Person_ID_v.v = (long)dt.Rows[0]["ID"];
return true;
}
else
{
string sql_insert = @" insert into Person (Gender,
cFirstName_ID,
cLastName_ID,
DateOfBirth,
Tax_ID,
Registration_ID) values (" + sGender_value + ","
+ scFirstName_ID_value + ","
+ scLastName_ID_value + ","
+ sDateOfBirth_value + ","
+ sTaxID_value + ","
+ sRegistration_ID_value + ")";
object oret = null;
long Person_ID = -1;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref Person_ID, ref oret, ref Err, "Person"))
{
if (Person_ID_v == null)
{
Person_ID_v = new long_v();
}
Person_ID_v.v = Person_ID;
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Person:Get:sql=" + sql_insert + "\r\nErr=" + Err);
}
}
}
else
{
LogFile.Error.Show("ERROR:f_Person:Getn:sql=" + sql_select + "\r\nErr=" + Err);
}
}
}
return false;
}
public bool_v Clone()
{
bool_v o_v = new bool_v();
o_v.v = this.v;
return o_v;
}
public void Set_Price_Item_Stock(DataRow xdr)
{
Price_Item_ID = tf.set_long(xdr["Price_Item_ID"]);
Price_Item_Discount = tf.set_decimal(xdr["Price_Item_Discount"]);
PriceList_ID = tf.set_long(xdr["PriceList_ID"]);
PriceList_Name = tf.set_string(xdr["PriceList_Name"]);
Currency_Name = tf.set_string(xdr["Currency_Name"]); ;
Currency_Abbreviation = tf.set_string(xdr["Currency_Abbreviation"]);
Currency_Symbol = tf.set_string(xdr["Currency_Symbol"]);
Currency_DecimalPlaces = tf.set_int(xdr["Currency_DecimalPlaces"]);
Stock_ID = tf.set_long(xdr["Stock_ID"]);
Stock_ExpiryDate = tf.set_DateTime(xdr["Stock_ExpiryDate"]);
Stock_dQuantity = tf.set_decimal(xdr["Stock_dQuantity"]);
RetailPricePerUnit = tf.set_decimal(xdr["RetailPricePerUnit"]);
Stock_ImportTime = tf.set_DateTime(xdr["Stock_ImportTime"]);
Item_ID = tf.set_long(xdr["Item_ID"]);
Item_UniqueName = tf.set_string(xdr["Item_UniqueName"]);
Item_Name = tf.set_string(xdr["Item_Name"]);
Item_barcode = tf.set_string(xdr["Item_barcode"]);
Item_Image_ID = tf.set_long(xdr["Item_Image_ID"]);
Item_Image_Image_Data = tf.set_byte_array(xdr["Item_Image_Image_Data"]);
Item_Image_Image_Hash = tf.set_string(xdr["Item_Image_Image_Hash"]);
Item_Description = tf.set_string(xdr["Item_Description"]);
Unit_Name = tf.set_string(xdr["Unit_Name"]);
Unit_Symbol = tf.set_string(xdr["Unit_Symbol"]);
Unit_DecimalPlaces = tf.set_int(xdr["Unit_DecimalPlaces"]);
Unit_StorageOption = tf.set_bool(xdr["Unit_StorageOption"]);
Unit_Description = tf.set_string(xdr["Unit_Description"]);
Expiry_ID = tf.set_long(xdr["Expiry_ID"]);
Unit_Name = tf.set_string(xdr["Unit_Name"]);
Expiry_ExpectedShelfLifeInDays = tf.set_int(xdr["Expiry_ExpectedShelfLifeInDays"]);
Expiry_SaleBeforeExpiryDateInDays = tf.set_int(xdr["Expiry_SaleBeforeExpiryDateInDays"]);
Expiry_DiscardBeforeExpiryDateInDays = tf.set_int(xdr["Expiry_DiscardBeforeExpiryDateInDays"]);
Expiry_Description = tf.set_string(xdr["Expiry_ExpiryDescription"]);
Item_Expiry_ID = tf.set_long(xdr["Expiry_ID"]);
Item_ToOffer = tf.set_bool(xdr["Item_ToOffer"]);
Item_Warranty_ID = tf.set_long(xdr["Warranty_ID"]);
Warranty_ID = tf.set_long(xdr["Warranty_ID"]);
Warranty_WarrantyConditions = tf.set_string(xdr["Warranty_WarrantyConditions"]);
Warranty_WarrantyDuration = tf.set_int(xdr["Warranty_WarrantyDuration"]);
Warranty_WarrantyDurationType = tf.set_short(fs.MyConvertToShort(xdr["Warranty_WarrantyDurationType"]));
Taxation_ID = tf.set_long(xdr["Taxation_ID"]);
Taxation_Name = tf.set_string(xdr["Taxation_Name"]);
Taxation_Rate = tf.set_decimal(xdr["Taxation_Rate"]);
PurchasePricePerUnit = tf.set_decimal(xdr["PurchasePricePerUnit"]);
PurchaseOrganisation_Name = tf.set_string(xdr["PurchaseOrganisation_Name"]);
PurchaseOrganisation_Address.StreetName_v = tf.set_dstring(xdr["StreetName"]);
PurchaseOrganisation_Address.HouseNumber_v = tf.set_dstring(xdr["HouseNumber"]);
PurchaseOrganisation_Address.City_v = tf.set_dstring(xdr["City"]);
PurchaseOrganisation_Address.ZIP_v = tf.set_dstring(xdr["ZIP"]);
PurchaseOrganisation_Address.Country_v = tf.set_dstring(xdr["Country"]);
if (xdr["s1_name"] is string)
{
s1_name = (string)xdr["s1_name"];
}
if (xdr["s2_name"] is string)
{
s2_name = (string)xdr["s2_name"];
}
if (xdr["s3_name"] is string)
{
s3_name = (string)xdr["s3_name"];
}
}
public static bool Get(string_v UserName_v,
string_v Password_v,
string_v Job_v,
bool_v Active_v,
string_v Description_v,
long_v Person_ID_v,
long_v Office_ID_v,
ref long_v myOrganisation_Person_v)
{
string Err = null;
DataTable dt = new DataTable();
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
string UserName_cond = null;
string UserName_value = null;
string spar_UserName = "******";
fs.AddPar(spar_UserName, ref lpar, UserName_v, ref UserName_cond, ref UserName_value);
string Password_cond = null;
string Password_value = null;
string spar_Password = "******";
fs.AddPar(spar_Password, ref lpar, Password_v, ref Password_cond, ref Password_value);
string Job_cond = null;
string Job_value = null;
string spar_Job = "Job";
fs.AddPar(spar_Job, ref lpar, Job_v, ref Job_cond, ref Job_value);
string Active_cond = null;
string Active_value = null;
string spar_Active = "Active";
fs.AddPar(spar_Active, ref lpar, Active_v, ref Active_cond, ref Active_value);
string Description_cond = null;
string Description_value = null;
string spar_Description = "Description";
fs.AddPar(spar_Description, ref lpar, Description_v, ref Description_cond, ref Description_value);
string Person_ID_cond = null;
string Person_ID_value = null;
string spar_Person_ID = "Person_ID";
fs.AddPar(spar_Person_ID, ref lpar, Person_ID_v, ref Person_ID_cond, ref Person_ID_value);
string Office_ID_cond = null;
string Office_ID_value = null;
string spar_Office_ID = "Office_ID";
fs.AddPar(spar_Office_ID, ref lpar, Office_ID_v, ref Office_ID_cond, ref Office_ID_value);
string sql = "select ID from myOrganisation_Person where " + UserName_cond + " and "
+ Password_cond + " and "
+ Job_cond + " and "
+ Active_cond + " and "
+ Description_cond + " and "
+ Person_ID_cond + " and "
+ Office_ID_cond;
if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
if (myOrganisation_Person_v == null)
{
myOrganisation_Person_v = new long_v();
}
myOrganisation_Person_v.v = (long)dt.Rows[0]["ID"];
return true;
}
else
{
sql = "select ID from myOrganisation_Person where " + UserName_cond ;
if (DBSync.DBSync.ReadDataTable(ref dt, sql,lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
if (myOrganisation_Person_v == null)
{
myOrganisation_Person_v = new long_v();
}
myOrganisation_Person_v.v = (long)dt.Rows[0]["ID"];
sql = "update myOrganisation_Person set Password = "******",
Job = " + Job_value + @",
Active = " + Active_value + @",
Description = " + Description_value + @",
Person_ID = " + Person_ID_value + @",
Office_ID = " + Office_ID_value + @"
where ID = " + myOrganisation_Person_v.v.ToString();
if (DBSync.DBSync.ExecuteNonQuerySQL_NoMultiTrans(sql, lpar, ref Err))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_myOrganisation:Get: sql = " + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
sql = @"insert into myOrganisation_Person ( UserName,
Password,
Job,
Active,
Description,
Person_ID,
Office_ID
) values
("
+ UserName_value + @",
" + Password_value + @",
" + Job_value + @",
" + Active_value + @",
" + Description_value + @",
" + Person_ID_value + @",
" + Office_ID_value + @")";
long myOrganisation_Person_ID = -1;
object oret = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref myOrganisation_Person_ID, ref oret, ref Err, "myOrganisation_Person"))
{
if (myOrganisation_Person_v == null)
{
myOrganisation_Person_v = new long_v();
}
myOrganisation_Person_v.v = myOrganisation_Person_ID;
return true;
}
else
{
LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_myOrganisation_Person:Get: sql = " + sql + "\r\nErr=" + Err);
return false;
}
}
public static bool Get(bool_v Gender_v,
string_v FirstName_v,
string_v LastName_v,
DateTime_v DateOfBirth_v,
string_v Tax_ID_v,
string_v Registration_ID_v,
string_v GsmNumber_v,
string_v PhoneNumber_v,
string_v Email_v,
string_v StreetName_v,
string_v HouseNumber_v,
string_v City_v,
string_v ZIP_v,
string_v Country_v,
string_v Country_ISO_3166_a2,
string_v Country_ISO_3166_a3,
short_v Country_ISO_3166_num,
string_v State_v,
string_v CardNumber_v,
string_v CardType_v,
string_v Image_Hash_v,
byte_array_v Image_Data_v,
ref long_v Atom_Person_ID_v)
{
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
string Gender_cond = null;
string Gender_value = null;
if (!fs.AddPar("Gender", ref lpar, Gender_v, ref Gender_cond, ref Gender_value))
{
return false;
}
long_v Atom_cFirstName_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cFirstName", "FirstName", FirstName_v, ref Atom_cFirstName_ID_v))
{
return false;
}
string Atom_cFirstName_ID_cond = null;
string Atom_cFirstName_ID_value = null;
if (!fs.AddPar("Atom_cFirstName_ID", ref lpar, Atom_cFirstName_ID_v, ref Atom_cFirstName_ID_cond, ref Atom_cFirstName_ID_value))
{
return false;
}
long_v Atom_cLastName_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cLastName", "LastName", LastName_v, ref Atom_cLastName_ID_v))
{
return false;
}
string Atom_cLastName_ID_cond = null;
string Atom_cLastName_ID_value = null;
if (!fs.AddPar("Atom_cLastName_ID", ref lpar, Atom_cLastName_ID_v, ref Atom_cLastName_ID_cond, ref Atom_cLastName_ID_value))
{
return false;
}
string DateOfBirth_cond = null;
string DateOfBirth_value = null;
if (!fs.AddPar("DateOfBirth", ref lpar, DateOfBirth_v, ref DateOfBirth_cond, ref DateOfBirth_value))
{
return false;
}
string Tax_ID_cond = null;
string Tax_ID_value = null;
if (!fs.AddPar("Tax_ID", ref lpar, Tax_ID_v, ref Tax_ID_cond, ref Tax_ID_value))
{
return false;
}
string Registration_ID_cond = null;
string Registration_ID_value = null;
if (!fs.AddPar("Registration_ID", ref lpar, Registration_ID_v, ref Registration_ID_cond, ref Registration_ID_value))
{
return false;
}
long_v Atom_cGsmNumber_Person_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cGsmNumber_Person", "GsmNumber", GsmNumber_v, ref Atom_cGsmNumber_Person_ID_v))
{
return false;
}
string Atom_cGsmNumber_Person_ID_cond = null;
string Atom_cGsmNumber_Person_ID_value = null;
if (!fs.AddPar("Atom_cGsmNumber_Person_ID", ref lpar, Atom_cGsmNumber_Person_ID_v, ref Atom_cGsmNumber_Person_ID_cond, ref Atom_cGsmNumber_Person_ID_value))
{
return false;
}
long_v Atom_cPhoneNumber_Person_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cPhoneNumber_Person", "PhoneNumber", PhoneNumber_v, ref Atom_cPhoneNumber_Person_ID_v))
{
return false;
}
string Atom_cPhoneNumber_Person_ID_cond = null;
string Atom_cPhoneNumber_Person_ID_value = null;
if (!fs.AddPar("Atom_cPhoneNumber_Person_ID", ref lpar, Atom_cPhoneNumber_Person_ID_v, ref Atom_cPhoneNumber_Person_ID_cond, ref Atom_cPhoneNumber_Person_ID_value))
{
return false;
}
long_v Atom_cEmail_Person_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cEmail_Person", "Email", Email_v, ref Atom_cEmail_Person_ID_v))
{
return false;
}
string Atom_cEmail_Person_cond = null;
string Atom_cEmail_Person_value = null;
if (!fs.AddPar("Atom_cEmail_Person_ID", ref lpar, Atom_cEmail_Person_ID_v, ref Atom_cEmail_Person_cond, ref Atom_cEmail_Person_value))
{
return false;
}
long_v Atom_cAddress_Person_ID_v = null;
if (!fs.Get_Atom_cAddress_Person_ID(StreetName_v,
HouseNumber_v,
ZIP_v,
City_v,
Country_v,
State_v,
ref Atom_cAddress_Person_ID_v
))
{
return false;
}
string Atom_cAddress_Person_ID_cond = null;
string Atom_cAddress_Person_ID_value = null;
if (!fs.AddPar("Atom_cAddress_Person_ID", ref lpar, Atom_cAddress_Person_ID_v, ref Atom_cAddress_Person_ID_cond, ref Atom_cAddress_Person_ID_value))
{
return false;
}
string CardNumber_cond = null;
string CardNumber_value = null;
if (!fs.AddPar("CardNumber", ref lpar, CardNumber_v, ref CardNumber_cond, ref CardNumber_value))
{
return false;
}
long_v Atom_cCardType_Person_ID_v = null;
if (!fs.Get_string_table_ID("Atom_cCardType_Person", "CardType", CardType_v, ref Atom_cCardType_Person_ID_v))
{
return false;
}
string Atom_cCardType_Person_ID_cond = null;
string Atom_cCardType_Person_ID_value = null;
if (!fs.AddPar("Atom_cCardType_Person_ID", ref lpar, Atom_cCardType_Person_ID_v, ref Atom_cCardType_Person_ID_cond, ref Atom_cCardType_Person_ID_value))
{
return false;
}
long_v Atom_PersonImage_ID_v = null;
if (!fs.Get_Atom_PersonImage_ID(Image_Hash_v, Image_Data_v, ref Atom_PersonImage_ID_v))
{
return false;
}
string Atom_PersonImage_ID_cond = null;
string Atom_PersonImage_ID_value = null;
if (!fs.AddPar("Atom_PersonImage_ID", ref lpar, Atom_PersonImage_ID_v, ref Atom_PersonImage_ID_cond, ref Atom_PersonImage_ID_value))
{
return false;
}
string sql = "select ID from Atom_Person where " + Gender_cond
+ " and " + Atom_cFirstName_ID_cond
+ " and " + Atom_cLastName_ID_cond
+ " and " + DateOfBirth_cond
+ " and " + Tax_ID_cond
+ " and " + Registration_ID_cond
+ " and " + Atom_cGsmNumber_Person_ID_cond
+ " and " + Atom_cPhoneNumber_Person_ID_cond
+ " and " + Atom_cEmail_Person_cond
+ " and " + Atom_cAddress_Person_ID_cond
+ " and " + Registration_ID_cond
+ " and " + CardNumber_cond
+ " and " + Atom_cCardType_Person_ID_cond
+ " and " + Atom_PersonImage_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 (Atom_Person_ID_v == null)
{
Atom_Person_ID_v = new long_v();
}
Atom_Person_ID_v.v = (long)dt.Rows[0]["ID"];
return true;
}
else
{
sql = @"insert into Atom_Person (Gender,
Atom_cFirstName_ID,
Atom_cLastName_ID,
DateOfBirth,
Tax_ID,
Registration_ID,
Atom_cGsmNumber_Person_ID,
Atom_cPhoneNumber_Person_ID,
Atom_cEmail_Person_ID,
Atom_cAddress_Person_ID,
CardNumber,
Atom_cCardType_Person_ID,
Atom_PersonImage_ID
)values(" + Gender_value
+ "," + Atom_cFirstName_ID_value
+ "," + Atom_cLastName_ID_value
+ "," + DateOfBirth_value
+ "," + Tax_ID_value
+ "," + Registration_ID_value
+ "," + Atom_cGsmNumber_Person_ID_value
+ "," + Atom_cPhoneNumber_Person_ID_value
+ "," + Atom_cEmail_Person_value
+ "," + Atom_cAddress_Person_ID_value
+ "," + CardNumber_value
+ "," + Atom_cCardType_Person_ID_value
+ "," + Atom_PersonImage_ID_value
+ ")";
long id = -1;
object ores = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref id, ref ores, ref Err, "Atom_Person"))
{
if (Atom_Person_ID_v == null)
{
Atom_Person_ID_v = new long_v();
}
Atom_Person_ID_v.v = id;
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_Atom_Customer_Person:Get_Atom_Person_ID:\r\nsql=" + sql + "\r\nErr=" + Err);
return false;
}
}
