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 Form_Select_DefaultCurrency(long xDefaultCurrency_ID, ref TangentaDB.xCurrency xxCurrency, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
usrc_NavigationButtons1.Init(nav);
DefaultCurrency_ID = xDefaultCurrency_ID;
m_xCurrency = xxCurrency;
this.Text = lngRPM.s_SelectDefaultCurrency.s;
lbl_SelectedCurrency.Text = lngRPM.s_SelectedCurrency.s;
}
public bool Init(TangentaDB.ShopABC x_InvoiceDB, long x_Atom_Item_ID)
{
m_InvoiceDB = x_InvoiceDB;
m_Atom_Item_ID = x_Atom_Item_ID;
String Err = null;
string scond = " and "+ m_InvoiceDB.DocInvoice+ "_ShopC_Item.dQuantity > 0";
if (m_InvoiceDB.Read_DocInvoice_Atom_Item_Stock_Table(m_InvoiceDB.m_CurrentInvoice.Doc_ID, m_Atom_Item_ID, ref dt_DocInvoice_Atom_Item_Stock_view, scond,ref Err))
{
if (dt_DocInvoice_Atom_Item_Stock_view.Rows.Count > 0)
{
dgv_DocInvoice_Atom_Item_Stock.DataSource = dt_DocInvoice_Atom_Item_Stock_view;
DBSync.DBSync.DB_for_Tangenta.t_DocInvoice_ShopC_Item.SetView_DataGridViewImageColumns_Headers((DataGridView)dgv_DocInvoice_Atom_Item_Stock);
foreach (DataGridViewColumn c in dgv_DocInvoice_Atom_Item_Stock.Columns)
{
c.Visible = false;
}
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_ID"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_ID"].DisplayIndex = 0;
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_ID"].HeaderText = lngRPM.s_Stock_ID.s;
dgv_DocInvoice_Atom_Item_Stock.Columns["dQuantity"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["dQuantity"].DisplayIndex = 1;
dgv_DocInvoice_Atom_Item_Stock.Columns["dQuantity"].HeaderText = lngRPM.s_Quantity.s;
dgv_DocInvoice_Atom_Item_Stock.Columns["ExpiryDate"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["ExpiryDate"].DisplayIndex = 2;
dgv_DocInvoice_Atom_Item_Stock.Columns["ExpiryDate"].HeaderText = lngRPM.s_ExpiryDate.s;
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_dQuantity"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_dQuantity"].DisplayIndex = 3;
dgv_DocInvoice_Atom_Item_Stock.Columns["Stock_dQuantity"].HeaderText = lngRPM.s_Stock_dQuantity.s;
dgv_DocInvoice_Atom_Item_Stock.Columns["PurchasePricePerUnit"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["PurchasePricePerUnit"].DisplayIndex = 4;
dgv_DocInvoice_Atom_Item_Stock.Columns["PurchasePricePerUnit"].HeaderText = lngRPM.s_PurchasePricePerUnit.s;
dgv_DocInvoice_Atom_Item_Stock.Columns["RetailPricePerUnit"].Visible = true;
dgv_DocInvoice_Atom_Item_Stock.Columns["RetailPricePerUnit"].DisplayIndex = 5;
dgv_DocInvoice_Atom_Item_Stock.Columns["RetailPricePerUnit"].HeaderText = lngRPM.s_RetailPricePerUnit.s;
int iCol_Stock_ExpiryDate =dt_DocInvoice_Atom_Item_Stock_view.Columns.IndexOf("Stock_ExpiryDate");
int iCol_ExpiryDate = dt_DocInvoice_Atom_Item_Stock_view.Columns.IndexOf("ExpiryDate");
int iCount = dt_DocInvoice_Atom_Item_Stock_view.Rows.Count;
for (int i =0;i<iCount;i++)
{
DataRow dria = dt_DocInvoice_Atom_Item_Stock_view.Rows[i];
Atom_DocInvoice_ShopC_Item_Price_Stock_Data appisd = new Atom_DocInvoice_ShopC_Item_Price_Stock_Data();
appisd.Set(m_InvoiceDB.DocInvoice, dria,ref appisd_List);
if (dria[iCol_Stock_ExpiryDate] is DateTime)
{
dria[iCol_ExpiryDate] = dria[iCol_Stock_ExpiryDate];
}
}
Atom_DocInvoice_ShopC_Item_Price_Stock_Data xappisd= (Atom_DocInvoice_ShopC_Item_Price_Stock_Data)appisd_List[0];
this.txt_Atom_Item_Name.Text = xappisd.Atom_Item_Name_Name.v;
if (xappisd.Atom_Item_Description_Description != null)
{
this.txt_V_Atom_Item_Description.Text = xappisd.Atom_Item_Description_Description.v;
}
else
{
this.txt_V_Atom_Item_Description.Text = "";
txt_V_Atom_Item_Description.BackColor = Color_null;
}
decimal FromFactory_Count_sum = 0;
decimal FromStock_Count_sum = 0;
decimal CountAll = 0;
FromFactory_Count_sum = xappisd.m_ShopShelf_Source.dQuantity_from_factory;
FromStock_Count_sum = xappisd.m_ShopShelf_Source.dQuantity_from_stock;
CountAll = FromFactory_Count_sum + FromStock_Count_sum;
this.txt_V_FromFactory.Text = FromFactory_Count_sum.ToString();
this.txt_V_FromStock.Text = FromStock_Count_sum.ToString();
this.lbl_V_Quantity.Text = CountAll.ToString();
if (xappisd.Atom_Expiry_ExpiryDescription != null)
{
this.txt_V_ExpiryDescription.Text = xappisd.Atom_Expiry_ExpiryDescription.v;
}
else
{
this.txt_V_ExpiryDescription.Text = "";
txt_V_ExpiryDescription.BackColor = Color_null;
}
if (xappisd.Atom_Warranty_WarrantyConditions != null)
{
this.txt_V_WarrantyConditions.Text = xappisd.Atom_Warranty_WarrantyConditions.v;
}
else
{
this.txt_V_WarrantyConditions.Text = "";
txt_V_WarrantyConditions.BackColor = Color_null;
}
if (xappisd.Atom_Expiry_ID != null)
{
chk_V_NeverExpires.Checked = true;
chk_V_NeverExpires.Enabled = true;
}
else
{
chk_V_NeverExpires.BackColor = Color_null;
chk_V_NeverExpires.Checked = false;
chk_V_NeverExpires.Enabled = false;
}
if (xappisd.Atom_Warranty_ID != null)
{
chk_V_Warranty.Enabled = true;
chk_V_Warranty.Checked = true;
}
else
{
chk_V_Warranty.BackColor = Color_null;
chk_V_Warranty.Enabled = false;
chk_V_Warranty.Checked = false;
}
if ((xappisd.Atom_Warranty_WarrantyDurationType != null) && (xappisd.Atom_Warranty_WarrantyDuration != null))
{
this.lbl_V_WarantyDuration.Text = m_InvoiceDB.SetWarrantyDurationText(xappisd.Atom_Warranty_WarrantyDurationType.v, xappisd.Atom_Warranty_WarrantyDuration.v);
}
else
{
this.lbl_V_WarantyDuration.Text = "";
lbl_V_WarantyDuration.BackColor = Color_null;
}
if (xappisd.Atom_Expiry_ExpectedShelfLifeInDays != null)
{
this.lbl_V_ExpectedShelfLifeInDays.Text = xappisd.Atom_Expiry_ExpectedShelfLifeInDays.v.ToString();
}
else
{
this.lbl_V_ExpectedShelfLifeInDays.Text = "";
lbl_V_ExpectedShelfLifeInDays.BackColor = Color_null;
}
if (xappisd.Atom_Expiry_SaleBeforeExpiryDateInDays != null)
{
this.lbl_V_SaleBeforeExpiryDateInDays.Text = xappisd.Atom_Expiry_SaleBeforeExpiryDateInDays.v.ToString();
}
else
{
this.lbl_V_SaleBeforeExpiryDateInDays.Text = "";
lbl_V_SaleBeforeExpiryDateInDays.BackColor = Color_null;
}
if (xappisd.Atom_Expiry_DiscardBeforeExpiryDateInDays != null)
{
this.lbl_V_DiscardBeforeExpiryDateInDays.Text = xappisd.Atom_Expiry_DiscardBeforeExpiryDateInDays.v.ToString();
}
else
{
this.lbl_V_DiscardBeforeExpiryDateInDays.Text = "";
lbl_V_DiscardBeforeExpiryDateInDays.BackColor = Color_null;
}
if (xappisd.Atom_Taxation_Name != null)
{
this.lbl_V_Taxation_Name.Text = xappisd.Atom_Taxation_Name.v;
}
else
{
this.lbl_V_Taxation_Name.Text = "";
lbl_V_Taxation_Name.BackColor = Color_null;
}
if (xappisd.Atom_Taxation_Rate != null)
{
this.lbl_V_Taxation_Rate.Text = (xappisd.Atom_Taxation_Rate.v * 100).ToString() + "%";
}
else
{
this.lbl_V_Taxation_Rate.Text = "";
lbl_V_Taxation_Rate.BackColor = Color_null;
}
if (xappisd.Atom_Item_barcode_barcode != null)
{
this.txt_barcode_value.Text = xappisd.Atom_Item_barcode_barcode.v;
}
else
{
this.txt_barcode_value.Text = "";
this.txt_barcode_value.BackColor = Color_null;
}
//Price
decimal RetailPricePerUnit = -1;
if (xappisd.RetailPricePerUnit != null)
{
lbl_V_RetailPricePerUnit.Text = xappisd.RetailPricePerUnit.v.ToString();
RetailPricePerUnit = xappisd.RetailPricePerUnit.v;
}
else
{
lbl_V_RetailPricePerUnit.Text = "";
lbl_V_RetailPricePerUnit.BackColor = Color_null;
}
decimal RetailPrice = -1;
if (RetailPricePerUnit>=0)
{
RetailPrice = RetailPricePerUnit*CountAll;
}
decimal discount = 0;
if (xappisd.Discount != null)
{
discount = xappisd.Discount.v;
lbl_V_Discount.Text = (discount * 100).ToString() + "%";
}
else
{
lbl_V_Discount.Text = "";
lbl_V_Discount.BackColor = Color_null;
}
decimal RetailPriceWithDiscount = -1;
if (RetailPrice >= 0)
{
RetailPriceWithDiscount = RetailPrice * (1- discount);
lbl_V_RetailPriceWithDiscount.Text = RetailPriceWithDiscount.ToString();
}
else
{
lbl_V_RetailPriceWithDiscount.Text = "";
lbl_V_RetailPriceWithDiscount.BackColor = Color_null;
}
decimal TaxPrice = -1;
decimal TaxPricePerUnit = -1;
if (xappisd.TaxPrice != null)
{
TaxPricePerUnit = xappisd.TaxPrice.v;
}
if (TaxPricePerUnit >= 0)
{
TaxPrice = TaxPricePerUnit * CountAll;
lbl_V_TaxPrice.Text = TaxPrice.ToString();
}
else
{
lbl_V_TaxPrice.Text = "";
lbl_V_TaxPrice.BackColor = Color_null;
}
decimal NetPrice = -1;
if ((RetailPriceWithDiscount >= 0) && (TaxPrice >= 0))
{
NetPrice = RetailPriceWithDiscount - TaxPrice;
lbl_V_NetPrice.Text = NetPrice.ToString();
}
else
{
lbl_V_NetPrice.Text = "";
lbl_V_NetPrice.BackColor = Color_null;
}
string sql_get_image = "select Atom_Item_ImageLib.Image_Data from Atom_Item_ImageLib inner join Atom_Item_Image on Atom_Item_Image.Atom_Item_ImageLib_ID = Atom_Item_ImageLib.ID where Atom_Item_Image.Atom_Item_ID = " + xappisd.Atom_Item_ID.v.ToString();
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql_get_image, null, ref Err))
{
if (dt.Rows.Count > 0)
{
ImageConverter ic = new ImageConverter();
byte[] image_bytes = (byte[])dt.Rows[0]["Image_Data"];
this.pic_Atom_Item.Image = (Image)ic.ConvertFrom(image_bytes);
}
}
return true;
}
else
{
LogFile.Error.Show("ERROR:usrc_Atom_Item_View:Init:No Atom_Item data for Atom_Item_ID = " + m_Atom_Item_ID.ToString());
return false;
}
}
else
{
LogFile.Error.Show("ERROR:Atom_Item_ViewForm_Load:Err=" + Err);
return false;
}
}
public Form_Atom_Item_View(TangentaDB.ShopABC xInvoiceDB,long xAtom_Item_ID)
{
InitializeComponent();
m_InvoiceDB = xInvoiceDB;
m_Atom_Item_ID = xAtom_Item_ID;
}
public InvoiceData(TangentaDB.ShopABC xInvoiceDB, long xDocProformaInvoice_ID, bool xb_FVI_SLO, string xCasshierName)
{
m_ShopABC = xInvoiceDB;
DocInvoice_ID = xDocProformaInvoice_ID;
if (IsDocInvoice)
{
AddOnDI = new DocInvoice_AddOn();
AddOnDI.m_FURS.Invoice_FURS_Token = new UniversalInvoice.Invoice_FURS_Token();
AddOnDI.b_FVI_SLO = xb_FVI_SLO;
}
CasshierName = xCasshierName;
}
