public Form_StockItem_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string where_condition, string ColumnToOrderBy,TangentaDB.Item_Data x_Item_Data, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
m_Item_Data = x_Item_Data;
lngRPM.s_lbl_Item_Stock.Text(lbl_Item_Stock);
this.lbl_Item.Text = m_Item_Data.Item_UniqueName.v;
dbTables = xdbTables;
tbl = xtbl;
this.Text = lngRPM.s_Stock.s;
string selection = @"Stock_$_ppi_$_i_$$UniqueName,Stock_$$dQuantity,Stock_$$ExpiryDate, Stock_$_ppi_$_pp_$$PurchasePricePerUnit,Stock_$$ImportTime,Stock_$_ppi_$_i_$$Description,Stock_$_ppi_$_st_$_sup_$_c_$_orgd_$_org_$$Name,Stock_$_ppi_$_i_$$Code,Stock_$_ppi_$_i_$_u_$$Name,Stock_$_ppi_$_i_$_u_$$Symbol,Stock_$_ppi_$_i_$_u_$$DecimalPlaces,Stock_$_ppi_$_i_$_u_$$StorageOption,Stock_$_ppi_$_i_$_exp_$$ExpectedShelfLifeInDays,Stock_$_ppi_$_i_$_exp_$$SaleBeforeExpiryDateInDays,Stock_$_ppi_$_i_$_exp_$$DiscardBeforeExpiryDateInDays,Stock_$_ppi_$_i_$_wrty_$$WarrantyDuration, Stock_$_ppi_$_i_$_wrty_$$WarrantyDurationType,Stock_$_ppi_$_i_$_wrty_$$WarrantyConditions,Stock_$_ppi_$_i_$_iimg_$$Image_Data,ID";
if (m_usrc_EditTable.Init(dbTables, tbl, selection,ColumnToOrderBy,false,where_condition,null,false,nav))
{
if (m_usrc_EditTable.RowsCount==0)
{
if (f_PurchasePrice_Item.GetOneFrom_Item_ID(m_Item_Data.Item_ID.v, ref PurchasePrice_Item_ID))
{
m_usrc_EditTable.FillInitialData();
}
else
{
bclose = true;
return;
}
}
m_usrc_EditTable.CallBackSetInputControlProperties(m_Item_Data.Unit_DecimalPlaces.v);
}
else
{
bclose = true;
}
}
public Atom_DocInvoice_ShopC_Item_Price_Stock_Data Contains(Item_Data m_Item_Data)
{
foreach (object o in this.m_DocInvoice_ShopC_Item_Data_LIST)
{
if (((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)o).Atom_Item_UniqueName.v.Equals(m_Item_Data.Item_UniqueName.v))
{
return ((Atom_DocInvoice_ShopC_Item_Price_Stock_Data)o);
}
}
return null;
}
public void Add(long xDocInvoice_ID,object xusrc_Item,Item_Data xItemData,decimal xFactoryQuantity, decimal xStockQuantity, ref Atom_DocInvoice_ShopC_Item_Price_Stock_Data appisd, bool b_from_factory)
{
foreach (Atom_DocInvoice_ShopC_Item_Price_Stock_Data appisdx in m_DocInvoice_ShopC_Item_Data_LIST)
{
if (appisdx.Item_ID.v == xItemData.Item_ID.v)
{
appisdx.m_ShopShelf_Source.Add_Stock_Data(xItemData, xFactoryQuantity, xStockQuantity, b_from_factory);
appisd = appisdx;
return;
}
}
appisd = new Atom_DocInvoice_ShopC_Item_Price_Stock_Data();
appisd.Set(xusrc_Item, xItemData, xDocInvoice_ID, xFactoryQuantity, xStockQuantity, b_from_factory);
m_DocInvoice_ShopC_Item_Data_LIST.Add(appisd);
}
private void Set()
{
items.Clear();
foreach (DataRow dr in dt_Price_Item_Stock.Rows)
{
Item_Data xItem_Data = new Item_Data();
xItem_Data.Set_Price_Item_Stock(dr);
if (dr[m_cpis.icol_Item_ID] is long)
{
long item_id = (long)dr[m_cpis.icol_Item_ID];
if (ExistingItem(item_id, xItem_Data))
{
continue;
}
else
{
Stock_Data stock_data = new Stock_Data();
if (xItem_Data.Stock_ID != null)
{
stock_data.Stock_ID = new DBTypes.long_v();
stock_data.Stock_ID.v = xItem_Data.Stock_ID.v;
}
else
{
stock_data.Stock_ID = null;
}
if (xItem_Data.Stock_ImportTime != null)
{
stock_data.Stock_ImportTime = new DBTypes.DateTime_v();
stock_data.Stock_ImportTime.v = xItem_Data.Stock_ImportTime.v;
}
else
{
stock_data.Stock_ImportTime = null;
}
if (xItem_Data.Stock_ExpiryDate != null)
{
stock_data.Stock_ExpiryDate = new DBTypes.DateTime_v();
stock_data.Stock_ExpiryDate.v = xItem_Data.Stock_ExpiryDate.v;
}
else
{
stock_data.Stock_ExpiryDate = null;
}
if (xItem_Data.Stock_dQuantity != null)
{
stock_data.dQuantity = new DBTypes.decimal_v();
stock_data.dQuantity.v = xItem_Data.Stock_dQuantity.v;
}
else
{
stock_data.dQuantity = null;
}
xItem_Data.Stock_Data_List.Add(stock_data);
items.Add(xItem_Data);
}
}
else
{
LogFile.Error.Show("ERROR:ShopShelf:Set:dr[m_cpis.icol_Item_ID] is not long !");
}
}
}
private bool ExistingItem(long item_id, Item_Data xItem_Data)
{
foreach (object o in items)
{
Item_Data idata = (Item_Data)o;
if (idata.Item_ID != null)
{
if (idata.Item_ID.v == item_id)
{
Stock_Data stock_data = new Stock_Data();
if (xItem_Data.Stock_ID != null)
{
stock_data.Stock_ID = new DBTypes.long_v();
stock_data.Stock_ID.v = xItem_Data.Stock_ID.v;
}
else
{
stock_data.Stock_ID = null;
}
if (xItem_Data.Stock_ImportTime != null)
{
stock_data.Stock_ImportTime = new DBTypes.DateTime_v();
stock_data.Stock_ImportTime.v = xItem_Data.Stock_ImportTime.v;
}
else
{
stock_data.Stock_ImportTime = null;
}
if (xItem_Data.Stock_ExpiryDate != null)
{
stock_data.Stock_ExpiryDate = new DBTypes.DateTime_v();
stock_data.Stock_ExpiryDate.v = xItem_Data.Stock_ExpiryDate.v;
}
else
{
stock_data.Stock_ExpiryDate = null;
}
if (xItem_Data.Stock_dQuantity != null)
{
stock_data.dQuantity = new DBTypes.decimal_v();
stock_data.dQuantity.v = xItem_Data.Stock_dQuantity.v;
}
else
{
stock_data.dQuantity = null;
}
idata.Stock_Data_List.Add(stock_data);
return true;
}
}
}
return false;
}
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 Add_Stock_Data(Item_Data xItem_Data, decimal xFactoryQuantity,decimal xStockQuantity, bool b_from_factory)
{
if (b_from_factory)
{
Stock_Data stock_data = new Stock_Data();
if (stock_data.dQuantity == null)
{
stock_data.dQuantity = new decimal_v();
}
stock_data.dQuantity.v = xFactoryQuantity;
Stock_Data_List.Add(stock_data);
}
else
{
decimal dquantity = xStockQuantity;
xItem_Data.Stock_Data_List.Sort((x, y) => Compare_Stock_ExpiryDate(x,y));
foreach (Stock_Data sd in xItem_Data.Stock_Data_List)
{
if (dquantity > 0)
{
if (sd.dQuantity_from_stock != null)
{
Stock_Data stock_data = new Stock_Data();
if (dquantity > sd.dQuantity_from_stock.v)
{
dquantity -= sd.dQuantity_from_stock.v;
if (stock_data.dQuantity == null)
{
stock_data.dQuantity = new decimal_v();
}
stock_data.dQuantity.v = sd.dQuantity_from_stock.v;
sd.dQuantity.v = 0;
if (stock_data.dQuantity_New_in_Stock == null)
{
stock_data.dQuantity_New_in_Stock = new decimal_v();
}
stock_data.dQuantity_New_in_Stock.v = 0;
stock_data.Stock_ID = new long_v();
stock_data.Stock_ID.v = sd.Stock_ID.v;
Stock_Data_List.Add(stock_data);
}
else
{
if (stock_data.dQuantity_from_stock == null)
{
stock_data.dQuantity = new decimal_v();
}
stock_data.dQuantity.v = dquantity;
sd.dQuantity.v -= dquantity;
if (stock_data.dQuantity_New_in_Stock == null)
{
stock_data.dQuantity_New_in_Stock = new decimal_v();
}
stock_data.dQuantity_New_in_Stock.v = sd.dQuantity.v;
stock_data.Stock_ID = new long_v();
stock_data.Stock_ID.v = sd.Stock_ID.v;
dquantity = 0;
Stock_Data_List.Add(stock_data);
}
}
}
else
{
break;
}
}
}
}