private void usrc_EditTable_after_InsertInDataBase(SQLTable m_tbl, long ID, bool bRes)
{
if (bRes)
{
}
}
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 bool StartThread(SQLTable tbl,Control pControl)
{
VirtualSecretaryThread = new Thread(VirtualSecretaryJob);
VirtualSecretary_ThreadParam scp = new VirtualSecretary_ThreadParam(tbl, pControl);
VirtualSecretaryThread.Start(scp);
return true;
}
public Form_myOrg_Person_Edit(long xOffice_ID,NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
usrc_NavigationButtons1.Init(nav);
m_Office_ID = xOffice_ID;
tbl_myOrganisation_Person = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(myOrganisation_Person)));
lngRPM.s_myOrganisation_Person_Data.Text(this);
this.Icon = Properties.Resources.Person;
this.usrc_EditTable1.Title = lngRPM.s_Edit_Office_Data.s;
string selection = @" myOrganisation_Person_$_per_$_cfn_$$FirstName,
myOrganisation_Person_$_per_$_cln_$$LastName,
myOrganisation_Person_$_per_$$DateOfBirth,
myOrganisation_Person_$_per_$$Tax_ID,
myOrganisation_Person_$_per_$$Registration_ID,
myOrganisation_Person_$_office_$_mo_$_orgd_$_org_$$Name,
myOrganisation_Person_$_office_$$Name,
myOrganisation_Person_$_office_$$ShortName,
ID
";
long_v Office_ID_v = null;
if (m_Office_ID >= 0)
{
Office_ID_v = new long_v(m_Office_ID);
}
if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_myOrganisation_Person, selection, ColumnToOrderBy, false, " where myOrganisation_Person_$_office_$$ID = " + m_Office_ID.ToString() + " ", null, false,nav))
{
usrc_EditTable1.FillInitialData();
}
else
{
bclose = true;
}
}
public Form_Tool_SelectItem(Atom_ItemShopA xAtom_ItemShopA, usrc_Editor xusrc_Editor)
{
InitializeComponent();
m_Atom_ItemShopA = xAtom_ItemShopA;
m_usrc_Editor = xusrc_Editor;
t_Atom_ItemShopA = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Atom_ItemShopA)));
}
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;
}
}
// function creates DefineView_InputControls but does not bind them with xml data !
public void Create_DefineView_InputControls(SQLTable pPrevTable, string sParentKeys, ref List<DefineView_InputControl> inpCtrlList, Object pParentWindow, Form pForm,ref int iCtrl)
{
int iCol = 0;
int iCount = Column.Count();
this.pParentTable = pPrevTable;
for (iCol = 0; iCol < iCount; iCol++)
{
Column col = Column[iCol];
if (!col.IsIdentity)
{
if (col.fKey != null)
{
string sKey;
sKey = sParentKeys + "*" + col.fKey.refInListOfTables.TableName + ">";
col.fKey.fTable.Create_DefineView_InputControls(this, sKey, ref inpCtrlList, this.DefineView_GroupBox, pForm, ref iCtrl);
}
else
{
string sImportExportLine;
DefineView_InputControl inpCtrl;
sImportExportLine = sParentKeys + col.Name;
inpCtrl = new DefineView_InputControl(col, inpCtrlList, sImportExportLine, true, ref iCtrl);
col.DefineView_InputControl = inpCtrl;
inpCtrlList.Add(inpCtrl);
}
}
}
}
public Form_myOrg_Office(NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
usrc_NavigationButtons1.Init(nav);
lngRPM.s_Edit_Office_Data.Text(btn_Office_Data_And_FVI_SLO_RealEstateBP);
if (myOrg.ID_v != null)
{
myOrganisation_ID = myOrg.ID_v.v;
tbl_Office = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Office)));
this.Text = lngRPM.s_Edit_Offices.s;
this.usrc_EditTable1.Title = lngRPM.s_Edit_Offices.s;
long_v myOrganisation_ID_v = new long_v(myOrganisation_ID);
string selection = "Office_$$Name,Office_$$ShortName,Office_$_mo_$_orgd_$_org_$$Name,Office_$_mo_$_orgd_$_orgt_$$OrganisationTYPE,Office_$_mo_$_orgd_$_org_$$Tax_ID,ID";
string where_condition = " where Office_$_mo_$$ID = " + myOrganisation_ID.ToString() + " ";
if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_Office, selection, ColumnToOrderBy, false, null, null, false,nav))
{
usrc_EditTable1.FillInitialData();
}
else
{
bclose = true;
}
}
else
{
LogFile.Error.Show("ERROR:Tangenta:Form_myOrg_Offices_Edit():myOrg.ID_v is not defined!");
bclose = true;
}
}
//this constructor is used only for DBm_Image and DBm_Document table trees
public Column(Column c,SQLTable DBm_owner_Table,List<SQLTable> lTable)
{
obj = SetObject(c.obj);
nulltype = c.nulltype;
Style = c.Style;
flags = c.flags;
IsIdentity = c.IsIdentity;
ownerTable = c.ownerTable;
Name = c.Name;
// Value = c.Value;
//SetType = c.SetType;
if (c.fKey != null)
{
fKey = new ForeignKey(c.fKey, DBm_owner_Table, lTable);
}
Name_in_language = c.Name_in_language;
//Name_in_language = new ltext();
//int iCount = c.Name_in_language.sText.Length;
//for (int i = 0; i < iCount;i++)
//{
// Name_in_language.sText(i) = c.Name_in_language.sText(i);
//}
}
public usrc_RowReferencedFromTable_List_Dialog(List<usrc_RowReferencedFromTable> x_usrc_RowReferencedFromTable_List,SQLTable x_tbl,long x_id, ltext xInstruction)
{
InitializeComponent();
Instruction = xInstruction;
m_usrc_RowReferencedFromTable_List = x_usrc_RowReferencedFromTable_List;
m_tbl = x_tbl;
id = x_id;
if (m_usrc_RowReferencedFromTable_List!=null)
{
int y = 0;
foreach (usrc_RowReferencedFromTable x_usrc_RowReferencedFromTable in m_usrc_RowReferencedFromTable_List)
{
x_usrc_RowReferencedFromTable.Top = y;
x_usrc_RowReferencedFromTable.Left = 2;
x_usrc_RowReferencedFromTable.BorderStyle = BorderStyle.Fixed3D;
x_usrc_RowReferencedFromTable.Width = pnl_usrc_RowReferencedTable_List.Width - 4;
x_usrc_RowReferencedFromTable.Anchor = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right;
x_usrc_RowReferencedFromTable.Visible = true;
pnl_usrc_RowReferencedTable_List.Controls.Add(x_usrc_RowReferencedFromTable);
y += x_usrc_RowReferencedFromTable.Height + 2;
}
}
this.btn_Yes.Text = lngRPM.s_Yes.s;
this.btn_No.Text = lngRPM.s_No.s;
}
public EditTable_Form(DBTableControl dbTables, SQLTable tbl, TableDockingForm dtF,Globals.delegate_SetControls xSetControls, bool bReadOnly,NavigationButtons.Navigation xnav)
{
m_TableDockingForm = dtF;
this.Icon = Properties.Resources.SmallEditIcon;
InitializeComponent();
this.Text = lngRPM.s_EditTable.s + tbl.lngTableName.s + " (" + tbl.TableName + ")";
usrc_EditRow.Init(dbTables, tbl, xSetControls, bReadOnly,xnav);
}
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;
}
internal bool Do_Form_Stock_Edit()
{
SQLTable tbl_Stock = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Stock)));
//SQLTable tbl_Item = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Item)));
Form_Stock_Edit edt_Stock_dlg = new Form_Stock_Edit(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
tbl_Stock,
"Stock_$_ppi_$_i_$$Code asc", nav);
edt_Stock_dlg.ShowDialog();
return edt_Stock_dlg.Changed;
}
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;
}
internal bool Edit_OrganisationAccount()
{
SQLTable tbl_OrganisationAccount = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(OrganisationAccount)));
Form_OrganisationAccount_Edit edt_Item_dlg = new Form_OrganisationAccount_Edit(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
tbl_OrganisationAccount,
" OrganisationAccount_$_org_$$Name desc",nav);
edt_Item_dlg.ShowDialog();
Init();
return true;
}
internal bool Edit_OrganisationData()
{
SQLTable tbl_OrganisationData = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(OrganisationData)));
OrganisationData_EditForm edt_Item_dlg = new OrganisationData_EditForm(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
tbl_OrganisationData,
" OrganisationData_$_org_$$Name desc",nav);
edt_Item_dlg.ShowDialog();
Init();
return true;
}
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 Join_for_SQLView_InDataBase(SQLTable xtbl,string xTableName,string xTableName_Abbreviation, string xAliasTableName, string xParam_ID1, string xParam_ID2, Column.nullTYPE xnulltype)
{
tbl = xtbl;
nulltype = xnulltype;
TableName = xTableName;
TableName_Abbreviation = xTableName_Abbreviation;
AliasTableName = xAliasTableName;
Param_ID1 = xParam_ID1;
Param_ID2 = xParam_ID2;
pSubJoin = 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 void Init(SQLTable x_tbl, SQLTable x_tbl_referenced, long x_tbl_referenced_ID, DataTable x_dt)
{
m_tbl = x_tbl;
this.txt_TableName.Text = m_tbl.lngTableName.s;
m_dt = x_dt;
m_tbl_referenced = x_tbl_referenced;
m_tbl_referenced_ID = x_tbl_referenced_ID;
this.txt_ReferencedTableRow.Text = m_tbl_referenced.lngTableName.s + " ID = " + m_tbl_referenced_ID.ToString();
dgvx_References.DataSource = m_dt;
m_tbl.Set_DataGridViewImageColumns_Headers(dgvx_References);
}
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 ForeignKey(ForeignKey srcfKey)
{
ID_ForeignKey = srcfKey.ID_ForeignKey;
ReferenceTable = srcfKey.ReferenceTable;
brefTableID = srcfKey.brefTableID;
refInListOfTables = srcfKey.refInListOfTables;
if (srcfKey.refInListOfTables != null)
{
fTable = new SQLTable(srcfKey.refInListOfTables);
}
ReferenceTable_Column = srcfKey.ReferenceTable_Column;
}
public SelectID_Table_Assistant_Form(string sql, SQLTable tbl, DBTableControl xDBTables, string[] xsCoumnsToView)
{
InitializeComponent();
m_sql = sql;
m_DBTables = xDBTables;
m_tbl = tbl;
this.Text = tbl.lngTableName.s + " (" + tbl.TableName + ")";
string csError = "";
ColumnToView = xsCoumnsToView;
FillDataTable(ref csError);
this.btn_Cancel.Text = lngRPM.s_Cancel.s;
}
public ForeignKey(ForeignKey srcfKey, SQLTable DBm_owner_Tabel,List<SQLTable> lTable)
{
ID_ForeignKey = srcfKey.ID_ForeignKey;
ReferenceTable = srcfKey.ReferenceTable;
brefTableID = srcfKey.brefTableID;
refInListOfTables = srcfKey.refInListOfTables;
if (srcfKey.refInListOfTables != null)
{
fTable = new SQLTable(srcfKey.refInListOfTables, DBm_owner_Tabel, lTable);
lTable.Add(fTable);
}
ReferenceTable_Column = srcfKey.ReferenceTable_Column;
}
public DataTable_Form(DBTableControl dbTables, SQLTable tbl, DataTable_Form_ENUM eMode, TableDockingForm pForm)
{
//m_DB = pDB;
m_DBTables = dbTables;
m_Mode = eMode;
m_tbl = tbl;
m_TableDockingForm = pForm;
this.Icon = Properties.Resources.table;
InitializeComponent();
SetControls(m_tbl);
}
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);
}
