public static bool Get(string Name,
string UniqueName,
bool bToOffer,
Image Item_Image,
int_v Code_v,
string Unit_Name,
string Unit_Symbol,
int Unit_DecimalPlaces,
bool Unit_StorageOption,
string Unit_Description,
string barcode,
string Description,
f_Expiry.Expiry_v Expiry_v,
f_Warranty.Warranty_v Warranty_v,
string Item_ParentGroup1,
string Item_ParentGroup2,
string Item_ParentGroup3,
ref long Unit_ID,
ref long Item_ID)
{
string Err = null;
DataTable dt = new DataTable();
string sql = null;
object oret = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
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 spar_UniqueName = "@par_UniqueName";
SQL_Parameter par_UniqueName = new SQL_Parameter(spar_UniqueName, SQL_Parameter.eSQL_Parameter.Nvarchar, false, UniqueName);
lpar.Add(par_UniqueName);
string spar_ToOffer = "@par_ToOffer";
SQL_Parameter par_ToOffer = new SQL_Parameter(spar_ToOffer, SQL_Parameter.eSQL_Parameter.Bit, false, bToOffer);
lpar.Add(par_ToOffer);
string scond_barcode = " barcode is null ";
string sval_barcode = "null";
if (barcode!=null)
{
string spar_Barcode = "@par_Barcode";
SQL_Parameter par_Barcode = new SQL_Parameter(spar_Barcode, SQL_Parameter.eSQL_Parameter.Nvarchar, false, barcode);
lpar.Add(par_Barcode);
scond_barcode = " barcode = " + spar_Barcode +" ";
sval_barcode = " " + spar_Barcode + " ";
}
string scond_Description = " Description is null ";
string sval_Description = "null";
if (Description != null)
{
string spar_Description = "@par_Description";
SQL_Parameter par_Barcode = new SQL_Parameter(spar_Description, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Description);
lpar.Add(par_Barcode);
scond_Description = " Description = " + spar_Description + " ";
sval_Description = " " + spar_Description + " ";
}
string scond_Code = " Code is null ";
string sval_Code = "null";
if (Code_v != null)
{
scond_Code = " Code = " + Code_v.v.ToString() + " ";
sval_Code = " " + Code_v.v.ToString() + " ";
}
long_v Expiry_ID_v = null;
if (!f_Expiry.Get(Expiry_v,ref Expiry_ID_v))
{
return false;
}
string scond_Expiry_ID = " Expiry_ID is null ";
string sval_Expiry_ID = "null";
if (Expiry_ID_v != null)
{
scond_Expiry_ID = " Expiry_ID = " + Expiry_ID_v.v.ToString() + " ";
sval_Expiry_ID = " " + Expiry_ID_v.v.ToString() + " ";
}
long_v Warranty_ID_v = null;
if (!f_Warranty.Get(Warranty_v, ref Warranty_ID_v))
{
return false;
}
string scond_Warranty_ID = " Warranty_ID is null ";
string sval_Warranty_ID = "null";
if (Warranty_ID_v != null)
{
scond_Warranty_ID = " Warranty_ID = " + Warranty_ID_v.v.ToString() + " ";
sval_Warranty_ID = " " + Warranty_ID_v.v.ToString() + " ";
}
string scond_Item_ParentGroup1_ID = " Item_ParentGroup1_ID is null ";
string sval_Item_ParentGroup1_ID = " null ";
string scond_Item_Image_ID = " Item_Image_ID is null ";
string sval_Item_Image_ID = " null ";
if (!f_Unit.Get(Unit_Name,Unit_Symbol,Unit_DecimalPlaces,Unit_StorageOption,Unit_Description,ref Unit_ID))
{
return false;
}
if (Item_ParentGroup1 != null)
{
long Item_ParentGroup1_ID = -1;
long Item_Image_ID = -1;
if (f_Item_ParentGroup1.Get(Item_ParentGroup1, Item_ParentGroup2, Item_ParentGroup3, ref Item_ParentGroup1_ID))
{
scond_Item_ParentGroup1_ID = " Item_ParentGroup1_ID = " + Item_ParentGroup1_ID.ToString() + " ";
sval_Item_ParentGroup1_ID = " " + Item_ParentGroup1_ID.ToString() + " ";
if (Item_Image != null)
{
if (f_Item_Image.Get(Item_Image, ref Item_Image_ID))
{
scond_Item_Image_ID = " Item_Image_ID = " + Item_Image_ID.ToString() + " ";
sval_Item_Image_ID = " " + Item_Image.ToString() + " ";
}
else
{
return false;
}
}
}
}
//sql = "select ID from Item where Name = " + spar_Name + " and UniqueName = " + spar_UniqueName + " and ToOffer = " + spar_ToOffer + " and " + scond_Code + " and " + scond_Item_ParentGroup1_ID + " and " + scond_Item_Image_ID;
sql = "select ID from Item where UniqueName = " + spar_UniqueName;
if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
Item_ID = (long)dt.Rows[0]["ID"];
sql = "select ID from Item where Name = " + spar_Name +
" and UniqueName = " + spar_UniqueName +
" and ToOffer = " + spar_ToOffer +
" and " + scond_Code +
" and " + scond_Item_ParentGroup1_ID +
" and " + scond_Item_Image_ID +
" and Unit_ID = " + Unit_ID.ToString() +
" and " + scond_barcode +
" and " + scond_Description +
" and " + scond_Expiry_ID +
" and " + scond_Warranty_ID;
dt.Clear();
dt.Rows.Clear();
dt.Columns.Clear();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
return true;
}
else
{
sql = @"update Item set Name = " + spar_Name + @",
ToOffer = " + spar_ToOffer + @",
Code = " + sval_Code + @",
Item_ParentGroup1_ID = " + sval_Item_ParentGroup1_ID + @",
Item_Image_ID = " + sval_Item_Image_ID + @",
Unit_ID = " + Unit_ID.ToString() + @",
barcode = " + sval_barcode + @",
Description = " + sval_Description + @",
Expiry_ID = " + sval_Expiry_ID + @",
Warranty_ID = " + sval_Warranty_ID + " where ID = " + Item_ID.ToString();
if (DBSync.DBSync.ExecuteNonQuerySQL(sql, lpar, ref oret, ref Err))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Item:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_Item:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
sql = @"insert into Item (Name,
UniqueName,
ToOffer,
Code,
Item_ParentGroup1_ID,
Item_Image_ID,
Unit_ID,
barcode,
Description,
Expiry_ID,
Warranty_ID
)values("
+ spar_Name + ","
+ spar_UniqueName + ","
+ spar_ToOffer + ","
+ sval_Code + ","
+ sval_Item_ParentGroup1_ID + ","
+ sval_Item_Image_ID + ","
+ Unit_ID.ToString() + ","
+ sval_barcode + ","
+ sval_Description + ","
+ sval_Expiry_ID + ","
+ sval_Warranty_ID +
")";
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Item_ID, ref oret, ref Err, "Item"))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Item:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_Item:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
public static bool Get(decimal RetailPricePerUnit,
decimal_v Discount_v,
string TaxationName,
decimal TaxationRate,
string Item_Name,
string UniqueName,
bool bToOffer,
Image Item_Image,
int_v Code_v,
string Unit_Name,
string Unit_Symbol,
int Unit_DecimalPlaces,
bool Unit_StorageOption,
string Unit_Description,
string barcode,
string Item_Description,
f_Expiry.Expiry_v Expiry_v,
f_Warranty.Warranty_v Warranty_v,
string Item_ParentGroup1,
string Item_ParentGroup2,
string Item_ParentGroup3,
string sPriceListName,
bool valid,
string Currency_Abbreviation,
string Currency_Name,
string Currency_Symbol,
int CurrencyCode,
int Currency_DecimalPlaces,
DateTime_v ValidFrom_v,
DateTime_v ValidTo_v,
DateTime_v CreationDate_v,
string PriceList_Description,
ref long Unit_ID,
ref long Currency_ID,
ref long Item_ID,
ref long Taxation_ID,
ref long PriceList_ID,
ref long Price_Item_ID)
{
if (f_Taxation.Get(TaxationName, TaxationRate, ref Taxation_ID))
{
if (f_Currency.Get(Currency_Abbreviation, Currency_Name, Currency_Symbol, CurrencyCode, Currency_DecimalPlaces, ref Currency_ID))
{
if (f_Item.Get(Item_Name, UniqueName, bToOffer, Item_Image, Code_v, Unit_Name,Unit_Symbol,Unit_DecimalPlaces,Unit_StorageOption,Unit_Description,barcode, Item_Description, Expiry_v, Warranty_v, Item_ParentGroup1, Item_ParentGroup2, Item_ParentGroup3,ref Unit_ID, ref Item_ID))
{
if (f_PriceList.Get(sPriceListName, valid, Currency_ID, ValidFrom_v, ValidTo_v, CreationDate_v, PriceList_Description, ref PriceList_ID))
{
if (Get(RetailPricePerUnit, Discount_v, Taxation_ID, Item_ID, PriceList_ID, ref Price_Item_ID))
{
return true;
}
}
}
}
}
return false;
}