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(); }