public CurrentInvoice(ShopABC xInvoiceDB, DBTablesAndColumnNames xDBtcn)
{
m_InvoiceDB = xInvoiceDB;
DBtcn = xDBtcn;
FinancialYear = DateTime.Now.Year;
NumberInFinancialYear = 1;
Doc_ID = -1;
}
public ShopABC(DBTablesAndColumnNames xDBtcn)
{
m_CurrentInvoice = new CurrentInvoice(this, xDBtcn);
td = DBSync.DBSync.DB_for_Tangenta.mt;
DBtcn = xDBtcn;
}
public static bool Init_DB_SimpleItem(ref string Err)
{
DBTablesAndColumnNames DBtcn = new DBTablesAndColumnNames();
string s_SimpleItem_Image_table_name = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem_Image)).TableName;
string s_SimpleItem_table_name = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).TableName;
string s_Image_Hash = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem_Image)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem_Image.Image_Hash.GetType()).Name;
string s_Image_Data = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem_Image)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem_Image.Image_Data.GetType()).Name;
string s_col_Name = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem.Name.GetType()).Name;
string s_col_Code = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem.Code.GetType()).Name;
string s_col_Abbreviation = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem.Abbreviation.GetType()).Name;
string s_col_SimpleItemImage_ID = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem.m_SimpleItem_Image.GetType()).Name;
string s_col_ToOffer = DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(TangentaTableClass.SimpleItem)).FindColumn(DBSync.DBSync.DB_for_Tangenta.mt.m_SimpleItem.ToOffer.GetType()).Name;
foreach (TangentaTableClass.Price_SimpleItem pl_SimpleItem in m_List_Price_SimpleItem)
{
List<DBConnectionControl40.SQL_Parameter> lsql_par = null;
Byte[] Image_Data = null;
string Image_Hash = "null";
if (pl_SimpleItem.m_SimpleItem.Abbreviation.val.Equals("PED"))
{
lsql_par = new List<DBConnectionControl40.SQL_Parameter>();
//Image_Data = ImageToByte2(Properties.Resources.Pedikira);
Image_Hash = DBtypesFunc.GetHash_SHA1(Image_Data);
DBConnectionControl40.SQL_Parameter sql_par = new DBConnectionControl40.SQL_Parameter("@image", SQL_Parameter.eSQL_Parameter.Varbinary, false, Image_Data);
sql_par.SQLiteDbType = System.Data.DbType.Binary;
DBConnectionControl40.SQL_Parameter sql_par_hash = new DBConnectionControl40.SQL_Parameter("@hash", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Image_Hash);
sql_par_hash.SQLiteDbType = System.Data.DbType.AnsiString;
lsql_par.Add(sql_par);
lsql_par.Add(sql_par_hash);
}
else if (pl_SimpleItem.m_SimpleItem.Abbreviation.val.Equals("MAN"))
{
lsql_par = new List<DBConnectionControl40.SQL_Parameter>();
//Image_Data = ImageToByte2(Properties.Resources.Manikira);
Image_Hash = DBtypesFunc.GetHash_SHA1(Image_Data);
// DBConnectionControl40.SQL_Parameter sql_par = new DBConnectionControl40.SQL_Parameter("@image", SQL_Parameter.eSQL_Parameter.Varbinary, false, ImageToByte2(Properties.Resources.Manikira));
//sql_par.SQLiteDbType = System.Data.DbType.Binary;
DBConnectionControl40.SQL_Parameter sql_par_hash = new DBConnectionControl40.SQL_Parameter("@hash", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Image_Hash);
sql_par_hash.SQLiteDbType = System.Data.DbType.AnsiString;
//lsql_par.Add(sql_par);
lsql_par.Add(sql_par_hash);
}
else if (pl_SimpleItem.m_SimpleItem.Abbreviation.val.Equals("NOB"))
{
lsql_par = new List<DBConnectionControl40.SQL_Parameter>();
//Image_Data = ImageToByte2(Properties.Resources.Nega_Obraza);
Image_Hash = DBtypesFunc.GetHash_SHA1(Image_Data);
DBConnectionControl40.SQL_Parameter sql_par = new DBConnectionControl40.SQL_Parameter("@image", SQL_Parameter.eSQL_Parameter.Varbinary, false, Image_Data);
DBConnectionControl40.SQL_Parameter sql_par_hash = new DBConnectionControl40.SQL_Parameter("@hash", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Image_Hash);
sql_par_hash.SQLiteDbType = System.Data.DbType.AnsiString;
sql_par.SQLiteDbType = System.Data.DbType.Binary;
lsql_par.Add(sql_par);
lsql_par.Add(sql_par_hash);
}
string[] sColumn = null;
string[] sValue = null;
if (lsql_par != null)
{
long SimpleItem_Image_ID = -1;
if (!fs.GetID(s_SimpleItem_Image_table_name,new string[]{s_Image_Hash,s_Image_Data},new string[]{"@hash","@image"},lsql_par,ref SimpleItem_Image_ID,ref Err))
{
LogFile.Error.Show("ERROR:Init_DB_SimpleItem:insert into SimpleItem_Image:Err=" + Err);
return false;
}
sColumn = new string[] { s_col_Name, s_col_Code, s_col_Abbreviation, s_col_SimpleItemImage_ID, s_col_ToOffer };
sValue = new string[] { "'" + pl_SimpleItem.m_SimpleItem.Name.val + "'",
pl_SimpleItem.m_SimpleItem.Code.val.ToString(),
"'"+ pl_SimpleItem.m_SimpleItem.Abbreviation.val + "'",
SimpleItem_Image_ID.ToString(),
"1"
};
}
else
{
sColumn = new string[] { s_col_Name, s_col_Code, s_col_Abbreviation, s_col_ToOffer };
sValue = new string[] { "'" + pl_SimpleItem.m_SimpleItem.Name.val + "'",
pl_SimpleItem.m_SimpleItem.Code.val.ToString(),
"'"+ pl_SimpleItem.m_SimpleItem.Abbreviation.val + "'",
"1"
};
}
long id = -1;
if (fs.GetID(s_SimpleItem_table_name,sColumn,sValue,lsql_par,ref id,ref Err))
{
pl_SimpleItem.m_SimpleItem.ID.val = id;
pl_SimpleItem.m_Taxation.ID.val = 1;
}
else
{
return false;
}
}
return true;
}