public bool Get(long_v xOffice_Data_ID_v)
{
string Err = null;
ID_v = null;
Office_Data_ID_v = null;
BuildingNumber_v = null;
BuildingSectionNumber_v = null;
Community_v = null;
CadastralNumber_v = null;
ValidityDate_v = null;
ClosingTag_v = null;
SoftwareSupplier_TaxNumber_v = null;
PremiseType_v = null;
if (xOffice_Data_ID_v != null)
{
string sql = @"SELECT
ID,
Office_Data_ID,
BuildingNumber,
BuildingSectionNumber,
Community,
CadastralNumber,
ValidityDate,
ClosingTag,
SoftwareSupplier_TaxNumber,
PremiseType
FROM FVI_SLO_RealEstateBP
where Office_Data_ID = " + xOffice_Data_ID_v.v.ToString();
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count > 0)
{
ID_v = tf.set_long(dt.Rows[0]["ID"]);
Office_Data_ID_v = tf.set_long(dt.Rows[0]["Office_Data_ID"]);
BuildingNumber_v = tf.set_int(dt.Rows[0]["BuildingNumber"]);
BuildingSectionNumber_v = tf.set_int(dt.Rows[0]["BuildingSectionNumber"]);
Community_v = tf.set_string(dt.Rows[0]["Community"]);
CadastralNumber_v = tf.set_int(dt.Rows[0]["CadastralNumber"]);
ValidityDate_v = tf.set_DateTime(dt.Rows[0]["ValidityDate"]);
ClosingTag_v = tf.set_string(dt.Rows[0]["ClosingTag"]);
SoftwareSupplier_TaxNumber_v = tf.set_string(dt.Rows[0]["SoftwareSupplier_TaxNumber"]);
PremiseType_v = tf.set_string(dt.Rows[0]["PremiseType"]);
}
return true;
}
else
{
LogFile.Error.Show("ERROR:myOrg_Office:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:myOrg_Office:Get:(Office_ID_v == null)");
return false;
}
}
public static bool Write(long DocInvoice_ID, long Atom_WorkPeriod_ID, string Event_Type, string Event_Description, DateTime_v EventTime_v, ref long journal_docinvoice_id)
{
long journal_invoice_type_id = -1;
if (Get_journal_docinvoice_type_id(Event_Type, Event_Description, ref journal_invoice_type_id))
{
return Write(DocInvoice_ID, Atom_WorkPeriod_ID, journal_invoice_type_id, EventTime_v, ref journal_docinvoice_id);
}
return false;
}
private void btn_OK_Click(object sender, EventArgs e)
{
if (ExpiryDate == null)
{
ExpiryDate = new DateTime_v();
}
ExpiryDate.v = this.dateTimePicker.Value;
this.Close();
DialogResult = DialogResult.OK;
}
public Form_Wait_FVI_SLO_Response(string fVI_MessageID, string fVI_UniqueInvoiceID, InvoiceData xInvoiceData, GlobalData.ePaymentType paymentType, string sPaymentMethod, string sAmountReceived, string sToReturn, DateTime_v issue_time)
{
InitializeComponent();
this.fVI_MessageID = fVI_MessageID;
this.fVI_UniqueInvoiceID = fVI_UniqueInvoiceID;
this.xInvoiceData = xInvoiceData;
this.paymentType = paymentType;
this.sPaymentMethod = sPaymentMethod;
this.sAmountReceived = sAmountReceived;
this.sToReturn = sToReturn;
this.issue_time = issue_time;
}
public Form_Print_A4(InvoiceData xInvoiceData, GlobalData.ePaymentType paymentType, string sPaymentMethod, long durationType, long duration, DateTime_v issue_time, Navigation xnav)
{
InitializeComponent();
nav = xnav;
this.m_InvoiceData = xInvoiceData;
this.paymentType = paymentType;
this.sPaymentMethod = sPaymentMethod;
this.issue_time = issue_time;
this.durationType = durationType;
this.duration = duration;
lngRPM.s_Template.Text(lbl_Template, ":");
}
public Form_Stock_AvoidStock_Edit(DateTime_v xExpiryDate)
{
InitializeComponent();
this.Text = lngRPM.s_ExpiryDateFormText.s;
this.lbl_ExpiryDate.Text = lngRPM.s_PleaseDefineExpiryDate.s;
this.btn_Cancel.Text = lngRPM.s_Cancel.s;
this.btn_OK.Text = lngRPM.s_OK.s;
ExpiryDate = xExpiryDate;
if (ExpiryDate != null)
{
this.dateTimePicker.Value = ExpiryDate.v;
}
}
public Form_Print_A4(InvoiceData xInvoiceData, GlobalData.ePaymentType paymentType, string sPaymentMethod, string sAmountReceived, string sToReturn, DateTime_v issue_time, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
this.m_InvoiceData = xInvoiceData;
this.paymentType = paymentType;
this.sPaymentMethod = sPaymentMethod;
this.sAmountReceived = sAmountReceived;
this.sToReturn = sToReturn;
this.issue_time = issue_time;
lngRPM.s_Template.Text(lbl_Template, ":");
}
public SampleDB_Price_ShopB_Item(
string xShopB_Item_Name,
string xShopB_Item_Abbreviation,
bool xShopB_Item_bToOffer,
Image xShopB_Item_Image,
int_v xShopB_Item_Code_v,
string xShopB_Item_ParentGroup1,
string xShopB_Item_ParentGroup2,
string xShopB_Item_ParentGroup3,
string xPriceList_Name,
bool xPriceList_valid,
DateTime_v xPriceList_ValidFrom_v,
DateTime_v xPriceList_ValidTo_v,
DateTime_v xPriceList_CreationDate_v,
string xPriceList_Description,
string xCurrency_Abbreviation,
string xCurrency_Name,
string xCurrency_Symbol,
int xCurrencyCode,
int xCurrency_DecimalPlaces,
string xTaxationName,
decimal xTaxationRate,
decimal xRetailShopB_ItemPrice,
decimal_v xDiscount_v)
{
ShopB_Item_Name = xShopB_Item_Name;
ShopB_Item_Abbreviation = xShopB_Item_Abbreviation;
ShopB_Item_bToOffer = xShopB_Item_bToOffer;
ShopB_Item_Image = xShopB_Item_Image;
ShopB_Item_Code_v = xShopB_Item_Code_v;
ShopB_Item_ParentGroup1 = xShopB_Item_ParentGroup1;
ShopB_Item_ParentGroup2 = xShopB_Item_ParentGroup2;
ShopB_Item_ParentGroup3 = xShopB_Item_ParentGroup3;
PriceList_Name = xPriceList_Name;
PriceList_valid = xPriceList_valid;
PriceList_ValidFrom_v = xPriceList_ValidFrom_v;
PriceList_ValidTo_v = xPriceList_ValidTo_v;
PriceList_CreationDate_v = xPriceList_CreationDate_v;
PriceList_Description = xPriceList_Description;
Currency_Abbreviation = xCurrency_Abbreviation;
Currency_Name = xCurrency_Name;
Currency_Symbol = xCurrency_Symbol;
CurrencyCode = xCurrencyCode;
Currency_DecimalPlaces = xCurrency_DecimalPlaces;
TaxationName = xTaxationName;
TaxationRate = xTaxationRate;
RetailShopB_ItemPrice = xRetailShopB_ItemPrice;
Discount_v = xDiscount_v;
}
public static bool Write(long DocProformaInvoice_ID, long Atom_WorkPeriod_ID, long journal_docproformainvoice_type_id, DateTime_v issue_time, ref long Journal_DocInvoice_ID)
{
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
string spar_journal_docinvoice_type_id = "@par_journal_docproformainvoice_type_id";
SQL_Parameter par_journal_invoice_type_id = new SQL_Parameter(spar_journal_docinvoice_type_id, SQL_Parameter.eSQL_Parameter.Bigint, false, journal_docproformainvoice_type_id);
lpar.Add(par_journal_invoice_type_id);
string spar_DocProfromaInvoice_ID = "@par_DocProformaInvoice_ID";
SQL_Parameter par_Invoice_ID = new SQL_Parameter(spar_DocProfromaInvoice_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, DocProformaInvoice_ID);
lpar.Add(par_Invoice_ID);
string spar_Atom_WorkPeriod_ID = "@par_Atom_WorkPeriod_ID";
SQL_Parameter par_Atom_WorkPeriod_ID = new SQL_Parameter(spar_Atom_WorkPeriod_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, Atom_WorkPeriod_ID);
lpar.Add(par_Atom_WorkPeriod_ID);
DateTime dtime = DateTime.Now;
if (issue_time != null)
{
dtime = issue_time.v;
}
string spar_EventTime = "@par_EventTime";
SQL_Parameter par_EventTime = new SQL_Parameter(spar_EventTime, SQL_Parameter.eSQL_Parameter.Datetime, false, dtime);
lpar.Add(par_EventTime);
string sql = "insert into journal_docproformainvoice (journal_docproformainvoice_type_id,DocProformaInvoice_ID,EventTime,Atom_WorkPeriod_ID)values(" + spar_journal_docinvoice_type_id + "," + spar_DocProfromaInvoice_ID + "," + spar_EventTime + "," + spar_Atom_WorkPeriod_ID + ")";
object ores = null;
string Err = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Journal_DocInvoice_ID, ref ores, ref Err, "journal_docproformainvoice"))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Journal_DocProformaInvoice:Write:sql = " + sql + "\r\nErr=" + Err);
return false;
}
}
public static bool Get(string sPriceListName, bool valid, long Currency_ID, DateTime_v ValidFrom_v, DateTime_v ValidTo_v, DateTime_v CreationDate_v, string Description, ref long PriceList_ID)
{
string Err = null;
object oret = null;
string sql = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
string spar_PriceListName = "@par_PriceListName";
SQL_Parameter par_PriceListName = new SQL_Parameter(spar_PriceListName, SQL_Parameter.eSQL_Parameter.Nvarchar, false, sPriceListName);
lpar.Add(par_PriceListName);
string scond_ValidFrom = " ValidFrom is null ";
string sval_ValidFrom = " null ";
if (ValidFrom_v != null)
{
string spar_ValidFrom = "@par_ValidFrom";
SQL_Parameter par_ValidFrom = new SQL_Parameter(spar_ValidFrom, SQL_Parameter.eSQL_Parameter.Datetime, false, ValidFrom_v.v);
lpar.Add(par_ValidFrom);
scond_ValidFrom = " ValidFrom = " + spar_ValidFrom + " ";
sval_ValidFrom = " " + spar_ValidFrom + " ";
}
string scond_ValidTo = " ValidTo is null ";
string sval_ValidTo = " null ";
if (ValidTo_v != null)
{
string spar_ValidTo = "@par_ValidTo";
SQL_Parameter par_ValidTo = new SQL_Parameter(spar_ValidTo, SQL_Parameter.eSQL_Parameter.Datetime, false, ValidTo_v.v);
lpar.Add(par_ValidTo);
scond_ValidTo = " ValidTo = " + spar_ValidTo + " ";
sval_ValidTo = " " + spar_ValidTo + " ";
}
string scond_CreationDate = " CreationDate is null ";
string sval_CreationDate = " null ";
if (CreationDate_v != null)
{
string spar_CreationDate = "@par_CreationDate";
SQL_Parameter par_CreationDate = new SQL_Parameter(spar_CreationDate, SQL_Parameter.eSQL_Parameter.Datetime, false, CreationDate_v.v);
lpar.Add(par_CreationDate);
scond_CreationDate = " CreationDate = " + spar_CreationDate + " ";
sval_CreationDate = " " + spar_CreationDate + " ";
}
string scond_Description = " Description is null ";
string sval_Description = " null ";
if (Description != null)
{
string spar_Description = "@par_Description";
SQL_Parameter par_Description = new SQL_Parameter(spar_Description, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Description);
lpar.Add(par_Description);
scond_Description = " Description = " + spar_Description + " ";
sval_Description = " " + spar_Description + " ";
}
string scond_valid = " valid = 0 ";
string sval_valid = " 0 ";
if (valid)
{
scond_valid = " valid = 1 ";
sval_valid = " 1 ";
}
sql = "select ID from PriceList where Name = " + spar_PriceListName;
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
PriceList_ID = (long)dt.Rows[0]["ID"];
sql = "select ID from PriceList where Name = " + spar_PriceListName +
" and Currency_ID = " + Currency_ID.ToString() +
" and " + scond_valid +
" and " + scond_ValidFrom +
" and " + scond_ValidTo +
" and " + scond_CreationDate +
" and " + scond_Description;
dt.Clear();
dt.Rows.Clear();
dt.Columns.Clear();
if (DBSync.DBSync.ReadDataTable(ref dt, sql,lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
return true;
}
else
{
sql = "update PriceList set Currency_ID = " + Currency_ID.ToString() +
" , valid = " + sval_valid +
" , ValidFrom = " + sval_ValidFrom +
" , ValidTo = " + sval_ValidTo +
" , CreationDate = " + sval_CreationDate +
" , Description = " + sval_Description +
" where ID = " + PriceList_ID.ToString();
if (DBSync.DBSync.ExecuteNonQuerySQL(sql, lpar, ref oret, ref Err))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_PriceList:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_PriceList:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
sql = @"insert into PriceList (Name,
valid,
Currency_ID,
ValidFrom,
ValidTo,
CreationDate,
Description) values
(" + spar_PriceListName +
"," + sval_valid +
"," + Currency_ID.ToString() +
"," + sval_ValidFrom +
"," + sval_ValidTo +
"," + sval_CreationDate +
"," + sval_Description +
")";
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar,ref PriceList_ID, ref oret, ref Err, "PriceList"))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:f_PriceList:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else
{
LogFile.Error.Show("ERROR:f_PriceList:Get:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
public SampleDB_Price_ShopC_Item( string xShopC_Item_UniqueName,
string xShopC_Item_Name,
int_v xShopC_Item_Code,
string xShopC_Item_ParentGroup1,
string xShopC_Item_ParentGroup2,
string xShopC_Item_ParentGroup3,
string xShopC_Item_Unit_Name,
string xShopC_Item_Unit_Symbol,
int xShopC_Item_Unit_DecimalPlaces,
bool xShopC_Item_Unit_StorageOption,
string xShopC_Item_Unit_Description,
string xShopC_Item_barcode,
string xShopC_Item_Description,
int xShopC_Item_Expiry_ExpectedShelfLifeInDays,
int xShopC_Item_Expiry_SaleBeforeExpiryDateInDays,
int xShopC_Item_Expiry_DiscardBeforeExpiryDateInDays,
string xShopC_Item_Expiry_ExpiryDescription,
int xShopC_Item_Warranty_WarrantyDuration,
int xShopC_Item_Warranty_WarrantyDurationType,
string xShopC_Item_Warranty_WarrantyConditions,
Image xShopC_Item_Image,
bool xShopC_Item_ToOffer,
string xShopC_Price_Item_PriceList_Name,
bool xShopC_Price_Item_PriceList_valid,
string xShopC_Price_Item_Currency_Abbreviation,
string xShopC_Price_Item_Currency_Name,
string xShopC_Price_Item_Currency_Symbol,
int xShopC_Price_Item_CurrencyCode,
int xShopC_Price_Item_Currency_DecimalPlaces,
DateTime_v xShopC_Price_Item_PriceList_ValidFrom_v,
DateTime_v xShopC_Price_Item_PriceList_ValidTo_v,
DateTime_v xShopC_Price_Item_PriceList_CreationDate_v,
string xShopC_Price_Item_PriceList_Description,
string xShopC_Price_Item_TaxationName,
decimal xShopC_Price_Item_TaxationRate,
decimal xShopC_Price_Item_RetailPricePerUnit,
decimal_v xShopC_Price_Item_Discount_v
)
{
ShopC_Price_Item_RetailPricePerUnit = xShopC_Price_Item_RetailPricePerUnit;
ShopC_Price_Item_Discount_v = xShopC_Price_Item_Discount_v;
ShopC_Price_Item_TaxationName = xShopC_Price_Item_TaxationName;
ShopC_Price_Item_TaxationRate = xShopC_Price_Item_TaxationRate;
ShopC_Item_Code = xShopC_Item_Code;
ShopC_Item_UniqueName = xShopC_Item_UniqueName;
ShopC_Item_Name = xShopC_Item_Name;
ShopC_Item_ParentGroup1 = xShopC_Item_ParentGroup1;
ShopC_Item_ParentGroup2 = xShopC_Item_ParentGroup2;
ShopC_Item_ParentGroup3 = xShopC_Item_ParentGroup3;
ShopC_Item_Unit_Name = xShopC_Item_Unit_Name;
ShopC_Item_Unit_Symbol = xShopC_Item_Unit_Symbol;
ShopC_Item_Unit_DecimalPlaces = xShopC_Item_Unit_DecimalPlaces;
ShopC_Item_Unit_StorageOption = xShopC_Item_Unit_StorageOption;
ShopC_Item_Unit_Description = xShopC_Item_Unit_Description;
ShopC_Item_barcode = xShopC_Item_barcode;
ShopC_Item_Description = xShopC_Item_Description;
ShopC_Item_Expiry_ExpectedShelfLifeInDays = xShopC_Item_Expiry_ExpectedShelfLifeInDays;
ShopC_Item_Expiry_SaleBeforeExpiryDateInDays = xShopC_Item_Expiry_SaleBeforeExpiryDateInDays;
ShopC_Item_Expiry_DiscardBeforeExpiryDateInDays = xShopC_Item_Expiry_DiscardBeforeExpiryDateInDays;
ShopC_Item_Expiry_ExpiryDescription = xShopC_Item_Expiry_ExpiryDescription;
ShopC_Item_Warranty_WarrantyDuration = xShopC_Item_Warranty_WarrantyDuration;
ShopC_Item_Warranty_WarrantyDurationType = xShopC_Item_Warranty_WarrantyDurationType;
ShopC_Item_Warranty_WarrantyConditions = xShopC_Item_Warranty_WarrantyConditions;
ShopC_Item_Image = xShopC_Item_Image;
ShopC_Item_ToOffer = xShopC_Item_ToOffer;
ShopC_Price_Item_PriceList_Name = xShopC_Price_Item_PriceList_Name;
ShopC_Price_Item_PriceList_valid = xShopC_Price_Item_PriceList_valid;
ShopC_Price_Item_Currency_Abbreviation = xShopC_Price_Item_Currency_Abbreviation;
ShopC_Price_Item_Currency_Name = xShopC_Price_Item_Currency_Name;
ShopC_Price_Item_Currency_Symbol = xShopC_Price_Item_Currency_Symbol;
ShopC_Price_Item_CurrencyCode = xShopC_Price_Item_CurrencyCode;
ShopC_Price_Item_Currency_DecimalPlaces = xShopC_Price_Item_Currency_DecimalPlaces;
ShopC_Price_Item_PriceList_ValidFrom_v = xShopC_Price_Item_PriceList_ValidFrom_v;
ShopC_Price_Item_PriceList_ValidTo_v = xShopC_Price_Item_PriceList_ValidTo_v;
ShopC_Price_Item_PriceList_CreationDate_v = xShopC_Price_Item_PriceList_CreationDate_v;
ShopC_Price_Item_PriceList_Description = xShopC_Price_Item_PriceList_Description;
}
internal void Print_Receipt_ESC_POS(InvoiceData xInvoiceData,
string FursD_BussinesPremiseID,
string ElectronicDevice_ID,
int BaseCurrency_DecimalPlaces,
GlobalData.ePaymentType PaymentType, string sPaymentMethod, string sAmountReceived, string sToReturn, DateTime_v issue_time)
{
//ReceiptPrinter.Print(ep.InitializePrinter());
long journal_docinvoice_id = -1;
try
{
if (InitializePrinter())
{
}
if (PrintInBuffer)
{
Clear();
}
if (xInvoiceData.MyOrganisation.Logo_Data != null)
{
this.wr_BitmapByteArray570x570imagesize(xInvoiceData.MyOrganisation.Logo_Data);
}
wr_SelectAnInternationalCharacterSet(Printer.eCharacterSet.Slovenia_Croatia);
wr_Paragraph(xInvoiceData.MyOrganisation.Name);
wr_Paragraph(xInvoiceData.MyOrganisation.Address.StreetName + " " + xInvoiceData.MyOrganisation.Address.HouseNumber);
wr_Paragraph(xInvoiceData.MyOrganisation.Address.ZIP + " " + xInvoiceData.MyOrganisation.Address.City);
if (xInvoiceData.MyOrganisation.HomePage != null)
{
if (xInvoiceData.MyOrganisation.HomePage.Length > 0)
{
wr_String("Domača stran:");
wr_SelectAnInternationalCharacterSet(Printer.eCharacterSet.USA);
wr_String(xInvoiceData.MyOrganisation.HomePage);
wr_SelectAnInternationalCharacterSet(Printer.eCharacterSet.Slovenia_Croatia);
wr_NewLine();
;
}
}
if (xInvoiceData.MyOrganisation.Email != null)
{
if (xInvoiceData.MyOrganisation.Email.Length > 0)
{
wr_String("EPOŠTA:");
wr_SelectAnInternationalCharacterSet(Printer.eCharacterSet.USA);
wr_String(xInvoiceData.MyOrganisation.Email);
wr_SelectAnInternationalCharacterSet(Printer.eCharacterSet.Slovenia_Croatia);
}
}
wr_NewLine();
wr_Paragraph("Davčna Številka:" + xInvoiceData.MyOrganisation.Tax_ID);
wr_NewLine(2);
//buffer = buffer + "\x1b\x1d\x61\x0"; //Left Alignment - Refer to Pg. 3-29
wr_SetHorizontalTabPositions(new byte[] { 2, 0x10, 0x22 });
wr_Paragraph("Številka računa: " + xInvoiceData.FinancialYear.ToString() + "/" + xInvoiceData.NumberInFinancialYear.ToString());
wr_Paragraph("Datum:" + xInvoiceData.IssueDate_v.v.Day.ToString() + "." + xInvoiceData.IssueDate_v.v.Month.ToString() + "." + xInvoiceData.IssueDate_v.v.Year.ToString() + "\x9" + " Čas:" + xInvoiceData.IssueDate_v.v.Hour.ToString() + ":" + xInvoiceData.IssueDate_v.v.Minute.ToString()); //Moving Horizontal Tab - Pg. 3-26
wr_LineDelimeter();
wr_BoldOn();
wr_Paragraph("PRODANO:");
wr_NewLine();
wr_BoldOff();
//Select Emphasized Printing - Pg. 3-14; //Cancel Emphasized Printing - Pg. 3-14
taxSum = null;
taxSum = new StaticLib.TaxSum();
foreach (ItemSold itmsold in xInvoiceData.ItemsSold)
{
wr_Paragraph(itmsold.Item_Name);
wr_String("Cena za enoto" + HT + itmsold.RetailPricePerUnit.ToString() + " EUR\n");
decimal TotalDiscount = StaticLib.Func.TotalDiscount(itmsold.Discount, itmsold.ExtraDiscount, BaseCurrency_DecimalPlaces);
decimal TotalDiscountPercent = TotalDiscount * 100;
if (TotalDiscountPercent > 0)
{
wr_String("Popust:" + TotalDiscountPercent.ToString() + " %\n");
}
wr_String("Količina:" + HT + itmsold.dQuantity.ToString() + "\n");
if (TotalDiscountPercent > 0)
{
wr_String("Cena s popustom:" + HT + HT + itmsold.PriceWithTax.ToString() + " EUR\n");
}
else
{
wr_String("Cena " + HT + HT + HT + itmsold.PriceWithTax.ToString() + " EUR\n");
}
wr_String(itmsold.TaxationName + HT + HT + itmsold.TaxPrice.ToString() + " EUR\n");
wr_NewLine();
}
//foreach (DataRow dr in xInvoiceData.dt_ShopB_Items.Rows)
//{
// object o_SimpleItem_name = dr["Name"];
// string SimpleItem_name = null;
// if (o_SimpleItem_name.GetType() == typeof(string))
// {
// SimpleItem_name = (string)o_SimpleItem_name;
// }
// decimal RetailSimpleItemPrice = 0;
// object o_RetailSimpleItemPrice = dr["RetailSimpleItemPrice"];
// if (o_RetailSimpleItemPrice.GetType() == typeof(decimal))
// {
// RetailSimpleItemPrice = (decimal)o_RetailSimpleItemPrice;
// }
// decimal RetailSimpleItemPriceWithDiscount = 0;
// object o_RetailSimpleItemPriceWithDiscount = dr["RetailSimpleItemPriceWithDiscount"];
// if (o_RetailSimpleItemPriceWithDiscount.GetType() == typeof(decimal))
// {
// RetailSimpleItemPriceWithDiscount = (decimal)o_RetailSimpleItemPriceWithDiscount;
// }
// string TaxationName = "Davek ???";
// object oTaxationName = dr["Atom_Taxation_Name"];
// if (oTaxationName is string)
// {
// TaxationName = (string)oTaxationName;
// }
// decimal TaxPrice = -1;
// object oTaxPrice = dr["TaxPrice"];
// if (oTaxPrice is decimal)
// {
// TaxPrice = (decimal)oTaxPrice;
// taxSum.Add(TaxPrice, 0, (string)dr["Atom_Taxation_Name"], (decimal)dr["Atom_Taxation_Rate"]);
// }
// int iQuantity = -1;
// object oQuantity = dr["iQuantity"];
// if (oQuantity is int)
// {
// iQuantity = (int)oQuantity;
// }
// decimal Discount = 0;
// object oDiscount = dr["Discount"];
// if (oDiscount is decimal)
// {
// Discount = (decimal)oDiscount;
// }
// decimal ExtraDiscount = 0;
// object oExtraDiscount = dr["ExtraDiscount"];
// if (oExtraDiscount is decimal)
// {
// ExtraDiscount = (decimal)oExtraDiscount;
// }
// Printer.wr_Paragraph(SimpleItem_name);
// Printer.wr_String("Cena za enoto" + HT + RetailSimpleItemPrice.ToString() + " EUR\n");
// decimal TotalDiscount = StaticLib.Func.TotalDiscount(Discount, ExtraDiscount, Program.Get_BaseCurrency_DecimalPlaces());
// decimal TotalDiscountPercent = TotalDiscount * 100;
// if (TotalDiscountPercent > 0)
// {
// Printer.wr_String("Popust:" + TotalDiscountPercent.ToString() + " %\n");
// }
// Printer.wr_String("Količina:" + HT + iQuantity.ToString() + "\n");
// if (TotalDiscountPercent > 0)
// {
// Printer.wr_String("Cena s popustom:" + HT + HT + RetailSimpleItemPriceWithDiscount.ToString() + " EUR\n");
// }
// else
// {
// Printer.wr_String("Cena " + HT + HT + HT + RetailSimpleItemPriceWithDiscount.ToString() + " EUR\n");
// }
// Printer.wr_String(TaxationName + HT + HT + TaxPrice.ToString() + " EUR\n");
// Printer.wr_NewLine();
//}
////DocInvoice_ShopC_Item.ID AS DocInvoice_ShopC_Item_ID,
////DocInvoice_ShopC_Item.DocInvoice_ID,
////DocInvoice.Atom_myOrganisation_Person_ID,
////DocInvoice_ShopC_Item.Stock_ID,
////DocInvoice_ShopC_Item.Atom_Price_Item_ID,
////Atom_Item.ID as Atom_Item_ID,
////itm.ID as Item_ID,
////Atom_Price_Item.RetailPricePerUnit,
////Atom_Price_Item.Discount,
////DocInvoice_ShopC_Item.RetailPriceWithDiscount,
////DocInvoice_ShopC_Item.TaxPrice,
////DocInvoice_ShopC_Item.ExtraDiscount,
////DocInvoice_ShopC_Item.dQuantity,
////DocInvoice_ShopC_Item.ExpiryDate,
////Atom_Item.UniqueName AS Atom_Item_UniqueName,
////Atom_Item_Name.Name AS Atom_Item_Name_Name,
////Atom_Item_barcode.barcode AS Atom_Item_barcode_barcode,
////Atom_Taxation.Name AS Atom_Taxation_Name,
////Atom_Taxation.Rate AS Atom_Taxation_Rate,
////Atom_Item_Description.Description AS Atom_Item_Description_Description,
////Atom_Item.Atom_Warranty_ID,
////Atom_Warranty.WarrantyDurationType AS Atom_Warranty_WarrantyDurationType,
////Atom_Warranty.WarrantyDuration AS Atom_Warranty_WarrantyDuration,
////Atom_Warranty.WarrantyConditions AS Atom_Warranty_WarrantyConditions,
////Atom_Item.Atom_Expiry_ID,
////Atom_Expiry.ExpectedShelfLifeInDays AS Atom_Expiry_ExpectedShelfLifeInDays,
////Atom_Expiry.SaleBeforeExpiryDateInDays AS Atom_Expiry_SaleBeforeExpiryDateInDays,
////Atom_Expiry.DiscardBeforeExpiryDateInDays AS Atom_Expiry_DiscardBeforeExpiryDateInDays,
////Atom_Expiry.ExpiryDescription AS Atom_Expiry_ExpiryDescription,
////puitms.Item_ID AS Stock_Item_ID,
////Stock.ImportTime AS Stock_ImportTime,
////Stock.dQuantity AS Stock_dQuantity,
////Stock.ExpiryDate AS Stock_ExpiryDate,
////Atom_Unit.Name AS Atom_Unit_Name,
////Atom_Unit.Symbol AS Atom_Unit_Symbol,
////Atom_Unit.DecimalPlaces AS Atom_Unit_DecimalPlaces,
////Atom_Unit.Description AS Atom_Unit_Description,
////Atom_Unit.StorageOption AS Atom_Unit_StorageOption,
////Atom_PriceList.Name AS Atom_PriceList_Name,
////Atom_Currency.Name AS Atom_Currency_Name,
////Atom_Currency.Abbreviation AS Atom_Currency_Abbreviation,
////Atom_Currency.Symbol AS Atom_Currency_Symbol,
////Atom_Currency.DecimalPlaces AS Atom_Currency_DecimalPlaces
//Printer.wr_NewLine();
//foreach (DocInvoice_ShopC_Item_Data appisd in xInvoiceData.m_ShopABC.m_CurrentInvoice.m_Basket.DocInvoice_ShopC_Item_Data_LIST)
//{
// string Item_UniqueName = appisd.Atom_Item_UniqueName.v;
// decimal RetailPricePerUnit = appisd.RetailPricePerUnit.v;
// decimal RetailItemPriceWithDiscount = appisd.RetailPriceWithDiscount.v;
// Printer.wr_String(Item_UniqueName + "\n");
// decimal dQuantity = appisd.dQuantity_FromStock + appisd.dQuantity_FromFactory;
// string Atom_Unit_Name = appisd.Atom_Unit_Name.v;
// Printer.wr_String("Cena za 1 " + Atom_Unit_Name + " = " + RetailPricePerUnit.ToString() + " EUR\n");
// decimal Discount = appisd.Discount.v;
// decimal ExtraDiscount = appisd.ExtraDiscount.v;
// decimal TotalDiscount = StaticLib.Func.TotalDiscount(Discount, ExtraDiscount, Program.Get_BaseCurrency_DecimalPlaces());
// decimal TotalDiscountPercent = TotalDiscount * 100;
// if (TotalDiscountPercent > 0)
// {
// Printer.wr_String("Popust:" + TotalDiscountPercent.ToString() + " %\n");
// }
// Printer.wr_String("Količina:" + HT + dQuantity.ToString() + " " + Atom_Unit_Name + "\n");
// decimal Atom_Taxation_Rate = appisd.Atom_Taxation_Rate.v;
// decimal RetailItemsPriceWithDiscount = 0;
// decimal ItemsTaxPrice = 0;
// decimal ItemsNetPrice = 0;
// int decimal_places = appisd.Atom_Currency_DecimalPlaces.v;
// StaticLib.Func.CalculatePrice(RetailPricePerUnit, dQuantity, Discount, ExtraDiscount, Atom_Taxation_Rate, ref RetailItemsPriceWithDiscount, ref ItemsTaxPrice, ref ItemsNetPrice, decimal_places);
// if (TotalDiscountPercent > 0)
// {
// Printer.wr_String("Cena s popustom:" + HT + HT + RetailItemsPriceWithDiscount.ToString() + " EUR\n");
// }
// else
// {
// Printer.wr_String("Cena " + HT + HT + HT + RetailItemsPriceWithDiscount.ToString() + " EUR\n");
// }
// string TaxationName = appisd.Atom_Taxation_Name.v;
// decimal TaxPrice = appisd.TaxPrice.v;
// taxSum.Add(ItemsTaxPrice, 0, TaxationName, Atom_Taxation_Rate);
// Printer.wr_String(TaxationName + HT + HT + ItemsTaxPrice.ToString() + " EUR\n");
// Printer.wr_NewLine();
//}
wr_LineDelimeter();
foreach (StaticLib.Tax tax in taxSum.TaxList)
{
wr_String(tax.Name + HT + HT + "" + tax.TaxAmount.ToString() + " EUR\n");
}
wr_String("Brez davka " + HT + HT + "" + xInvoiceData.NetSum.ToString() + " EUR\n");
//buffer += "\x1B" + "G" + "\xFF";
wr_String("Skupaj " + HT + HT + xInvoiceData.GrossSum.ToString() + " EUR\n");
//buffer += "\x1B" + "G" + "\x00\n";
if (PaymentType != GlobalData.ePaymentType.NONE)
{
wr_String("Način plačila:" + sPaymentMethod + "\n");
if (PaymentType == GlobalData.ePaymentType.CASH)
{
wr_String(" Prejeto: " + sAmountReceived + " EUR\n");
wr_String(" Vrnjeno: " + sToReturn + " EUR\n");
}
}
wr_NewLine(1);
wr_String("Številka računa za FURS:\n");
wr_String(FursD_BussinesPremiseID + "-" + ElectronicDevice_ID + "-" + xInvoiceData.NumberInFinancialYear.ToString());
wr_NewLine(1);
wr_String("Oseba, ki je izdala račun:\n");
wr_String(xInvoiceData.Invoice_Author.FirstName + " " + xInvoiceData.Invoice_Author.LastName);
if (xInvoiceData.AddOnDI.m_FURS.FURS_QR_v != null)
{
if (xInvoiceData.AddOnDI.m_FURS.FURS_Image_QRcode != null)
{
//Size size = new Size(32, 32);
//Image img_new = StaticLib.Func.resizeImage(xInvoiceData.FURS_Response_Data.Image_QRcode, size, System.Drawing.Imaging.ImageFormat.Bmp, System.Drawing.Imaging.PixelFormat.Format1bppIndexed);
//byte[] barr = StaticLib.Func.imageToByteArray(img_new);
wr_NewLine(1);
wr_String("ZOI:" + xInvoiceData.AddOnDI.m_FURS.FURS_ZOI_v.v + "\n");
wr_String("EOR:" + xInvoiceData.AddOnDI.m_FURS.FURS_EOR_v.v + "\n");
wr_NewLine(1);
byte[] barr = StaticLib.Func.imageToByteArray(xInvoiceData.AddOnDI.m_FURS.FURS_Image_QRcode);
wr_BitmapByteArray(barr, 180);
}
}
wr_NewLine(6);
PartialCutPaper();
if (PrintInBuffer)
{
Print_PrinterBuffer();
}
string s_journal_invoice_type = lngRPM.s_journal_invoice_type_Print.s;
string s_journal_invoice_description = PrinterName;
f_Journal_DocInvoice.Write(xInvoiceData.DocInvoice_ID, GlobalData.Atom_WorkPeriod_ID, s_journal_invoice_type, s_journal_invoice_description, null, ref journal_docinvoice_id);
}
catch (Exception ex)
{
string s_journal_invoice_type = lngRPM.s_journal_invoice_type_PrintError.s + PrinterName + "\nErr=" + ex.Message;
string s_journal_invoice_description = PrinterName;
f_Journal_DocInvoice.Write(xInvoiceData.DocInvoice_ID, GlobalData.Atom_WorkPeriod_ID, s_journal_invoice_type, s_journal_invoice_description, null, ref journal_docinvoice_id);
}
}
public bool Read_DocInvoice()
{
string sql = null;
if (IsDocInvoice)
{
AddOnDI.DocInvoice_Reference_ID_v = null;
if (AddOnDI.b_FVI_SLO)
{
sql = @"select
pi.ID as DocInvoice_ID,
pi.FinancialYear,
pi.NumberInFinancialYear,
pi.Draft,
mpay.PaymentType,
GrossSum,
TaxSum,
NetSum,
ao.Name,
ao.Tax_ID,
ao.Registration_ID,
Atom_cStreetName_Org.StreetName,
Atom_cHouseNumber_Org.HouseNumber,
Atom_cCity_Org.City,
Atom_cZIP_Org.ZIP,
Atom_cCountry_Org.Country,
Atom_cState_Org.State,
cEmail_Org.Email,
aorgd_hp.HomePage,
cPhoneNumber_Org.PhoneNumber,
cFaxNumber_Org.FaxNumber,
aorgd.BankName,
aorgd.TRR,
aoff.Name as Atom_Office_Name,
apfn.FirstName as My_Organisation_Person_FirstName,
apln.LastName as My_Organisation_Person_LastName,
ap.ID as Atom_MyOrganisation_Person_ID,
ao.Tax_ID as My_Organisation_Tax_ID,
ap.CardNumber,
amcp.UserName as My_Organisation_Person_UserName,
amcp.Job as My_Organisation_Job,
Atom_Logo.Image_Hash as Logo_Hash,
Atom_Logo.Image_Data as Logo_Data,
Atom_Logo.Description as Logo_Description,
acusorg.ID as Atom_Customer_Org_ID,
acusper.ID as Atom_Customer_Person_ID,
jpi.EventTime,
jpit.Name as JOURNAL_DocInvoice_Type_Name,
JOURNAL_DocInvoice_$_dinv_$_fvisres.MessageID As JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$MessageID,
JOURNAL_DocInvoice_$_dinv_$_fvisres.UniqueInvoiceID As JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$UniqueInvoiceID,
JOURNAL_DocInvoice_$_dinv_$_fvisres.BarCodeValue As JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$BarCodeValue,
JOURNAL_DocInvoice_$_dinv_$_fvisbi.InvoiceNumber AS JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$InvoiceNumber,
JOURNAL_DocInvoice_$_dinv_$_fvisbi.SetNumber AS JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$SetNumber,
JOURNAL_DocInvoice_$_dinv_$_fvisbi.SerialNumber AS JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$SerialNumber,
pi.Storno,
pi.Invoice_Reference_Type,
pi.Invoice_Reference_ID
from JOURNAL_DocInvoice jpi
inner join JOURNAL_DocInvoice_Type jpit on jpi.JOURNAL_DocInvoice_Type_ID = jpit.ID and ((jpit.ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.ID.ToString() + @") or (jpit.ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceStornoTime.ID.ToString() + @"))
inner join DocInvoice pi on jpi.DocInvoice_ID = pi.ID
inner join Atom_WorkPeriod awp on jpi.Atom_WorkPeriod_ID = awp.ID
inner join Atom_myOrganisation_Person amcp on awp.Atom_myOrganisation_Person_ID = amcp.ID
inner join Atom_Person ap on ap.ID = amcp.Atom_Person_ID
inner join Atom_Office aoff on amcp.Atom_Office_ID = aoff.ID
inner join Atom_Office_Data aoffd on aoffd.Atom_Office_ID = aoff.ID
inner join Atom_myOrganisation amc on aoff.Atom_myOrganisation_ID = amc.ID
inner join Atom_OrganisationData aorgd on amc.Atom_OrganisationData_ID = aorgd.ID
inner join Atom_Organisation ao on aorgd.Atom_Organisation_ID = ao.ID
LEFT JOIN FVI_SLO_Response JOURNAL_DocInvoice_$_dinv_$_fvisres ON JOURNAL_DocInvoice_$_dinv_$_fvisres.DocInvoice_ID = pi.ID
LEFT JOIN FVI_SLO_SalesBookInvoice JOURNAL_DocInvoice_$_dinv_$_fvisbi ON JOURNAL_DocInvoice_$_dinv_$_fvisbi.DocInvoice_ID = pi.ID
left join Atom_cFirstName apfn on ap.Atom_cFirstName_ID = apfn.ID
left join Atom_cLastName apln on ap.Atom_cLastName_ID = apln.ID
left join MethodOfPayment mpay on pi.MethodOfPayment_ID = mpay.ID
left join cOrgTYPE aorgd_cOrgTYPE on aorgd.cOrgTYPE_ID = aorgd_cOrgTYPE.ID
left join Atom_cAddress_Org acaorg on aorgd.Atom_cAddress_Org_ID = acaorg.ID
left join Atom_cStreetName_Org on acaorg.Atom_cStreetName_Org_ID = Atom_cStreetName_Org.ID
left join Atom_cHouseNumber_Org on acaorg.Atom_cHouseNumber_Org_ID = Atom_cHouseNumber_Org.ID
left join Atom_cCity_Org on acaorg.Atom_cCity_Org_ID = Atom_cCity_Org.ID
left join Atom_cZIP_Org on acaorg.Atom_cZIP_Org_ID = Atom_cZIP_Org.ID
left join Atom_cCountry_Org on acaorg.Atom_cCountry_Org_ID = Atom_cCountry_Org.ID
left join Atom_cState_Org on acaorg.Atom_cState_Org_ID = Atom_cState_Org.ID
left join cHomePage_Org on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cEmail_Org on aorgd.cEmail_Org_ID = cEmail_Org.ID
left join cHomePage_Org aorgd_hp on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cFaxNumber_Org on aorgd.cFaxNumber_Org_ID = cFaxNumber_Org.ID
left join cPhoneNumber_Org on aorgd.cPhoneNumber_Org_ID = cPhoneNumber_Org.ID
left join Atom_Logo on aorgd.Atom_Logo_ID = Atom_Logo.ID
left join Atom_Customer_Org acusorg on acusorg.ID = pi.Atom_Customer_Org_ID
left join Atom_Customer_Person acusper on acusper.ID = pi.Atom_Customer_Person_ID
where pi.ID = " + DocInvoice_ID.ToString();
}
else
{
sql = @"select
pi.ID as DocInvoice_ID,
pi.FinancialYear,
pi.NumberInFinancialYear,
pi.Draft,
mpay.PaymentType,
GrossSum,
TaxSum,
NetSum,
ao.Name,
ao.Tax_ID,
ao.Registration_ID,
Atom_cStreetName_Org.StreetName,
Atom_cHouseNumber_Org.HouseNumber,
Atom_cCity_Org.City,
Atom_cZIP_Org.ZIP,
Atom_cCountry_Org.Country,
Atom_cState_Org.State,
cEmail_Org.Email,
aorgd_hp.HomePage,
cPhoneNumber_Org.PhoneNumber,
cFaxNumber_Org.FaxNumber,
aorgd.BankName,
aorgd.TRR,
aoff.Name as Atom_Office_Name,
apfn.FirstName as My_Organisation_Person_FirstName,
apln.LastName as My_Organisation_Person_LastName,
ap.ID as Atom_MyOrganisation_Person_ID,
ao.Tax_ID as My_Organisation_Tax_ID,
ap.CardNumber,
amcp.UserName as My_Organisation_Person_UserName,
amcp.Job as My_Organisation_Job,
Atom_Logo.Image_Hash as Logo_Hash,
Atom_Logo.Image_Data as Logo_Data,
Atom_Logo.Description as Logo_Description,
acusorg.ID as Atom_Customer_Org_ID,
acusper.ID as Atom_Customer_Person_ID,
jpi.EventTime,
jpit.Name as JOURNAL_DocInvoice_Type_Name,
pi.Storno,
pi.Invoice_Reference_Type,
pi.Invoice_Reference_ID
from JOURNAL_DocInvoice jpi
inner join JOURNAL_DocInvoice_Type jpit on jpi.JOURNAL_DocInvoice_Type_ID = jpit.ID and ((jpit.ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.ID.ToString() + @") or (jpit.ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceStornoTime.ID.ToString() + @"))
inner join DocInvoice pi on jpi.DocInvoice_ID = pi.ID
inner join Atom_WorkPeriod awp on jpi.Atom_WorkPeriod_ID = awp.ID
inner join Atom_myOrganisation_Person amcp on Atom_WorkPeriod.Atom_myOrganisation_Person_ID = amcp.ID
inner join Atom_Person ap on ap.ID = amcp.Atom_Person_ID
inner join Atom_Office aoff on amcp.Atom_Office_ID = aoff.ID
inner join Atom_Office_Data aoffd on aoffd.Atom_Office_ID = aoff.ID
inner join Atom_myOrganisation amc on aoff.Atom_myOrganisation_ID = amc.ID
inner join Atom_OrganisationData aorgd on amc.Atom_OrganisationData_ID = aorgd.ID
inner join Atom_Organisation ao on aorgd.Atom_Organisation_ID = ao.ID
left join Atom_cFirstName apfn on ap.Atom_cFirstName_ID = apfn.ID
left join Atom_cLastName apln on ap.Atom_cLastName_ID = apln.ID
left join MethodOfPayment mpay on pi.MethodOfPayment_ID = mpay.ID
left join cOrgTYPE aorgd_cOrgTYPE on aorgd.cOrgTYPE_ID = aorgd_cOrgTYPE.ID
left join Atom_cAddress_Org acaorg on aorgd.Atom_cAddress_Org_ID = acaorg.ID
left join Atom_cStreetName_Org on acaorg.Atom_cStreetName_Org_ID = Atom_cStreetName_Org.ID
left join Atom_cHouseNumber_Org on acaorg.Atom_cHouseNumber_Org_ID = Atom_cHouseNumber_Org.ID
left join Atom_cCity_Org on acaorg.Atom_cCity_Org_ID = Atom_cCity_Org.ID
left join Atom_cZIP_Org on acaorg.Atom_cZIP_Org_ID = Atom_cZIP_Org.ID
left join Atom_cCountry_Org on acaorg.Atom_cCountry_Org_ID = Atom_cCountry_Org.ID
left join Atom_cState_Org on acaorg.Atom_cState_Org_ID = Atom_cState_Org.ID
left join cHomePage_Org on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cEmail_Org on aorgd.cEmail_Org_ID = cEmail_Org.ID
left join cHomePage_Org aorgd_hp on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cFaxNumber_Org on aorgd.cFaxNumber_Org_ID = cFaxNumber_Org.ID
left join cPhoneNumber_Org on aorgd.cPhoneNumber_Org_ID = cPhoneNumber_Org.ID
left join Atom_Logo on aorgd.Atom_Logo_ID = Atom_Logo.ID
left join Atom_Customer_Org acusorg on acusorg.ID = pi.Atom_Customer_Org_ID
left join Atom_Customer_Person acusper on acusper.ID = pi.Atom_Customer_Person_ID
where pi.ID = " + DocInvoice_ID.ToString();
}
}
else if (IsDocProformaInvoice)
{
sql = @"select
pi.ID as DocProformaInvoice_ID,
pi.FinancialYear,
pi.NumberInFinancialYear,
pi.Draft,
mpay.PaymentType,
GrossSum,
TaxSum,
NetSum,
ao.Name,
ao.Tax_ID,
ao.Registration_ID,
Atom_cStreetName_Org.StreetName,
Atom_cHouseNumber_Org.HouseNumber,
Atom_cCity_Org.City,
Atom_cZIP_Org.ZIP,
Atom_cCountry_Org.Country,
Atom_cState_Org.State,
cEmail_Org.Email,
aorgd_hp.HomePage,
cPhoneNumber_Org.PhoneNumber,
cFaxNumber_Org.FaxNumber,
aorgd.BankName,
aorgd.TRR,
aoff.Name as Atom_Office_Name,
apfn.FirstName as My_Organisation_Person_FirstName,
apln.LastName as My_Organisation_Person_LastName,
ap.ID as Atom_MyOrganisation_Person_ID,
ao.Tax_ID as My_Organisation_Tax_ID,
ap.CardNumber,
amcp.UserName as My_Organisation_Person_UserName,
amcp.Job as My_Organisation_Job,
Atom_Logo.Image_Hash as Logo_Hash,
Atom_Logo.Image_Data as Logo_Data,
Atom_Logo.Description as Logo_Description,
acusorg.ID as Atom_Customer_Org_ID,
acusper.ID as Atom_Customer_Person_ID,
jpi.EventTime,
jpit.Name as JOURNAL_DocProformaInvoice_Type_Name
from JOURNAL_DocProformaInvoice jpi
inner join JOURNAL_DocProformaInvoice_Type jpit on jpi.JOURNAL_DocProformaInvoice_Type_ID = jpit.ID and (jpit.ID = " + GlobalData.JOURNAL_DocProformaInvoice_Type_definitions.ProformaInvoiceDraftTime.ID.ToString() + @")
inner join DocProformaInvoice pi on jpi.DocProformaInvoice_ID = pi.ID
inner join Atom_WorkPeriod awp on jpi.Atom_WorkPeriod_ID = awp.ID
inner join Atom_myOrganisation_Person amcp on awp.Atom_myOrganisation_Person_ID = amcp.ID
inner join Atom_Person ap on ap.ID = amcp.Atom_Person_ID
inner join Atom_Office aoff on amcp.Atom_Office_ID = aoff.ID
inner join Atom_Office_Data aoffd on aoffd.Atom_Office_ID = aoff.ID
inner join Atom_myOrganisation amc on aoff.Atom_myOrganisation_ID = amc.ID
inner join Atom_OrganisationData aorgd on amc.Atom_OrganisationData_ID = aorgd.ID
inner join Atom_Organisation ao on aorgd.Atom_Organisation_ID = ao.ID
left join Atom_cFirstName apfn on ap.Atom_cFirstName_ID = apfn.ID
left join Atom_cLastName apln on ap.Atom_cLastName_ID = apln.ID
left join MethodOfPayment mpay on pi.MethodOfPayment_ID = mpay.ID
left join cOrgTYPE aorgd_cOrgTYPE on aorgd.cOrgTYPE_ID = aorgd_cOrgTYPE.ID
left join Atom_cAddress_Org acaorg on aorgd.Atom_cAddress_Org_ID = acaorg.ID
left join Atom_cStreetName_Org on acaorg.Atom_cStreetName_Org_ID = Atom_cStreetName_Org.ID
left join Atom_cHouseNumber_Org on acaorg.Atom_cHouseNumber_Org_ID = Atom_cHouseNumber_Org.ID
left join Atom_cCity_Org on acaorg.Atom_cCity_Org_ID = Atom_cCity_Org.ID
left join Atom_cZIP_Org on acaorg.Atom_cZIP_Org_ID = Atom_cZIP_Org.ID
left join Atom_cCountry_Org on acaorg.Atom_cCountry_Org_ID = Atom_cCountry_Org.ID
left join Atom_cState_Org on acaorg.Atom_cState_Org_ID = Atom_cState_Org.ID
left join cHomePage_Org on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cEmail_Org on aorgd.cEmail_Org_ID = cEmail_Org.ID
left join cHomePage_Org aorgd_hp on aorgd.cHomePage_Org_ID = cHomePage_Org.ID
left join cFaxNumber_Org on aorgd.cFaxNumber_Org_ID = cFaxNumber_Org.ID
left join cPhoneNumber_Org on aorgd.cPhoneNumber_Org_ID = cPhoneNumber_Org.ID
left join Atom_Logo on aorgd.Atom_Logo_ID = Atom_Logo.ID
left join Atom_Customer_Org acusorg on acusorg.ID = pi.Atom_Customer_Org_ID
left join Atom_Customer_Person acusper on acusper.ID = pi.Atom_Customer_Person_ID
where pi.ID = " + DocInvoice_ID.ToString();
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:DocInvoice=" + DocInvoice + " not implemented.");
return false;
}
string Err = null;
if (DBSync.DBSync.ReadDataTable(ref dt_DocInvoice, sql, ref Err))
{
if (dt_DocInvoice.Rows.Count == 1)
{
try
{
Draft = DBTypes.tf._set_bool(dt_DocInvoice.Rows[0]["Draft"]);
if (IsDocInvoice)
{
AddOnDI.Invoice_Storno_v = DBTypes.tf.set_bool(dt_DocInvoice.Rows[0]["Storno"]);
AddOnDI.Invoice_Reference_Type_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["Invoice_Reference_Type"]);
AddOnDI.DocInvoice_Reference_ID_v = DBTypes.tf.set_long(dt_DocInvoice.Rows[0]["Invoice_Reference_ID"]);
}
else
{
}
DocInvoice_ID_v = DBTypes.tf.set_long(dt_DocInvoice.Rows[0][DocInvoice+"_ID"]);
DateTime_v EventTime_v = DBTypes.tf.set_DateTime(dt_DocInvoice.Rows[0]["EventTime"]);
string_v EventName_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_"+DocInvoice+"_Type_Name"]);
if (Draft)
{
this.m_eType = eType.DRAFT_INVOICE;
}
else
{
if (DocInvoice_ID_v != null)
{
if (IsDocInvoice)
{
if (EventName_v != null)
{
if (EventName_v.v.Equals("InvoiceTime"))
{
this.m_eType = eType.INVOICE;
this.IssueDate_v = EventTime_v.Clone();
}
else if (EventName_v.v.Equals("InvoiceStornoTime"))
{
this.m_eType = eType.STORNO;
AddOnDI.StornoIssueDate_v = EventTime_v.Clone();
if (AddOnDI.DocInvoice_Reference_ID_v != null)
{
if (IssueDate_v == null)
{
sql = "select EventTime from JOURNAL_DocInvoice where DocInvoice_ID = " + AddOnDI.DocInvoice_Reference_ID_v.v.ToString() + " and JOURNAL_DocInvoice_Type_ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.ID.ToString();
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count == 1)
{
IssueDate_v = DBTypes.tf.set_DateTime(dt.Rows[0]["EventTime"]);
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! EventTime for InvoiceTime must be defined!");
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:sql=" + sql + "\r\nERR=" + Err);
}
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! DocInvoice_Reference_ID_v must be defined!");
}
}
else
{
if (IssueDate_v == null)
{
sql = "select EventTime from JOURNAL_DocInvoice where DocInvoice_ID = " + DocInvoice_ID.ToString() + " and JOURNAL_DocInvoice_Type_ID = " + GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.ID.ToString();
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count > 0)
{
IssueDate_v = DBTypes.tf.set_DateTime(dt.Rows[0]["EventTime"]);
if (dt.Rows.Count != 1)
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! EventTime for InvoiceTime must be defined!");
}
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:sql=" + sql + "\r\nERR=" + Err);
}
}
this.m_eType = eType.UNKNOWN;
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! EventName must be defined!");
}
}
else if (IsDocProformaInvoice)
{
if (EventName_v != null)
{
if (EventName_v.v.Equals("ProformaInvoiceTime"))
{
this.m_eType = eType.INVOICE;
this.IssueDate_v = EventTime_v.Clone();
}
else
{
if (IssueDate_v == null)
{
sql = "select EventTime from JOURNAL_DocProformaInvoice where DocProformaInvoice_ID = " + DocInvoice_ID.ToString() + " and JOURNAL_DocProformaInvoice_Type_ID = " + GlobalData.JOURNAL_DocProformaInvoice_Type_definitions.ProformaInvoiceTime.ID.ToString();
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count == 1)
{
IssueDate_v = DBTypes.tf.set_DateTime(dt.Rows[0]["EventTime"]);
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! EventTime for InvoiceTime must be defined!");
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:sql=" + sql + "\r\nERR=" + Err);
}
}
this.m_eType = eType.UNKNOWN;
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:this error should not happen! EventName must be defined!");
}
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:Read_DocInvoice:DocInvoice="+DocInvoice+" not implemented.");
}
}
else
{
this.m_eType = eType.UNKNOWN;
}
}
if (IsDocInvoice)
{
if (AddOnDI.Invoice_Reference_Type_v != null)
{
if (AddOnDI.Invoice_Reference_Type_v.v.Equals("STORNO"))
{
if (AddOnDI.DocInvoice_Reference_ID_v != null)
{
AddOnDI.bInvoiceStorno = true;
}
else
{
LogFile.Error.Show("ERROR:usrc_Invoice_Preview:Read_DocProformaInvoice:DocProformaInvoice_Reference_ID_v can not be null when Invoice_Reference_Type_v equals 'STORNO'");
}
}
}
}
GrossSum = DBTypes.tf._set_decimal(dt_DocInvoice.Rows[0]["GrossSum"]);
taxsum = DBTypes.tf._set_decimal(dt_DocInvoice.Rows[0]["TaxSum"]);
NetSum = DBTypes.tf._set_decimal(dt_DocInvoice.Rows[0]["NetSum"]);
if (IsDocInvoice)
{
if (AddOnDI.bInvoiceStorno)
{
if (GrossSum > 0) GrossSum = GrossSum * -1;
if (taxsum > 0) taxsum = taxsum * -1;
if (NetSum > 0) NetSum = NetSum * -1;
}
if (AddOnDI.b_FVI_SLO)
{
//this.FVI_SLO_RealEstateBP = new UniversalInvoice.FVI_SLO_RealEstateBP(lngToken.st_Invoice,
// DBTypes.tf._set_int(dt_DocProformaInvoice.Rows[0]["BuildingNumber"]),
// DBTypes.tf._set_int(dt_DocProformaInvoice.Rows[0]["BuildingSectionNumber"]),
// DBTypes.tf._set_string(dt_DocProformaInvoice.Rows[0]["Community"]),
// DBTypes.tf._set_int(dt_DocProformaInvoice.Rows[0]["CadastralNumber"]),
// DBTypes.tf._set_DateTime(dt_DocProformaInvoice.Rows[0]["ValidityDate"]),
// DBTypes.tf._set_string(dt_DocProformaInvoice.Rows[0]["ClosingTag"]),
// DBTypes.tf._set_string(dt_DocProformaInvoice.Rows[0]["SoftwareSupplier_TaxNumber"]),
// DBTypes.tf._set_string(dt_DocProformaInvoice.Rows[0]["PremiseType"]) );
}
}
//byte[] barr_logoData = (byte[])dt_DocProformaInvoice.Rows[0]["Logo_Data"];
MyOrganisation = new UniversalInvoice.Organisation(lngToken.st_My, DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Name"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Tax_ID"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Registration_ID"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Atom_Office_Name"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["BankName"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["TRR"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Email"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["HomePage"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["PhoneNumber"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["FaxNumber"]),
DBTypes.tf._set_byte_array(dt_DocInvoice.Rows[0]["Logo_Data"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["StreetName"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["HouseNumber"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["ZIP"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["City"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["Country"]),
DBTypes.tf._set_string(dt_DocInvoice.Rows[0]["State"]));
FinancialYear = DBTypes.tf._set_int(dt_DocInvoice.Rows[0]["FinancialYear"]);
NumberInFinancialYear = DBTypes.tf._set_int(dt_DocInvoice.Rows[0]["NumberInFinancialYear"]);
if (IsDocInvoice)
{
if (AddOnDI.b_FVI_SLO)
{
if (!Draft)
{
AddOnDI.m_FURS.FURS_ZOI_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$MessageID"]);
AddOnDI.m_FURS.FURS_EOR_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$UniqueInvoiceID"]);
AddOnDI.m_FURS.FURS_QR_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$BarCodeValue"]);
AddOnDI.m_FURS.FURS_SalesBookInvoice_InvoiceNumber_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$InvoiceNumber"]);
AddOnDI.m_FURS.FURS_SalesBookInvoice_SetNumber_v = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$SetNumber"]);
AddOnDI.m_FURS.FURS_SalesBookInvoice_SerialNumber = DBTypes.tf.set_string(dt_DocInvoice.Rows[0]["JOURNAL_DocInvoice_$_dinv_$_fvisbi_$$SerialNumber"]);
}
}
}
object oAtom_MyOrganisation_Person_ID = dt_DocInvoice.Rows[0]["Atom_MyOrganisation_Person_ID"];
if (oAtom_MyOrganisation_Person_ID is long)
{
long Atom_MyOrganisation_Person_ID = (long)oAtom_MyOrganisation_Person_ID;
Invoice_Author = f_Atom_Person.GetData(lngToken.st_IssuerOfInvoice, Atom_MyOrganisation_Person_ID);
}
object oAtom_Customer_Org_ID = dt_DocInvoice.Rows[0]["Atom_Customer_Org_ID"];
if (oAtom_Customer_Org_ID is long)
{
long Atom_Customer_Org_ID = (long)oAtom_Customer_Org_ID;
CustomerOrganisation = f_Atom_Customer_Org.GetData(lngToken.st_Customer, Atom_Customer_Org_ID);
}
else
{
CustomerOrganisation = new UniversalInvoice.Organisation(lngToken.st_Customer);
}
if (dt_DocInvoice.Rows[0]["Atom_Customer_Person_ID"] is long)
{
long Atom_Customer_Person_ID = (long)dt_DocInvoice.Rows[0]["Atom_Customer_Person_ID"];
CustomerPerson = f_Atom_Customer_Person.GetData(lngToken.st_Customer, Atom_Customer_Person_ID);
}
else
{
CustomerPerson = new UniversalInvoice.Person(lngToken.st_Customer);
}
long xDoc_ID = DocInvoice_ID;
if (IsDocInvoice)
{
if (AddOnDI.DocInvoice_Reference_ID_v != null)
{
xDoc_ID = AddOnDI.DocInvoice_Reference_ID_v.v;
}
}
if (dbfunc.Read_ShopA_Price_Item_Table(DocInvoice,xDoc_ID, ref dt_ShopA_Items))
{
if (m_ShopABC.Read_ShopB_Price_Item_Table(xDoc_ID, ref dt_ShopB_Items))
{
List<object> xDocProformaInvoice_ShopC_Item_Data_LIST = new List<object>();
if (this.m_eType == eType.STORNO)
{
if (!m_ShopABC.m_CurrentInvoice.m_Basket.Read_ShopC_Price_Item_Stock_Table(DocInvoice,xDoc_ID, ref xDocProformaInvoice_ShopC_Item_Data_LIST))
{
return false;
}
}
else
{
xDocProformaInvoice_ShopC_Item_Data_LIST = m_ShopABC.m_CurrentInvoice.m_Basket.m_DocInvoice_ShopC_Item_Data_LIST;
}
int iCountShopAItemsSold = dt_ShopA_Items.Rows.Count;
int iCountShopBItemsSold = dt_ShopB_Items.Rows.Count;
int iCountShopCItemsSold = xDocProformaInvoice_ShopC_Item_Data_LIST.Count;
ItemsSold = new UniversalInvoice.ItemSold[iCountShopAItemsSold + iCountShopBItemsSold + iCountShopCItemsSold];
taxSum = new StaticLib.TaxSum();
if (IsDocInvoice)
{
Fill_Sold_ShopA_ItemsData(lngToken.st_Invoice, ref ItemsSold, 0, iCountShopAItemsSold, AddOnDI.bInvoiceStorno);
Fill_Sold_ShopB_ItemsData(lngToken.st_Invoice, ref ItemsSold, iCountShopAItemsSold, iCountShopBItemsSold, AddOnDI.bInvoiceStorno);
Fill_Sold_ShopC_ItemsData(xDocProformaInvoice_ShopC_Item_Data_LIST, lngToken.st_Invoice, ref ItemsSold, iCountShopAItemsSold + iCountShopBItemsSold, iCountShopCItemsSold, AddOnDI.bInvoiceStorno);
}
InvoiceToken = new UniversalInvoice.InvoiceToken();
InvoiceToken.tFiscalYear.Set(FinancialYear.ToString());
InvoiceToken.tInvoiceNumber.Set(NumberInFinancialYear.ToString());
InvoiceToken.tCashier.Set(CasshierName);
InvoiceToken.tStorno.Set("");
if (IsDocInvoice)
{
if (AddOnDI.bInvoiceStorno)
{
InvoiceToken.tStorno.Set(lngRPM.s_STORNO.s);
}
}
if (!Draft)
{
string stime = IssueDate_v.v.Day.ToString() + "."
+ IssueDate_v.v.Month.ToString() + "."
+ IssueDate_v.v.Year.ToString() + " "
+ IssueDate_v.v.Hour.ToString() + ":"
+ IssueDate_v.v.Minute.ToString();
InvoiceToken.tDateOfIssue.Set(stime);
InvoiceToken.tDateOfMaturity.Set(stime);
}
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
catch (Exception ex)
{
LogFile.Error.Show("ERROR:usrc_Invoice_Preview:Read_DocProformaInvoice:Exception=" + ex.Message);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:usrc_Invoice_Preview:Read_DocProformaInvoice:dt_DocProformaInvoice.Rows.Count != 1! for DocProformaInvoice_ID=" + DocInvoice_ID.ToString() + "!\r\nsql = " + sql);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:usrc_Invoice_Preview:Read_DocProformaInvoice:Err=" + Err);
return false;
}
}
public void Print_ProformaInvoice(InvoiceData m_InvoiceData,
GlobalData.ePaymentType ePaymentType,
string sPaymentMethod,
string sBank,
string sBankAccount,
string sTermsOfPayment_Description,
long DurationType,
long Duration,
DateTime_v issue_time)
{
Printer selected_printer = null;
if (SelectPrinter(m_InvoiceData, ref selected_printer))
{
selected_printer.Print_ProformaInvoice(m_InvoiceData,
2,
ePaymentType,
sPaymentMethod,
sBank,
sBankAccount,
sTermsOfPayment_Description,
DurationType,
Duration,
issue_time
);
}
}
private void btn_Print_Click(object sender, EventArgs e)
{
DateTime dtInvoiceTime = DateTime.MinValue;
if (GetInvoiceTime(ref dtInvoiceTime))
{
if (DocInvoiceTime_v == null)
{
DocInvoiceTime_v = new DateTime_v();
}
DocInvoiceTime_v.v = dtInvoiceTime;
m_usrc_TangentaPrint1.Print_Receipt(m_InvoiceData, GlobalData.ePaymentType.NONE, null, null, null, DocInvoiceTime_v);
ShowJournal();
}
}
public bool SetInvoiceTime(DateTime_v issue_time)
{
if (issue_time != null)
{
long Journal_DocInvoice_ID = -1;
return f_Journal_DocInvoice.Write(this.Doc_ID, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.ID, issue_time, ref Journal_DocInvoice_ID);
}
else
{
LogFile.Error.Show("ERROR:CurrentInvoice:SetDocInvoiceTime:issue_time is null");
return false;
}
}
public static DateTime_v set_DateTime(object p)
{
DateTime_v x = null;
if (p == null) return null;
if (p.GetType() == typeof(DateTime))
{
x = new DateTime_v((DateTime)p);
}
else if (!(p is System.DBNull))
{
tf.ShowTypeError(p.GetType().ToString(), x.GetType().ToString());
}
return x;
}
public static bool Update(long currentStock_ID,
DateTime tImportTime,
decimal dQuantity,
DateTime_v tExpiry_v,
long PurchasePrice_Item_ID,
long Stock_AddressLevel1_ID,
string Description)
{
string Err = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
string spar_ImportTime = "@par_ImportTime";
SQL_Parameter par_ImportTime = new SQL_Parameter(spar_ImportTime, SQL_Parameter.eSQL_Parameter.Datetime, false, tImportTime);
lpar.Add(par_ImportTime);
string spar_dQuantity = "@par_dQuantity";
SQL_Parameter par_dQuantity = new SQL_Parameter(spar_dQuantity, SQL_Parameter.eSQL_Parameter.Decimal, false, dQuantity);
lpar.Add(par_dQuantity);
string spar_tExpiry = "null";
if (tExpiry_v != null)
{
spar_tExpiry = "@par_tExpiry";
SQL_Parameter par_tExpiry = new SQL_Parameter(spar_tExpiry, SQL_Parameter.eSQL_Parameter.Datetime, false, tExpiry_v.v);
lpar.Add(par_tExpiry);
}
string spar_PurchasePrice_Item_ID = "@par_PurchasePrice_Item_ID";
SQL_Parameter par_PurchasePrice_Item_ID = new SQL_Parameter(spar_PurchasePrice_Item_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, PurchasePrice_Item_ID);
lpar.Add(par_PurchasePrice_Item_ID);
string spar_Stock_AddressLevel1_ID = "null";
if (Stock_AddressLevel1_ID >= 0)
{
spar_Stock_AddressLevel1_ID = "@par_Stock_AddressLevel1_ID";
SQL_Parameter par_Stock_AddressLevel1_ID = new SQL_Parameter(spar_Stock_AddressLevel1_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, Stock_AddressLevel1_ID);
lpar.Add(par_Stock_AddressLevel1_ID);
}
string spar_Description = "null";
if (Description != null)
{
if (Description.Length > 0)
{
spar_Description = "@par_Description";
SQL_Parameter par_Description = new SQL_Parameter(spar_Description, SQL_Parameter.eSQL_Parameter.Nvarchar, false, Description);
lpar.Add(par_Description);
}
}
string sql = "Update Stock set ImportTime = " + spar_ImportTime
+ ",dQuantity = " + spar_dQuantity
+ ",ExpiryDate = " + spar_tExpiry
+ ",PurchasePrice_Item_ID = " + spar_PurchasePrice_Item_ID
+ ",Stock_AddressLevel1_ID = " + spar_Stock_AddressLevel1_ID
+ ",description = " + spar_Description
+ " where ID = " + currentStock_ID.ToString();
object oret = null;
if (DBSync.DBSync.ExecuteNonQuerySQL(sql, lpar, ref oret, ref Err))
{
return true;
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:f_Stock:Update:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
public void Set(System.Data.DataRow dria)
{
Stock_ID = tf.set_long(dria["Stock_ID"]);
Stock_ImportTime = tf.set_DateTime(dria["Stock_ImportTime"]);
Stock_ExpiryDate = tf.set_DateTime(dria["Stock_ExpiryDate"]);
dQuantity = tf.set_decimal(dria["dQuantity"]);
}
public static bool Get(bool_v Person_Gender_v,
string_v FirstName_v,
string_v LastName_v,
DateTime_v DateOfBirth_v,
string_v Tax_ID_v,
string_v Registration_ID_v,
ref long_v Person_ID_v)
{
string Err = null;
string Gender_condition = null;
string sGender_value = null;
string cFirstName_ID_condition = null;
string cLastName_ID_condition = null;
string Tax_ID_condition = null;
string Registration_ID_condition = null;
string DateOfBirth_condition = null;
string scFirstName_ID_value = null;
string scLastName_ID_value = null;
string sTaxID_value = null;
string sRegistration_ID_value = null;
string sDateOfBirth_value = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
long cFirstName_ID = -1;
if (f_cFirstName.Get(FirstName_v, ref cFirstName_ID))
{
long cLastName_ID = -1;
if (f_cLastName.Get(LastName_v, ref cLastName_ID))
{
if (Person_Gender_v != null)
{
string spar_Gender = "@par_Gender";
SQL_Parameter par_Gender = new SQL_Parameter(spar_Gender, SQL_Parameter.eSQL_Parameter.Bit, false, Person_Gender_v.v);
lpar.Add(par_Gender);
Gender_condition = " Gender = " + spar_Gender + " ";
sGender_value = spar_Gender;
}
else
{
Gender_condition = " Gender is null ";
sGender_value = "null";
}
if (cFirstName_ID >= 0)
{
string spar_cFirstName_ID = "@par_cFirstName_ID";
SQL_Parameter par_FirstName = new SQL_Parameter(spar_cFirstName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cFirstName_ID);
lpar.Add(par_FirstName);
cFirstName_ID_condition = " cFirstName_ID = " + spar_cFirstName_ID + " ";
scFirstName_ID_value = spar_cFirstName_ID;
}
else
{
cFirstName_ID_condition = " cFirstName_ID is null ";
scFirstName_ID_value = "null";
}
if (cLastName_ID >= 0)
{
string spar_cLastName_ID = "@par_cLastName_ID";
SQL_Parameter par_LastName = new SQL_Parameter(spar_cLastName_ID, SQL_Parameter.eSQL_Parameter.Bigint, false, cLastName_ID);
lpar.Add(par_LastName);
cLastName_ID_condition = " cLastName_ID = " + spar_cLastName_ID + " ";
scLastName_ID_value = spar_cLastName_ID;
}
else
{
cLastName_ID_condition = " cLastName_ID is null ";
scLastName_ID_value = "null";
}
if (Tax_ID_v != null)
{
SQL_Parameter par_Tax_ID = new SQL_Parameter("@par_Tax_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Tax_ID_v.v);
lpar.Add(par_Tax_ID);
Tax_ID_condition = " Tax_ID = " + par_Tax_ID.Name + " ";
sTaxID_value = "@par_Tax_ID";
}
else
{
Tax_ID_condition = " Tax_ID is null ";
sTaxID_value = "null";
}
if (Registration_ID_v != null)
{
SQL_Parameter par_Registration_ID = new SQL_Parameter("@par_Registration_ID", SQL_Parameter.eSQL_Parameter.Nvarchar, false, Registration_ID_v.v);
lpar.Add(par_Registration_ID);
Registration_ID_condition = " Registration_id = " + par_Registration_ID.Name + " ";
sRegistration_ID_value = "@par_Registration_ID";
}
else
{
Registration_ID_condition = " Registration_ID is null ";
sRegistration_ID_value = "null";
}
if (DateOfBirth_v != null)
{
string spar_DateOfBirth = "@par_DateOfBirth";
SQL_Parameter par_DateOfBirth = new SQL_Parameter(spar_DateOfBirth, SQL_Parameter.eSQL_Parameter.Datetime, false, DateOfBirth_v.v);
lpar.Add(par_DateOfBirth);
DateOfBirth_condition = " DateOfBirth = " + spar_DateOfBirth + " ";
sDateOfBirth_value = spar_DateOfBirth;
}
else
{
DateOfBirth_condition = " DateOfBirth is null ";
sDateOfBirth_value = "null";
}
string sql_select = "select ID from Person where " + Gender_condition + @" and
" + cFirstName_ID_condition + @" and
" + cLastName_ID_condition + @" and
" + DateOfBirth_condition + @" and
" + Tax_ID_condition + @" and
" + Registration_ID_condition;
DataTable dt = new DataTable();
if (DBSync.DBSync.ReadDataTable(ref dt, sql_select, lpar, ref Err))
{
if (dt.Rows.Count > 0)
{
if (Person_ID_v == null)
{
Person_ID_v = new long_v();
}
Person_ID_v.v = (long)dt.Rows[0]["ID"];
return true;
}
else
{
string sql_insert = @" insert into Person (Gender,
cFirstName_ID,
cLastName_ID,
DateOfBirth,
Tax_ID,
Registration_ID) values (" + sGender_value + ","
+ scFirstName_ID_value + ","
+ scLastName_ID_value + ","
+ sDateOfBirth_value + ","
+ sTaxID_value + ","
+ sRegistration_ID_value + ")";
object oret = null;
long Person_ID = -1;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref Person_ID, ref oret, ref Err, "Person"))
{
if (Person_ID_v == null)
{
Person_ID_v = new long_v();
}
Person_ID_v.v = Person_ID;
return true;
}
else
{
LogFile.Error.Show("ERROR:f_Person:Get:sql=" + sql_insert + "\r\nErr=" + Err);
}
}
}
else
{
LogFile.Error.Show("ERROR:f_Person:Getn:sql=" + sql_select + "\r\nErr=" + Err);
}
}
}
return false;
}
internal bool Write2DB(Database_Upgrade_WindowsForm_Thread wfp_ui_thread,UpgradeDB_inThread.eUpgrade eUpgr,Old_tables_1_04_to_1_05 m_Old_tables_1_04_to_1_05)
{
string Err = null;
foreach (TableDataItem xtdi in fkey_TableDataItem_List)
{
xtdi.Write2DB(wfp_ui_thread, eUpgr, m_Old_tables_1_04_to_1_05);
}
if (eUpgr == UpgradeDB_inThread.eUpgrade.from_1_04_to_105)
{
if (this.tbl.TableName.ToLower().Equals("pricelist"))
{
if (GlobalData.Office_ID<0)
{
string sql = "insert into Office (myOrganisation_ID,Name)values(1,'P1')";
object oret = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql,null,ref GlobalData.Office_ID,ref oret, ref Err,"Office"))
{
sql = "insert into myOrganisation_Person (UserName,Password,Job,Active,Description,Person_ID,Office_ID)values('marjetkah',null,'Direktor',1,'Direktorica in lastnica podjetja',1,1)";
long x_myOrganisation_Person_ID = -1;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, null, ref x_myOrganisation_Person_ID, ref oret, ref Err, "Office"))
{
}
else
{
LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
}
else if (this.tbl.TableName.ToLower().Equals("atom_pricelist"))
{
string sql = null;
object oret = null;
if (GlobalData.Atom_Office_ID < 0)
{
sql = "insert into Atom_Office (Atom_myOrganisation_ID,Name)values(1,'P1')";
if (!DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, null, ref GlobalData.Atom_Office_ID, ref oret, ref Err, "Atom_Office"))
{
LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
DateTime dtStart = new DateTime(2015, 4, 29);
DateTime_v dtEnd_v = new DateTime_v();
dtEnd_v.v = DateTime.Now;
if (!GlobalData.GetWorkPeriodOld(f_Atom_WorkPeriod.sWorkPeriod_DB_ver_1_04,null,dtStart,dtEnd_v, ref Err))
{
return false;
}
}
else if (this.tbl.TableName.ToLower().Equals("docinvoice"))
{
DateTime dtStart = new DateTime(2015, 4, 29);
DateTime_v dtEnd_v = new DateTime_v();
dtEnd_v.v = DateTime.Now;
GlobalData.GetWorkPeriodOld(f_Atom_WorkPeriod.sWorkPeriod_DB_ver_1_04, null, dtStart, dtEnd_v, ref Err);
}
}
string tname = tbl.TableName;
string sql_insert_columns = null;
string sql_insert_values = null;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
bool bDocInvoiceTime = false;
bool bFirstPrintTime = false;
bool bPaid = false;
bool bStorno = false;
foreach (DataRow dr in dt.Rows)
{
if (dr["old_id"] is System.DBNull)
{
wfp_ui_thread.Message(lngRPM.s_ImportData.s + ":" + tname);
sql_insert_columns = null;
sql_insert_values = null;
lpar.Clear();
long old_id = (long)dr["id"];
DateTime_v InvoiceTime_v = null;
DateTime_v PaidTime_v = null;
DateTime_v StornoTime_v = null;
foreach (DataColumn dcol in dt.Columns)
{
if (dcol.ColumnName.ToUpper().Equals("ID") || dcol.ColumnName.ToUpper().Equals("OLD_ID"))
{
continue;
}
else
{
if (eUpgr == UpgradeDB_inThread.eUpgrade.from_1_04_to_105)
{
if (dcol.ColumnName.ToLower().Equals("myorganisation_person_id"))
{
continue;
}
if (this.tbl.TableName.ToLower().Equals("atom_pricelist"))
{
if (dcol.ColumnName.ToLower().Equals("atom_myorganisation_person_id"))
{
continue;
}
}
else
{
if (this.tbl.TableName.ToLower().Equals("docinvoice"))
{
if (dcol.ColumnName.ToLower().Equals("atom_myorganisation_person_id"))
{
continue;
}
}
}
}
}
object o = dr[dcol];
string sparname = null;
SQL_Parameter par = null;
if (new_SQL_Parameter(this, dr, dcol, ref sparname, o, ref par))
{
if (dcol.ColumnName.ToLower().Equals("paid"))
{
bPaid = true;
}
if (dcol.ColumnName.ToLower().Equals("storno"))
{
bStorno = true;
}
if (dcol.ColumnName.ToLower().Equals("firstprinttime"))
{
bFirstPrintTime = true;
}
else if (dcol.ColumnName.ToLower().Equals("docinvoicetime"))
{
bDocInvoiceTime = true;
}
else
{
if (par != null)
{
lpar.Add(par);
}
if (sql_insert_columns == null)
{
sql_insert_columns = dcol.ColumnName;
}
else
{
sql_insert_columns += "," + dcol.ColumnName;
}
if (sql_insert_values == null)
{
sql_insert_values = sparname;
}
else
{
sql_insert_values += "," + sparname;
}
}
}
else
{
return false;
}
}
if (bDocInvoiceTime)
{
if (dr["docinvoicetime"] is DateTime)
{
InvoiceTime_v = new DateTime_v();
InvoiceTime_v.v = (DateTime)dr["docinvoicetime"];
}
}
if (bPaid)
{
if (dr["Paid"] is bool)
{
PaidTime_v = new DateTime_v();
PaidTime_v.v = GetDocInvoiceTime(old_id,m_Old_tables_1_04_to_1_05);
}
}
if (bStorno)
{
if (dr["Storno"] is bool)
{
if ((bool)dr["Storno"])
{
StornoTime_v = new DateTime_v();
StornoTime_v.v = GetInvoiceStornoTime(old_id, m_Old_tables_1_04_to_1_05);
}
else
{
bStorno = false;
}
}
}
string sql_insert = " insert into " + tname + " (" + sql_insert_columns + ") values (" + sql_insert_values + ")";
long new_id = -1;
object ores = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref new_id, ref ores, ref Err, tname))
{
dr["OLD_ID"] = old_id;
dr["id"] = new_id;
if (tname.ToLower().Equals("docinvoice"))
{
long Journal_DocInvoice_ID = -1;
f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.Description, InvoiceTime_v, ref Journal_DocInvoice_ID);
if (dr["Draft"] is bool)
{
if (!(bool)dr["Draft"])
{
f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceTime.Description ,InvoiceTime_v, ref Journal_DocInvoice_ID);
f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoicePaidTime.Name, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoicePaidTime.Description, InvoiceTime_v, ref Journal_DocInvoice_ID);
}
}
}
else if (tname.ToLower().Equals("invoice"))
{
long Journal_Invoice_ID = -1;
f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, "Paid", "Plačano", PaidTime_v, ref Journal_Invoice_ID);
if (bStorno)
{
f_Journal_DocInvoice.Write(new_id, GlobalData.Atom_WorkPeriod_ID, "Storno*", "Napaka pri vnosu", StornoTime_v, ref Journal_Invoice_ID);
}
}
}
else
{
LogFile.Error.Show("ERROR:usrc_Upgrade:Write2DB:Err=" + Err);
return false;
}
}
}
return true;
}
public static bool GetWorkPeriod(string Atom_WorkPeriod_Type_Name,
string x_Atom_WorkPeriod_Type_Description,
string ElectronicDevice_Name,
string ElectronicDevice_Description,
DateTime dtStart,
DateTime_v dtEnd_v,
ref string Err)
{
if (Atom_WorkPeriod_ID < 0)
{
if (Atom_myOrganisation_Person_ID < 0)
{
string_v office_name = null;
if (f_Atom_myOrganisation_Person.Get(1, ref Atom_myOrganisation_Person_ID, ref office_name))
{
if (f_WorkingPlace.Get(office_name.v, "Tangenta 1", ref WorkingPlace_ID))
{
if (f_Atom_WorkingPlace.Get(GlobalData.WorkingPlace_ID, ref Atom_WorkingPlace_ID))
{
if (f_Atom_Computer.Get(ref GlobalData.Atom_Computer_ID))
{
if (f_Atom_ElectronicDevice.Get(ElectronicDevice_Name, ElectronicDevice_Description, ref GlobalData.Atom_ElectronicDevice_ID))
{
string Atom_WorkPeriod_Type_Description = x_Atom_WorkPeriod_Type_Description;
if (Atom_WorkPeriod_Type_Name.Equals(f_Atom_WorkPeriod.sWorkPeriod_DB_ver_1_04))
{
Atom_WorkPeriod_Type_Description = "Stari šiht od 29.4.2015 do " + dtEnd_v.v.Day.ToString() + "." + dtEnd_v.v.Month.ToString() + "." + dtEnd_v.v.Year.ToString();
}
if (f_Atom_WorkPeriod.Get(Atom_WorkPeriod_Type_Name, Atom_WorkPeriod_Type_Description, Atom_myOrganisation_Person_ID, Atom_WorkingPlace_ID, Atom_Computer_ID,Atom_ElectronicDevice_ID, dtStart, dtEnd_v, ref Atom_WorkPeriod_ID))
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
}
return true;
}
public void Print_Receipt(InvoiceData m_InvoiceData, GlobalData.ePaymentType ePaymentType, string sPaymentMethod, string sAmountReceived, string sToReturn, DateTime_v issue_time)
{
}
internal void Print_Receipt(InvoiceData xInvoiceData,
string FursD_BussinesPremiseID,
string ElectronicDevice_ID,
int BaseCurrencyDecimalPlaces,
GlobalData.ePaymentType PaymentType, string sPaymentMethod, string sAmountReceived, string sToReturn, DateTime_v issue_time,
NavigationButtons.Navigation nav)
{
if (Printer_is_ESC_POS())
{
Print_Receipt_ESC_POS(xInvoiceData, FursD_BussinesPremiseID,ElectronicDevice_ID, BaseCurrencyDecimalPlaces, PaymentType, sPaymentMethod, sAmountReceived, sToReturn, issue_time);
}
else
{
Form_Print_A4 print_A4_dlg = new Form_Print_A4(xInvoiceData, PaymentType, sPaymentMethod, sAmountReceived, sToReturn, issue_time, nav);
print_A4_dlg.ShowDialog();
}
}
public bool SetNewDraft_DocInvoice(int iFinancialYear, Control pParent, ref long DocInvoice_ID,
long myOrganisation_Person_ID,
string DocInvoice,
ref string Err)
{
DataTable dt = new DataTable();
int xDraftNumber = -1;
int iLimit = 1;
string sql = @"select " + DBSync.DBSync.sTop(iLimit) + "DraftNumber from "+DocInvoice+" order by DraftNumber desc " + DBSync.DBSync.sLimit(iLimit);
if (!DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
LogFile.Error.Show("ERROR:TangentaDB:SetNewDraft:sql=" + sql + "\r\nErr=" + Err);
return false;
}
if (dt.Rows.Count > 0)
{
xDraftNumber = (int)dt.Rows[0]["DraftNumber"];
xDraftNumber++;
}
else
{
xDraftNumber = 0;
}
dt.Clear();
dt.Columns.Clear();
sql = @"select " + DBSync.DBSync.sTop(iLimit) + "ID,DraftNumber from "+DocInvoice+" where FinancialYear = " + iFinancialYear.ToString() + " order by DraftNumber desc " + DBSync.DBSync.sLimit(iLimit);
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count == 1)
{
//Draft already set
try
{
DocInvoice_ID = (long)dt.Rows[0]["ID"];
}
catch (Exception ex)
{
LogFile.Error.Show("ERROR:TangentaDB:SetNewDraft: ID is not defined in "+DocInvoice+"! Exception =" + ex.Message);
return false;
}
}
long Atom_myOrganisation_Person_ID = -1;
m_CurrentInvoice.FinancialYear = iFinancialYear;
m_CurrentInvoice.DraftNumber = xDraftNumber;
string_v office_name = null;
if (f_Atom_myOrganisation_Person.Get(myOrganisation_Person_ID, ref Atom_myOrganisation_Person_ID, ref office_name))
{
//**TODO
string sql_SetDraftDocInvoice = null;
if (IsDocInvoice)
{
sql_SetDraftDocInvoice = "insert into " + DocInvoice
+ "("
+ DBtcn.GetName(td.m_DocInvoice.FinancialYear.GetType()) + ","
+ DBtcn.GetName(td.m_DocInvoice.DraftNumber.GetType()) + ","
+ DBtcn.GetName(td.m_DocInvoice.Draft.GetType()) + ","
+ DBtcn.GetName(td.m_DocInvoice.Storno.GetType())
+ @") values ( "
+ m_CurrentInvoice.FinancialYear.ToString() + ","
+ m_CurrentInvoice.DraftNumber.ToString() + ","
+ "1,"
+ "1"
+ ")";
}
else if (IsDocProformaInvoice)
{
sql_SetDraftDocInvoice = "insert into " + DocInvoice
+ "("
+ DBtcn.GetName(td.m_DocInvoice.FinancialYear.GetType()) + ","
+ DBtcn.GetName(td.m_DocInvoice.DraftNumber.GetType()) + ","
+ DBtcn.GetName(td.m_DocInvoice.Draft.GetType())
+ @") values ( "
+ m_CurrentInvoice.FinancialYear.ToString() + ","
+ m_CurrentInvoice.DraftNumber.ToString() + ","
+ "1"
+ ")";
}
else
{
Err="ERROR:SetDraft:DocInvoice" + DocInvoice + " not implemented.";
LogFile.Error.Show(Err);
return false;
}
object objret = null;
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql_SetDraftDocInvoice, null, ref this.m_CurrentInvoice.Doc_ID, ref objret, ref Err, DocInvoice))
{
long Journal_DocInvoice_ID = -1;
if (IsDocInvoice)
{
return f_Journal_DocInvoice.Write(this.m_CurrentInvoice.Doc_ID, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceDraftTime.ID, null, ref Journal_DocInvoice_ID);
}
else if (IsDocProformaInvoice)
{
DateTime_v dt_v = new DateTime_v(DateTime.Now);
return f_Journal_DocProformaInvoice.Write(this.m_CurrentInvoice.Doc_ID, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocProformaInvoice_Type_definitions.ProformaInvoiceDraftTime.ID, null, ref Journal_DocInvoice_ID);
}
else
{
Err = "ERROR:SetDraft:DocInvoice" + DocInvoice + " not implemented.";
LogFile.Error.Show(Err);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:SetDraft:insert into " + DocInvoice + ":\r\nErr=" + Err);
return false;
}
}
else
{
return false;
}
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:SetNewDraft:Err=" + Err);
return false;
}
}
public bool SetInvoiceTime(DateTime_v issue_time)
{
if (m_ShopABC.m_CurrentInvoice.SetInvoiceTime(issue_time))
{
if (issue_time != null)
{
this.IssueDate_v = issue_time.Clone();
string stime = IssueDate_v.v.Day.ToString() + "."
+ IssueDate_v.v.Month.ToString() + "."
+ IssueDate_v.v.Year.ToString() + " "
+ IssueDate_v.v.Hour.ToString() + ":"
+ IssueDate_v.v.Minute.ToString();
InvoiceToken.tDateOfIssue.Set(stime);
InvoiceToken.tDateOfMaturity.Set(stime);
return true;
}
else
{
LogFile.Error.Show("ERROR:InvoiceData:SetInvoiceTime:issue_time==null!");
return false;
}
}
else
{
return false;
}
}
public bool Storno(ref long Storno_DocInvoice_ID, bool bStorno, string sReason,ref DateTime retissue_time)
{
object ores = null;
string Err = null;
DataTable dt_ProfInv = new DataTable();
string sql = @"select
Draft,
DraftNumber,
FinancialYear,
NumberInFinancialYear,
NetSum,
Discount,
EndSum,
TaxSum,
GrossSum,
Atom_Customer_Person_ID,
Atom_Customer_Org_ID,
WarrantyExist,
WarrantyConditions,
WarrantyDurationType,
WarrantyDuration,
DocDuration,
DocDurationType,
TermsOfPayment_ID,
PaymentDeadline,
MethodOfPayment_ID
Paid,
Storno,
Invoice_Reference_ID,
Invoice_Reference_Type from DocInvoice where DocInvoice.ID = " + Doc_ID.ToString();
if (DBSync.DBSync.ReadDataTable(ref dt_ProfInv, sql, ref Err))
{
int_v DraftNumber_v = tf.set_int(dt_ProfInv.Rows[0]["DraftNumber"]);
int_v FinancialYear_v = tf.set_int(dt_ProfInv.Rows[0]["FinancialYear"]);
decimal_v NetSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["NetSum"]);
decimal_v Discount_v = tf.set_decimal(dt_ProfInv.Rows[0]["Discount"]);
decimal_v EndSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["EndSum"]);
decimal_v TaxSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["TaxSum"]);
decimal_v GrossSum_v = tf.set_decimal(dt_ProfInv.Rows[0]["GrossSum"]);
long_v Atom_Customer_Person_ID_v = tf.set_long(dt_ProfInv.Rows[0]["Atom_Customer_Person_ID"]);
long_v Atom_Customer_Org_ID_v = tf.set_long(dt_ProfInv.Rows[0]["Atom_Customer_Org_ID"]);
bool_v WarrantyExist_v = tf.set_bool(dt_ProfInv.Rows[0]["WarrantyExist"]);
string_v WarrantyConditions_v = tf.set_string(dt_ProfInv.Rows[0]["WarrantyConditions"]);
int_v WarrantyDurationType_v = tf.set_int(dt_ProfInv.Rows[0]["WarrantyDurationType"]);
int_v WarrantyDuration_v = tf.set_int(dt_ProfInv.Rows[0]["WarrantyDuration"]);
long_v DocDuration_v = tf.set_long(dt_ProfInv.Rows[0]["DocDuration"]);
int_v DocDurationType_v = tf.set_int(dt_ProfInv.Rows[0]["DocDurationType"]);
long_v TermsOfPayment_ID_v = tf.set_long(dt_ProfInv.Rows[0]["TermsOfPayment_ID"]);
int iNewNumberInFinancialYear = -1;
GetNewNumberInFinancialYear(ref iNewNumberInFinancialYear);
int_v iNewNumberInFinancialYear_v = new int_v(iNewNumberInFinancialYear);
long_v Storno_Invoice_ID_v = new long_v(Doc_ID);
NetSum_v.v = -NetSum_v.v;
TaxSum_v.v = -TaxSum_v.v;
GrossSum_v.v = -GrossSum_v.v;
List<SQL_Parameter> lpar = new List<SQL_Parameter>();
sql = @"insert into DocInvoice (
Draft,
DraftNumber,
FinancialYear,
NumberInFinancialYear,
NetSum,
Discount,
EndSum,
TaxSum,
GrossSum,
Atom_Customer_Person_ID,
Atom_Customer_Org_ID,
WarrantyExist,
WarrantyConditions,
WarrantyDurationType,
WarrantyDuration,
DocDuration,
DocDurationType,
TermsOfPayment_ID,
Invoice_Reference_ID,
Storno,
Invoice_Reference_Type
)
values
(
0,"
+ GetParam("DraftNumber", ref lpar, DraftNumber_v) + ","
+ GetParam("FinancialYear", ref lpar, FinancialYear_v) + ","
+ GetParam("NumberInFinancialYear", ref lpar, iNewNumberInFinancialYear_v) + ","
+ GetParam("NetSum", ref lpar, NetSum_v) + ","
+ GetParam("Discount", ref lpar, Discount_v) + ","
+ GetParam("EndSum", ref lpar, EndSum_v) + ","
+ GetParam("TaxSum", ref lpar, TaxSum_v) + ","
+ GetParam("GrossSum", ref lpar, GrossSum_v) + ","
+ GetParam("Atom_Customer_Person_ID", ref lpar, Atom_Customer_Person_ID_v) + ","
+ GetParam("Atom_Customer_Org_ID", ref lpar, Atom_Customer_Org_ID_v) + ","
+ GetParam("WarrantyExist", ref lpar, WarrantyExist_v) + ","
+ GetParam("WarrantyConditions", ref lpar, WarrantyConditions_v) + ","
+ GetParam("WarrantyDurationType", ref lpar, WarrantyDurationType_v) + ","
+ GetParam("WarrantyDuration", ref lpar, WarrantyDuration_v) + ","
+ GetParam("DocDuration", ref lpar, DocDuration_v) + ","
+ GetParam("DocDurationType", ref lpar, DocDurationType_v) + ","
+ GetParam("TermsOfPayment_ID", ref lpar, TermsOfPayment_ID_v) + ","
+ GetParam("Invoice_Reference_ID", ref lpar, Storno_Invoice_ID_v) + @",
1,
'STORNO'
)";
if (DBSync.DBSync.ExecuteNonQuerySQLReturnID(sql, lpar, ref Storno_DocInvoice_ID, ref ores, ref Err, "DocInvoice"))
{
string sBit = "0";
if (bStorno)
{
sBit = "1";
}
sql = " update Docinvoice set Storno = " + sBit + @",
Invoice_Reference_ID = " + Storno_DocInvoice_ID.ToString() + @",
Invoice_Reference_Type = 'STORNO' where ID = " + this.Doc_ID.ToString();
if (DBSync.DBSync.ExecuteNonQuerySQL(sql, null, ref ores, ref Err))
{
long Journal_DocInvoice_ID = -1;
DateTime_v issue_time = new DateTime_v(DateTime.Now);
retissue_time = issue_time.v;
if (f_Journal_DocInvoice.Write(Storno_DocInvoice_ID, GlobalData.Atom_WorkPeriod_ID, GlobalData.JOURNAL_DocInvoice_Type_definitions.InvoiceStornoTime.ID, issue_time, ref Journal_DocInvoice_ID))
{
return true;
}
return false;
}
else
{
LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
else
{
LogFile.Error.Show("ERROR:CurrentInvoice:Storno:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
public void set(object o)
{
this.type_v = null;
if (o == null) return;
if (o is DateTime)
{
this.type_v = new DateTime_v((DateTime)o);
}
else if (o is System.DBNull)
{
return;
}
else
{
LogFile.Error.Show("ERROR:DB_Types:set:WRONG TYPE:" + o.GetType().ToString() + " should be " + this.GetType().ToString());
}
}
public bool ShowJournal()
{
string sql = @"select ID,
JOURNAL_DocInvoice_$_dinv_$$FinancialYear,
JOURNAL_DocInvoice_$_dinv_$$NumberInFinancialYear,
JOURNAL_DocInvoice_$_jpinvt_$$Name,
JOURNAL_DocInvoice_$_jpinvt_$$Description,
JOURNAL_DocInvoice_$$EventTime,
JOURNAL_DocInvoice_$_dinv_$$GrossSum,
JOURNAL_DocInvoice_$_dinv_$$TaxSum,
JOURNAL_DocInvoice_$_dinv_$$NetSum,
JOURNAL_DocInvoice_$_dinv_$_acusper_$_aper_$_acfn_$$FirstName,
JOURNAL_DocInvoice_$_dinv_$_acusper_$_aper_$_acln_$$LastName,
JOURNAL_DocInvoice_$_awperiod_$_amcper_$_aper_$_acfn_$$FirstName,
JOURNAL_DocInvoice_$_awperiod_$_amcper_$_aper_$_acln_$$LastName
from JOURNAL_DocInvoice_VIEW where JOURNAL_DocInvoice_$_dinv_$$ID = " + DocInvoice_ID.ToString() + " order by ID desc";
dt.Clear();
string Err = null;
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
dgvx_Journal_InvoicePrint.DataSource = dt;
CodeTables.SQLTable tbl = new CodeTables.SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(JOURNAL_DocInvoice)));
tbl.SetVIEW_DataGridViewImageColumns_Headers(dgvx_Journal_InvoicePrint, DBSync.DBSync.DB_for_Tangenta.m_DBTables);
dgvx_Journal_InvoicePrint.Columns["JOURNAL_DocInvoice_$_awperiod_$_amcper_$_aper_$_acfn_$$FirstName"].HeaderText = lngRPM.s_FirstNameOfPersonThatPrintedInvoice.s;
dgvx_Journal_InvoicePrint.Columns["JOURNAL_DocInvoice_$_awperiod_$_amcper_$_aper_$_acln_$$LastName"].HeaderText = lngRPM.s_LastNameOfPersonThatPrintedInvoice.s;
if (dt.Rows.Count>0)
{
if (dt.Rows[0]["JOURNAL_DocInvoice_$$EventTime"] is DateTime)
{
if (DocInvoiceTime_v==null)
{
DocInvoiceTime_v = new DateTime_v();
}
DocInvoiceTime_v.v = (DateTime)dt.Rows[0]["JOURNAL_DocInvoice_$$EventTime"];
}
}
return true;
}
else
{
LogFile.Error.Show("ERROR:usrc_PrintExistingInvoice:Init:sql=" + sql + "\r\nErr=" + Err);
return false;
}
}
internal void Print_ProformaInvoice(InvoiceData xInvoiceData,
int BaseCurrencyDecimalPlaces,
GlobalData.ePaymentType PaymentType,
string sPaymentMethod,
string sBank,
string sBankAccount,
string sTermsOfPayment_Description,
long DruationType,
long Duration,
DateTime_v issue_time
)
{
Form_Print_A4 print_A4_dlg = new Form_Print_A4(xInvoiceData, PaymentType, sPaymentMethod, DruationType, Duration, issue_time, null);
print_A4_dlg.ShowDialog();
}
