public Form_ShopC_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, Control xParentControl)
{
InitializeComponent();
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
ID_v = new long_v();
ID_v.v = ID;
ParentControl = xParentControl;
if (ParentControl != null)
{
if (ParentControl is usrc_StockEditForSelectedStockTake)
{
m_usrc_StockEditForSelectedStockTake = (usrc_StockEditForSelectedStockTake)ParentControl;
}
}
this.Text = lngRPM.s_Items.s;
rdb_OnlyInOffer.Checked = true;
lngRPM.s_OnlyInOffer.Text(this.rdb_OnlyInOffer);
lngRPM.s_AllItems.Text(this.rdb_All);
lngRPM.s_OnlyNotInOffer.Text(this.rdb_OnlyNotInOffer);
if (nav==null)
{
nav = new NavigationButtons.Navigation();
nav.m_eButtons = NavigationButtons.Navigation.eButtons.OkCancel;
nav.eExitResult = NavigationButtons.Navigation.eEvent.NOTHING;
usrc_NavigationButtons1.Init(nav);
}
}
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 override void FillCodeTable(IPageStyle style)
{
TkDebug.AssertArgumentNull(style, "style", this);
if (style.Style == PageStyle.List)
{
var queryCodeTables = (from field in CurrentSchemeEx.Fields
let tk5Field = field as ITk5FieldInfo
where IsQueryField(tk5Field)
select tk5Field.Decoder.RegName).Distinct().ToArray();
if (queryCodeTables.Length == 0)
{
return;
}
InitializeCodeTable(style);
foreach (string regName in queryCodeTables)
{
CodeTable code = CodeTables.GetFilledCodeTable(regName);
if (code != null)
{
code.Fill(HostDataSet, Context);
}
}
}
else
{
base.FillCodeTable(style);
}
}
public Form_StockTake_Edit(Navigation xnav, CodeTables.DBTableControl xdbTables)
{
InitializeComponent();
this.nav = xnav;
dbTables = xdbTables;
this.Text = lngRPM.s_EditStockTakeItems.s;
usrc_EditTable1.Text(lngRPM.s_EditStockTake);
}
public Form_DBSettings_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
lngRPM.s_DBSettings.Text(this);
}
public Form_PersonData_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy,NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
this.Text = lngRPM.s_Customers_Person.s;
}
public Form_OrganisationAccount_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
this.Text = lngRPM.s_OrganisationAccount.s;
}
public Form_myOrg_Edit(CodeTables.DBTableControl xdbTables,SQLTable xtbl,bool bAllowNew, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
this.usrc_NavigationButtons1.Init(nav);
dbTables = xdbTables;
tbl = xtbl;
usrc_EditRow.AllowUserToAddNew = bAllowNew;
lngRPM.s_Edit_Offices.Text(btn_Office);
}
public PersonAccount_EditForm(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID)
{
InitializeComponent();
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
ID_v = new long_v();
ID_v.v = ID;
this.Text = lngRPM.s_Items.s;
}
private static Column FindColumn(CodeTables.SQLTable tbl,string column_name)
{
foreach (Column col in tbl.Column)
{
if (col.Name.Equals(column_name))
{
return col;
}
}
return null;
}
public Form_PersonData_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
ID_v = new long_v();
ID_v.v = ID;
this.Text = lngRPM.s_Items.s;
}
public Form_Customer_Person_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID)
{
InitializeComponent();
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
ID_v = new long_v();
ID_v.v = ID;
this.Text = lngRPM.s_Items.s;
this.usrc_EditTable.Title = xtbl.lngTableName.s;
}
public Form_ShopAItem_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string ColumnToOrderBy)
{
InitializeComponent();
dbTables = xdbTables;
tbl = xtbl;
this.Text = lngRPM.s_ShopB_Items.s;
if (!usrc_EditTable.Init(dbTables, tbl,null,ColumnToOrderBy,false,null,null,false,null))
{
bclose = true;
}
}
public void SetUp()
{
mockExceptionHandling = new Mock <IExceptionHandling>();
mockDataAccess = new Mock <IDataAccess>();
mockExceptionHandling
.Setup(x => x.LogException(It.IsAny <Exception>(), ExceptionPolicy.Web_Exception))
.Verifiable();
codeTables = new CodeTables(mockDataAccess.Object, mockExceptionHandling.Object);
}
public Form_Templates(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
this.Text = lngRPM.s_Items.s;
rdb_OnlyInOffer.Checked = true;
this.rdb_OnlyInOffer.Text = lngRPM.s_OnlyInOffer.s;
this.rdb_All.Text = lngRPM.s_AllItems.s;
this.rdb_OnlyNotInOffer.Text = lngRPM.s_OnlyNotInOffer.s;
}
public Form_ShopC_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
dbTables = xdbTables;
tbl = xtbl;
usrc_NavigationButtons1.Init(nav);
ColumnOrderBy = xColumnOrderBy;
lngRPM.s_Items.Text(this, " "+lngRPM.s_Shop_C.s);
rdb_OnlyInOffer.Checked = true;
lngRPM.s_OnlyInOffer.Text(this.rdb_OnlyInOffer);
lngRPM.s_AllItems.Text(this.rdb_All);
lngRPM.s_OnlyNotInOffer.Text(this.rdb_OnlyNotInOffer);
}
public Price_Undefined_Window(string sTitle,DataTable xdt_price_Item_view,CodeTables.DBTableControl xdbTables)
{
InitializeComponent();
this.Title = sTitle;
this.btn_Edit.Content = lngRPM.s_EditPriceList.s;
this.btn_Cancel.Content = lngRPM.s_Cancel.s;
dt_price_Item_view = xdt_price_Item_view;
dbTables = xdbTables;
this.dgvx_PriceUndefinedItem.ItemsSource = dt_price_Item_view.AsDataView();
tbl = new SQLTable(dbTables.GetTable(typeof(Atom_cAddress_Org)));
tbl.CreateTableTree(dbTables.items);
this.dgvx_PriceUndefinedItem.AutoGeneratedColumns +=dgvx_PriceUndefinedItem_AutoGeneratedColumns;
//this.dgvx_PriceUndefinedItem.Columns[0].Header =
}
public bool Init(CodeTables.DBTableControl dbTables,SQLTable tbl,ref string Err, NavigationButtons.Navigation xnav)
{
nav = xnav;
tbl.CreateTableTree(dbTables.items);
string selection = @"ID,
PurchasePrice_$$CreationDate,
PurchasePrice_$$Description,
PurchasePrice_$_Cur_$$Name,
PurchasePrice_$_Cur_$$Abbreviation,
PurchasePrice_$_Cur_$$Symbol,
PurchasePrice_$$Valid,
PurchasePrice_$$ValidFrom,
PurchasePrice_$$ValidTo
";
return usrc_EditTable_PurchasePriceList.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl,selection, "ID asc",false,null,null,false,nav);
}
public Form_ShopB_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string ColumnToOrderBy, NavigationButtons.Navigation xnav)
{
InitializeComponent();
m_bChanged = false;
dbTables = xdbTables;
nav = xnav;
tbl = xtbl;
lngRPM.s_Items.Text(this, " "+lngRPM.s_Shop_B.s);
List_of_Inserted_Items_ID = new List<long>();
rdb_OnlyInOffer.Checked = true;
lngRPM.s_OnlyInOffer.Text(this.rdb_OnlyInOffer);
lngRPM.s_AllItems.Text(this.rdb_All);
lngRPM.s_OnlyNotInOffer.Text(this.rdb_OnlyNotInOffer);
usrc_NavigationButtons1.Init(xnav);
string selection = " SimpleItem_$$Name,SimpleItem_$$Abbreviation,SimpleItem_$_siimg_$$Image_Data,SimpleItem_$_sipg1_$$Name,SimpleItem_$_sipg1_$_sipg2_$$Name,SimpleItem_$_sipg1_$_sipg2_$_sipg3_$$Name,SimpleItem_$$ToOffer,ID ";
if (!usrc_EditTable.Init(dbTables, tbl, selection, ColumnToOrderBy,false,null,null,false,nav))
{
bclose = true;
}
}
public static void SetVIEW_DataGridViewImageColumns_Headers(DataGrid dgvx, CodeTables.DBTableControl xdbTables,CodeTables.SQLTable tbl)
{
foreach (DataGridColumn col in dgvx.Columns)
{
Column c = FindColumn(tbl,(string)col.Header);
if (c != null)
{
col.Header = c.Name_in_language.s;
}
else
{
string sSeparator = SQLTable.VIEW_TableName2ColumnName_SEPARATOR;
int iSeparator_Length = sSeparator.Length;
string colName = (string)col.Header;
int iTableNameEnd = colName.IndexOf(sSeparator);
if (iTableNameEnd > 0)
{
string sTableName_Abbreviation = colName.Substring(0, iTableNameEnd);
string sColName = colName.Substring(iTableNameEnd + iSeparator_Length, colName.Length - iTableNameEnd - iSeparator_Length);
iSeparator_Length = SQLTable.VIEW_TableName_SEPARATOR.Length;
iTableNameEnd = sTableName_Abbreviation.LastIndexOf(SQLTable.VIEW_TableName_SEPARATOR);
if (iTableNameEnd > 0)
{
sTableName_Abbreviation = sTableName_Abbreviation.Substring(iTableNameEnd + iSeparator_Length, sTableName_Abbreviation.Length - iTableNameEnd - iSeparator_Length);
}
SQLTable xtbl = xdbTables.GetTable_from_TableName_Abbreviation(sTableName_Abbreviation);
if (xtbl != null)
{
Column cc = FindColumn(xtbl,sColName);
if (cc != null)
{
col.Header = cc.Name_in_language.s;
}
}
}
}
}
}
private bool usrc_EditTable_SimpleItem_RowReferenceFromTable_Check_NoChangeToOther(SQLTable pSQL_Table, List<usrc_RowReferencedFromTable> usrc_RowReferencedFromTable_List, CodeTables.ID_v id_v, ref bool bCancelDialog, ref ltext Instruction)
{
if (pSQL_Table.TableName.ToLower().Equals("taxation"))
{
if (pSQL_Table.pParentTable!=null)
{
if (pSQL_Table.pParentTable.TableName.ToLower().Equals("price_simpleitem"))
{
string sql = "select Name from Taxation where id = " + id_v.v.ToString();
DataTable dt = new DataTable();
string Err = null;
if (DBSync.DBSync.ReadDataTable(ref dt,sql,ref Err))
{
if (dt.Rows.Count>0)
{
string staxname = (string)dt.Rows[0]["Name"];
List<object> complex_text = new List<object>();
complex_text.Add(lngRPM.s_Tax_with_name);
complex_text.Add("\""+staxname +"\"");
complex_text.Add(lngRPM.s_belongs_to_many_other_trade_items_and_services);
complex_text.Add(lngRPM.s_If_you_want_to_change_the_tax_only_to_the_selected_article___);
if (Instruction == null)
{
Instruction = new ltext(complex_text);
}
else
{
Instruction.complex_text_list =complex_text;
}
}
}
else
{
LogFile.Error.Show("ERROR:usrc_PriceList_Edit:usrc_EditTable_SimpleItem_RowReferenceFromTable_Check_NoChangeToOther:\r\nsql=" + sql + "\r\nErr=" + Err);
}
}
}
}
bCancelDialog = false;
return false;
}
public Col_class(string sCol, string sVal, CodeTables.Column.Flags flags)
{
m_Flags = flags;
sColName = sCol;
sValue = sVal;
}
public void SetVIEW_DataGridViewImageColumns_Headers(DataGridView dgvx_Item, CodeTables.DBTableControl xdbTables)
{
foreach (DataGridViewColumn col in dgvx_Item.Columns)
{
Column c = this.FindColumn(col.Name);
if (c != null)
{
col.HeaderText = c.Name_in_language.s;
}
else
{
string sSeparator = VIEW_TableName2ColumnName_SEPARATOR;
int iSeparator_Length = sSeparator.Length;
int iTableNameEnd = col.Name.IndexOf(sSeparator);
if (iTableNameEnd > 0)
{
string sTableName = col.Name.Substring(0, iTableNameEnd);
string sColName = col.Name.Substring(iTableNameEnd + iSeparator_Length, col.Name.Length - iTableNameEnd - iSeparator_Length);
iSeparator_Length = VIEW_TableName_SEPARATOR.Length;
iTableNameEnd = sTableName.LastIndexOf(VIEW_TableName_SEPARATOR);
SQLTable tbl = null;
if (iTableNameEnd > 0)
{
sTableName = sTableName.Substring(iTableNameEnd + iSeparator_Length, sTableName.Length - iTableNameEnd - iSeparator_Length);
tbl = xdbTables.GetTable_from_TableName_Abbreviation(sTableName);
}
else
{
tbl = xdbTables.GetTable(sTableName);
}
if (tbl != null)
{
Column cc = tbl.FindColumn(sColName);
if (cc != null)
{
col.HeaderText = cc.Name_in_language.s;
}
}
}
}
}
}
private bool sql_check_if_not_unique_parameter(DBTableControl dbTables, CodeTables.Column col, List<SQL_Parameter> sqlParamList, string sqlite_set, object value, ref string Err)
{
if ((col.flags & CodeTables.Column.Flags.UNIQUE) != 0)
{
// check if not unique parameter
DataTable dt = new DataTable();
string sql_check = "select ID," + col.Name + " from " + this.TableName + " where " + sqlite_set;
if (dbTables.m_con.ReadDataTable(ref dt, sql_check, sqlParamList, ref Err))
{
if (dt.Rows.Count > 0)
{
bool bHandled = false;
if (this.myGroupBox != null)
{
this.myGroupBox.Unique_parameter_exist_Dialog_EventTrigger(this, col, dt, value,ref bHandled);
}
if (!bHandled)
{
//string sText=null;
string sValue = GetString(value);
if (sValue!=null)
{
MessageBox.Show(lngRPM.s_Data_in_Column.s + ":" + col.Name_in_language.s + " (" + col.Name + ") " + lngRPM.s_In_Table.s + " " + this.lngTableName.s + " (" + this.TableName + ") " + lngRPM.s_MustBeUnique.s + ".\r\n" + lngRPM.s_Value.s + ":" + sValue + " " + lngRPM.s_AllreadyExistForTable.s + " " +this.lngTableName.s + " (" + this.TableName + ") ");
}
else
{
MessageBox.Show(lngRPM.s_Data_in_Column.s + ":" + col.Name_in_language.s + " (" + col.Name + ") " + " " + lngRPM.s_In_Table.s +" " + this.lngTableName.s + " (" + this.TableName + ") " + lngRPM.s_MustBeUnique.s);
}
}
return false;
}
}
else
{
LogFile.Error.Show("ERROR:SQLTable.Update.cs:sql_check_if_not_unique_parameter:sql=" + sql_check + "\r\nErr=" + Err);
return false;
}
}
return true;
}
private bool usrc_EditTable_RowReferenceFromTable_Check_NoChangeToOther(CodeTables.SQLTable pSQL_Table, System.Collections.Generic.List<CodeTables.usrc_RowReferencedFromTable> usrc_RowReferencedFromTable_List, CodeTables.ID_v id_v, ref bool bCancelDialog, ref ltext Instruction)
{
bCancelDialog = false;
return false;
}
private bool m_usrc_EditTable_RowReferenceFromTable_Check_NoChangeToOther(SQLTable pSQL_Table, List<usrc_RowReferencedFromTable> usrc_RowReferencedFromTable_List, CodeTables.ID_v id_v, ref bool bCancelDialog, ref ltext Instruction)
{
bCancelDialog = true;
if (pSQL_Table.TableName.Equals("Stock"))
{
return false;
}
else
{
return true;
}
}
