private void BTN_LOGO_SECILENLERI_AKATAR_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SqlConnection myConnectionTable = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()); myConnectionTable.Open(); re_PROGRESS_BAR.Maximum = gridView_LIST.RowCount - 1; int[] selectedRows = gridView_LIST.GetSelectedRows(); for (int index = 0; index <= selectedRows.Length - 1; index++) { BR_PROGRESS_BAR.EditValue = index; BR_PROGRESS_BAR.Refresh(); DataRow dr = gridView_LIST.GetDataRow(selectedRows[index]); using (SqlCommand cmd = new SqlCommand()) { string HEADER_TABLE_SQL = " UPDATE [dbo].[FTR_GELEN_FATURALAR] SET [SIRKET_KODU]=@SIRKET_KODU WHERE AccCustomerPartyName=@AccCustomerPartyName "; cmd.CommandText = HEADER_TABLE_SQL; cmd.Parameters.AddWithValue("@AccCustomerPartyName", dr["AccCustomerPartyName"]); cmd.Parameters.AddWithValue("@SIRKET_KODU", BTN_FIRMA.EditValue.ToString()); cmd.Connection = myConnectionTable; SqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { //OIID = Convert.ToInt32(myReader["ID"].ToString()); } myReader.Close(); } } }
private void BTN_GIB_FATURA_INDIR_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SqlConnection myConnectionTable = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()); myConnectionTable.Open(); // string con = "Password=nabuKad_07;Persist Security Info=True;User ID=grm_sa;Initial Catalog=WeSOURCE;Data Source=10.219.168.92"; SqlConnection MySqlConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_ERP); MySqlConnection.Open(); re_PROGRESS_BAR.Maximum = ds.Tables["Header"].Rows.Count; int OIID = 0; var GUID = ""; for (int index = 0; index < ds.Tables["Header"].Rows.Count; index++) { BR_PROGRESS_BAR.EditValue = index; BR_PROGRESS_BAR.Refresh(); OIID = 0; GUID = Guid.NewGuid().ToString(); DataRow dr = ds.Tables["Header"].Rows[index]; using (SqlCommand cmd = new SqlCommand()) { string HEADER_TABLE_SQL = " INSERT INTO dbo.FTR_GELEN_FATURALAR ( FATURA_TIPI,SIRKET_KODU,UBLVersionID, CustomizationID, ProfileID, ID, CopyIndicator, UUID, IssueDate, InvoiceTypeCode, Note, DocumentCurrencyCode, LineCountNumeric, DespatchDocumentID, DespatchDocumentIssueDate, OrderReferenceID, OrderReferenceIssueDate, AdditionalDocumentID, AdditionalDocumentIssueDate, AdditionalDocumentEncode, AdditionalDocumentCharacterSetCode, AdditionalDocumentFileName, SignatureSchemeID, SignatureSignatoryPartyIdentificationSchemeID, SignatureSignatoryPartyPostalAddressRoom, SignatureSignatoryPartyPostalAddressStreetName, SignatureSignatoryPartyPostalAddressBuildingName, SignatureSignatoryPartyPostalAddressBuildingNumber, SignatureSignatoryPartyPostalAddressCitySubdivisionName, SignatureSignatoryPartyPostalAddressCityName, SignatureSignatoryPartyPostalAddressPostalZone, SignatureSignatoryPartyPostalAddressRegion, SignatureSignatoryPartyPostalAddressCountryName, SignatureDigitalSignatureAttachmentURI, AccSupplierPartyWebsiteURI, AccSupplierPartyIdentificationSchemeID, AccSupplierPartyName, AccSupplierPartyPostalAddressRoom, AccSupplierPartyPostalAddressStreetName, AccSupplierPartyPostalAddressBuildingName, AccSupplierPartyPostalAddressBuildingNumber, AccSupplierPartyPostalAddressCitySubdivisionName, AccSupplierPartyPostalAddressCityName, AccSupplierPartyPostalAddressRegion, AccSupplierPartyPostalAddressPostalZone, AccSupplierPartyPostalAddressCountryName, AccSupplierPartyTaxSchemeName, AccSupplierPartyTaxSchemeCode, AccSupplierPartyContactTelephone, AccSupplierPartyContactTelefax, AccSupplierPartyContactElectronicMail, AccCustomerPartyWebsiteURI, AccCustomerPartyIdentificationSchemeID, AccCustomerPartyName, AccCustomerPartyPostalAddressRoom, AccCustomerPartyPostalAddressBuildingName, AccCustomerPartyPostalAddressStreetName, AccCustomerPartyPostalAddressRegion, AccCustomerPartyPostalAddressBuildingNumber, AccCustomerPartyPostalAddressCitySubdivisionName, AccCustomerPartyPostalAddressCityName, AccCustomerPartyPostalAddressPostalZone, AccCustomerPartyPostalAddressCountryName, AccCustomerPartyTaxSchemeName, AccCustomerPartyTaxSchemeCode, AccCustomerPartyContactTelephone, AccCustomerPartyContactTelefax, AccCustomerPartyContactElectronicMail, PaymentMeansCode, PaymentMeansDueDate, PaymentMeansPayeeFinancialAccountID, PaymentMeansPayeeFinancialAccountCurrencyCode, PaymentMeansPayeeFinancialAccountPaymentNote, PaymentTermsNote, AllowanceChargeChargeIndicator, AllowanceChargeMultiplierFactorNumeric, AllowanceChargeAmountCurrencyID, AllowanceChargeAmount, TaxTotalTaxAmountCurrencyID, TaxTotalTaxAmount, TaxSubtotalTaxableAmountCurrencyID, TaxSubtotalTaxableAmount, TaxSubtotalTaxAmountCurrencyID, TaxSubtotalTaxAmount, TaxSubtotalPercent, TaxSubtotalTaxCategoryTaxSchemeName, TaxSubtotalTaxCategoryTaxSchemeCode, LegalMonetaryLineExtensionAmount, LegalMonetaryTaxExclusiveAmount, LegalMonetaryTaxInclusiveAmount, LegalMonetaryAllowanceTotalAmount, LegalMonetaryPayableAmount, UBLExtensionObjectSigningTime, PCount, FATURA_TXT,MUSTERI_KODU,MUSTERI_GRUBU,FATURA_TURU,MECRA_TURU,MECRA_ADI,FATURA_YENI,PLAN_KODU) " + " Values (@FATURA_TIPI,@SIRKET_KODU,@UBLVersionID,@CustomizationID,@ProfileID,@ID,@CopyIndicator,@UUID,@IssueDate,@InvoiceTypeCode,@Note,@DocumentCurrencyCode,@LineCountNumeric,@DespatchDocumentID,@DespatchDocumentIssueDate,@OrderReferenceID,@OrderReferenceIssueDate,@AdditionalDocumentID,@AdditionalDocumentIssueDate,@AdditionalDocumentEncode,@AdditionalDocumentCharacterSetCode,@AdditionalDocumentFileName,@SignatureSchemeID,@SignatureSignatoryPartyIdentificationSchemeID,@SignatureSignatoryPartyPostalAddressRoom,@SignatureSignatoryPartyPostalAddressStreetName,@SignatureSignatoryPartyPostalAddressBuildingName,@SignatureSignatoryPartyPostalAddressBuildingNumber,@SignatureSignatoryPartyPostalAddressCitySubdivisionName,@SignatureSignatoryPartyPostalAddressCityName,@SignatureSignatoryPartyPostalAddressPostalZone,@SignatureSignatoryPartyPostalAddressRegion,@SignatureSignatoryPartyPostalAddressCountryName,@SignatureDigitalSignatureAttachmentURI,@AccSupplierPartyWebsiteURI,@AccSupplierPartyIdentificationSchemeID,@AccSupplierPartyName,@AccSupplierPartyPostalAddressRoom,@AccSupplierPartyPostalAddressStreetName,@AccSupplierPartyPostalAddressBuildingName,@AccSupplierPartyPostalAddressBuildingNumber,@AccSupplierPartyPostalAddressCitySubdivisionName,@AccSupplierPartyPostalAddressCityName,@AccSupplierPartyPostalAddressRegion,@AccSupplierPartyPostalAddressPostalZone,@AccSupplierPartyPostalAddressCountryName,@AccSupplierPartyTaxSchemeName,@AccSupplierPartyTaxSchemeCode,@AccSupplierPartyContactTelephone,@AccSupplierPartyContactTelefax,@AccSupplierPartyContactElectronicMail,@AccCustomerPartyWebsiteURI,@AccCustomerPartyIdentificationSchemeID,@AccCustomerPartyName,@AccCustomerPartyPostalAddressRoom,@AccCustomerPartyPostalAddressBuildingName,@AccCustomerPartyPostalAddressStreetName,@AccCustomerPartyPostalAddressRegion,@AccCustomerPartyPostalAddressBuildingNumber,@AccCustomerPartyPostalAddressCitySubdivisionName,@AccCustomerPartyPostalAddressCityName,@AccCustomerPartyPostalAddressPostalZone,@AccCustomerPartyPostalAddressCountryName,@AccCustomerPartyTaxSchemeName,@AccCustomerPartyTaxSchemeCode,@AccCustomerPartyContactTelephone,@AccCustomerPartyContactTelefax,@AccCustomerPartyContactElectronicMail,@PaymentMeansCode,@PaymentMeansDueDate,@PaymentMeansPayeeFinancialAccountID,@PaymentMeansPayeeFinancialAccountCurrencyCode,@PaymentMeansPayeeFinancialAccountPaymentNote,@PaymentTermsNote,@AllowanceChargeChargeIndicator,@AllowanceChargeMultiplierFactorNumeric,@AllowanceChargeAmountCurrencyID,@AllowanceChargeAmount,@TaxTotalTaxAmountCurrencyID,@TaxTotalTaxAmount,@TaxSubtotalTaxableAmountCurrencyID,@TaxSubtotalTaxableAmount,@TaxSubtotalTaxAmountCurrencyID,@TaxSubtotalTaxAmount,@TaxSubtotalPercent,@TaxSubtotalTaxCategoryTaxSchemeName,@TaxSubtotalTaxCategoryTaxSchemeCode,@LegalMonetaryLineExtensionAmount,@LegalMonetaryTaxExclusiveAmount,@LegalMonetaryTaxInclusiveAmount,@LegalMonetaryAllowanceTotalAmount,@LegalMonetaryPayableAmount,@UBLExtensionObjectSigningTime,@PCount, @FATURA_TXT,@MUSTERI_KODU,@MUSTERI_GRUBU,@FATURA_TURU,@MECRA_TURU,@MECRA_ADI,@FATURA_YENI,@PLAN_KODU)" + " SELECT @@IDENTITY AS ID "; cmd.CommandText = HEADER_TABLE_SQL; cmd.Parameters.AddWithValue("@FATURA_TIPI", 'E'); cmd.Parameters.AddWithValue("@SIRKET_KODU", BTN_FIRMA.EditValue); cmd.Parameters.AddWithValue("@GUID", GUID); cmd.Parameters.AddWithValue("@UBLVersionID", dr["UBLVersionID"]); cmd.Parameters.AddWithValue("@CustomizationID", dr["CustomizationID"]); cmd.Parameters.AddWithValue("@ProfileID", dr["ProfileID"]); cmd.Parameters.AddWithValue("@ID", dr["ID"]); cmd.Parameters.AddWithValue("@CopyIndicator", dr["CopyIndicator"]); cmd.Parameters.AddWithValue("@UUID", dr["UUID"]); cmd.Parameters.AddWithValue("@IssueDate", dr["IssueDate"]); cmd.Parameters.AddWithValue("@InvoiceTypeCode", dr["InvoiceTypeCode"]); cmd.Parameters.AddWithValue("@Note", dr["Note"]); cmd.Parameters.AddWithValue("@DocumentCurrencyCode", dr["DocumentCurrencyCode"]); cmd.Parameters.AddWithValue("@LineCountNumeric", dr["LineCountNumeric"]); cmd.Parameters.AddWithValue("@DespatchDocumentID", dr["DespatchDocumentID"]); cmd.Parameters.AddWithValue("@DespatchDocumentIssueDate", dr["DespatchDocumentIssueDate"]); cmd.Parameters.AddWithValue("@OrderReferenceID", dr["OrderReferenceID"]); cmd.Parameters.AddWithValue("@OrderReferenceIssueDate", dr["OrderReferenceIssueDate"]); cmd.Parameters.AddWithValue("@AdditionalDocumentID", dr["AdditionalDocumentID"]); cmd.Parameters.AddWithValue("@AdditionalDocumentIssueDate", dr["AdditionalDocumentIssueDate"]); cmd.Parameters.AddWithValue("@AdditionalDocumentEncode", dr["AdditionalDocumentEncode"]); cmd.Parameters.AddWithValue("@AdditionalDocumentCharacterSetCode", dr["AdditionalDocumentCharacterSetCode"]); cmd.Parameters.AddWithValue("@AdditionalDocumentFileName", dr["AdditionalDocumentFileName"]); cmd.Parameters.AddWithValue("@SignatureSchemeID", dr["SignatureSchemeID"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyIdentificationSchemeID", dr["SignatureSignatoryPartyIdentificationSchemeID"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressRoom", dr["SignatureSignatoryPartyPostalAddressRoom"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressStreetName", dr["SignatureSignatoryPartyPostalAddressStreetName"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressBuildingName", dr["SignatureSignatoryPartyPostalAddressBuildingName"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressBuildingNumber", dr["SignatureSignatoryPartyPostalAddressBuildingNumber"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressCitySubdivisionName", dr["SignatureSignatoryPartyPostalAddressCitySubdivisionName"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressCityName", dr["SignatureSignatoryPartyPostalAddressCityName"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressPostalZone", dr["SignatureSignatoryPartyPostalAddressPostalZone"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressRegion", dr["SignatureSignatoryPartyPostalAddressRegion"]); cmd.Parameters.AddWithValue("@SignatureSignatoryPartyPostalAddressCountryName", dr["SignatureSignatoryPartyPostalAddressCountryName"]); cmd.Parameters.AddWithValue("@SignatureDigitalSignatureAttachmentURI", dr["SignatureDigitalSignatureAttachmentURI"]); cmd.Parameters.AddWithValue("@AccSupplierPartyWebsiteURI", dr["AccSupplierPartyWebsiteURI"]); cmd.Parameters.AddWithValue("@AccSupplierPartyIdentificationSchemeID", dr["AccSupplierPartyIdentificationSchemeID"]); cmd.Parameters.AddWithValue("@AccSupplierPartyName", dr["AccSupplierPartyName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressRoom", dr["AccSupplierPartyPostalAddressRoom"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressStreetName", dr["AccSupplierPartyPostalAddressStreetName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressBuildingName", dr["AccSupplierPartyPostalAddressBuildingName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressBuildingNumber", dr["AccSupplierPartyPostalAddressBuildingNumber"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressCitySubdivisionName", dr["AccSupplierPartyPostalAddressCitySubdivisionName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressCityName", dr["AccSupplierPartyPostalAddressCityName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressRegion", dr["AccSupplierPartyPostalAddressRegion"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressPostalZone", dr["AccSupplierPartyPostalAddressPostalZone"]); cmd.Parameters.AddWithValue("@AccSupplierPartyPostalAddressCountryName", dr["AccSupplierPartyPostalAddressCountryName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyTaxSchemeName", dr["AccSupplierPartyTaxSchemeName"]); cmd.Parameters.AddWithValue("@AccSupplierPartyTaxSchemeCode", dr["AccSupplierPartyTaxSchemeCode"]); cmd.Parameters.AddWithValue("@AccSupplierPartyContactTelephone", dr["AccSupplierPartyContactTelephone"]); cmd.Parameters.AddWithValue("@AccSupplierPartyContactTelefax", dr["AccSupplierPartyContactTelefax"]); cmd.Parameters.AddWithValue("@AccSupplierPartyContactElectronicMail", dr["AccSupplierPartyContactElectronicMail"]); cmd.Parameters.AddWithValue("@AccCustomerPartyWebsiteURI", dr["AccCustomerPartyWebsiteURI"]); cmd.Parameters.AddWithValue("@AccCustomerPartyIdentificationSchemeID", dr["AccCustomerPartyIdentificationSchemeID"]); cmd.Parameters.AddWithValue("@AccCustomerPartyName", dr["AccCustomerPartyName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressRoom", dr["AccCustomerPartyPostalAddressRoom"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressBuildingName", dr["AccCustomerPartyPostalAddressBuildingName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressStreetName", dr["AccCustomerPartyPostalAddressStreetName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressRegion", dr["AccCustomerPartyPostalAddressRegion"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressBuildingNumber", dr["AccCustomerPartyPostalAddressBuildingNumber"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressCitySubdivisionName", dr["AccCustomerPartyPostalAddressCitySubdivisionName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressCityName", dr["AccCustomerPartyPostalAddressCityName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressPostalZone", dr["AccCustomerPartyPostalAddressPostalZone"]); cmd.Parameters.AddWithValue("@AccCustomerPartyPostalAddressCountryName", dr["AccCustomerPartyPostalAddressCountryName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyTaxSchemeName", dr["AccCustomerPartyTaxSchemeName"]); cmd.Parameters.AddWithValue("@AccCustomerPartyTaxSchemeCode", dr["AccCustomerPartyTaxSchemeCode"]); cmd.Parameters.AddWithValue("@AccCustomerPartyContactTelephone", dr["AccCustomerPartyContactTelephone"]); cmd.Parameters.AddWithValue("@AccCustomerPartyContactTelefax", dr["AccCustomerPartyContactTelefax"]); cmd.Parameters.AddWithValue("@AccCustomerPartyContactElectronicMail", dr["AccCustomerPartyContactElectronicMail"]); cmd.Parameters.AddWithValue("@PaymentMeansCode", dr["PaymentMeansCode"]); cmd.Parameters.AddWithValue("@PaymentMeansDueDate", dr["PaymentMeansDueDate"]); cmd.Parameters.AddWithValue("@PaymentMeansPayeeFinancialAccountID", dr["PaymentMeansPayeeFinancialAccountID"]); cmd.Parameters.AddWithValue("@PaymentMeansPayeeFinancialAccountCurrencyCode", dr["PaymentMeansPayeeFinancialAccountCurrencyCode"]); cmd.Parameters.AddWithValue("@PaymentMeansPayeeFinancialAccountPaymentNote", dr["PaymentMeansPayeeFinancialAccountPaymentNote"]); cmd.Parameters.AddWithValue("@PaymentTermsNote", dr["PaymentTermsNote"]); cmd.Parameters.AddWithValue("@AllowanceChargeChargeIndicator", dr["AllowanceChargeChargeIndicator"]); cmd.Parameters.AddWithValue("@AllowanceChargeMultiplierFactorNumeric", dr["AllowanceChargeMultiplierFactorNumeric"]); cmd.Parameters.AddWithValue("@AllowanceChargeAmountCurrencyID", dr["AllowanceChargeAmountCurrencyID"]); cmd.Parameters.AddWithValue("@AllowanceChargeAmount", dr["AllowanceChargeAmount"]); cmd.Parameters.AddWithValue("@TaxTotalTaxAmountCurrencyID", dr["TaxTotalTaxAmountCurrencyID"]); cmd.Parameters.AddWithValue("@TaxTotalTaxAmount", dr["TaxTotalTaxAmount"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxableAmountCurrencyID", dr["TaxSubtotalTaxableAmountCurrencyID"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxableAmount", dr["TaxSubtotalTaxableAmount"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxAmountCurrencyID", dr["TaxSubtotalTaxAmountCurrencyID"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxAmount", dr["TaxSubtotalTaxAmount"]); cmd.Parameters.AddWithValue("@TaxSubtotalPercent", dr["TaxSubtotalPercent"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxCategoryTaxSchemeName", dr["TaxSubtotalTaxCategoryTaxSchemeName"]); cmd.Parameters.AddWithValue("@TaxSubtotalTaxCategoryTaxSchemeCode", dr["TaxSubtotalTaxCategoryTaxSchemeCode"]); cmd.Parameters.AddWithValue("@LegalMonetaryLineExtensionAmount", dr["LegalMonetaryLineExtensionAmount"]); cmd.Parameters.AddWithValue("@LegalMonetaryTaxExclusiveAmount", dr["LegalMonetaryTaxExclusiveAmount"]); cmd.Parameters.AddWithValue("@LegalMonetaryTaxInclusiveAmount", dr["LegalMonetaryTaxInclusiveAmount"]); cmd.Parameters.AddWithValue("@LegalMonetaryAllowanceTotalAmount", dr["LegalMonetaryAllowanceTotalAmount"]); cmd.Parameters.AddWithValue("@LegalMonetaryPayableAmount", dr["LegalMonetaryPayableAmount"]); cmd.Parameters.AddWithValue("@UBLExtensionObjectSigningTime", dr["UBLExtensionObjectSigningTime"]); cmd.Parameters.AddWithValue("@PCount", dr["PCount"]); cmd.Parameters.AddWithValue("@FATURA_TXT", dr["FATURA_TXT"]); cmd.Parameters.AddWithValue("@MUSTERI_KODU", dr["MUSTERI_KODU"]); cmd.Parameters.AddWithValue("@MUSTERI_GRUBU", dr["MUSTERI_GRUBU"]); cmd.Parameters.AddWithValue("@FATURA_TURU", dr["FATURA_TURU"]); cmd.Parameters.AddWithValue("@MECRA_TURU", dr["MECRA_TURU"]); cmd.Parameters.AddWithValue("@MECRA_ADI", dr["MECRA_ADI"]); cmd.Parameters.AddWithValue("@FATURA_YENI", '1'); cmd.Parameters.AddWithValue("@PLAN_KODU", dr["PLAN_KODU"]); cmd.Connection = myConnectionTable; SqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { OIID = Convert.ToInt32(myReader["ID"].ToString()); } myReader.Close(); } DataSet dsln = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("SELECT * from GIBGELENDETAY_" + BTN_FIRMA.EditValue + "_01 where GIBGELEN=" + dr["OID"], MySqlConnection); da.Fill(dsln, "LINE"); DataViewManager dvManager = new DataViewManager(dsln); DataView dv = dvManager.CreateDataView(dsln.Tables["LINE"]); GRD_LISTE.DataSource = dv; for (int inde = 0; inde < dsln.Tables["LINE"].Rows.Count; inde++) { DataRow drx = dsln.Tables["LINE"].Rows[inde]; using (SqlCommand cmd = new SqlCommand()) { string LINE_SQL = @" INSERT INTO dbo.FTR_GELEN_FATURALAR_DETAYI ( FATURA_TIPI, SIRKET_KODU,INVOICE_REF,GUID, InvoiceLineID, InvoiceLineInvoicedQuantityUnitCode, InvoiceLineInvoicedQuantity, InvoiceLineLineExtensionAmountCurrencyID, InvoiceLineLineExtensionAmount, InvoiceLineAllowanceChargeChargeIndicator, InvoiceLineAllowanceChargeMultiplierFactorNumeric, InvoiceLineAllowanceChargeAmountCurrencyID, InvoiceLineAllowanceChargeAmount, InvoiceLineTaxTotalTaxAmountCurrencyID, InvoiceLineTaxTotalTaxAmount, InvoiceLineTaxAmountCurrencyID, InvoiceLineTaxAmount, InvoiceLineTaxSubtotalTaxAmountCurrencyID, InvoiceLineTaxSubtotalPercent, InvoiceLineTaxSubtotalTaxCategoryTaxSchemeName, InvoiceLineTaxSubtotalTaxCategoryTaxSchemeCode, InvoiceLineItemName, InvoiceLinePriceAmountCurrencyID, InvoiceLinePriceAmountPrice) Values (@FATURA_TIPI,@SIRKET_KODU,@INVOICE_REF,@GUID, @InvoiceLineID, @InvoiceLineInvoicedQuantityUnitCode, @InvoiceLineInvoicedQuantity, @InvoiceLineLineExtensionAmountCurrencyID, @InvoiceLineLineExtensionAmount, @InvoiceLineAllowanceChargeChargeIndicator, @InvoiceLineAllowanceChargeMultiplierFactorNumeric, @InvoiceLineAllowanceChargeAmountCurrencyID, @InvoiceLineAllowanceChargeAmount, @InvoiceLineTaxTotalTaxAmountCurrencyID, @InvoiceLineTaxTotalTaxAmount, @InvoiceLineTaxAmountCurrencyID, @InvoiceLineTaxAmount, @InvoiceLineTaxSubtotalTaxAmountCurrencyID, @InvoiceLineTaxSubtotalPercent, @InvoiceLineTaxSubtotalTaxCategoryTaxSchemeName, @InvoiceLineTaxSubtotalTaxCategoryTaxSchemeCode, @InvoiceLineItemName, @InvoiceLinePriceAmountCurrencyID, @InvoiceLinePriceAmountPrice)"; cmd.CommandText = LINE_SQL; cmd.Parameters.AddWithValue("@FATURA_TIPI", 'E'); cmd.Parameters.AddWithValue("@SIRKET_KODU", BTN_FIRMA.EditValue); cmd.Parameters.AddWithValue("@INVOICE_REF", OIID); cmd.Parameters.AddWithValue("@GUID", GUID); cmd.Parameters.AddWithValue("@InvoiceLineID", drx["InvoiceLineID"]); cmd.Parameters.AddWithValue("@InvoiceLineInvoicedQuantityUnitCode", drx["InvoiceLineInvoicedQuantityUnitCode"]); cmd.Parameters.AddWithValue("@InvoiceLineInvoicedQuantity", drx["InvoiceLineInvoicedQuantity"]); cmd.Parameters.AddWithValue("@InvoiceLineLineExtensionAmountCurrencyID", drx["InvoiceLineLineExtensionAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLineLineExtensionAmount", drx["InvoiceLineLineExtensionAmount"]); cmd.Parameters.AddWithValue("@InvoiceLineAllowanceChargeChargeIndicator", drx["InvoiceLineAllowanceChargeChargeIndicator"]); cmd.Parameters.AddWithValue("@InvoiceLineAllowanceChargeMultiplierFactorNumeric", drx["InvoiceLineAllowanceChargeMultiplierFactorNumeric"]); cmd.Parameters.AddWithValue("@InvoiceLineAllowanceChargeAmountCurrencyID", drx["InvoiceLineAllowanceChargeAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLineAllowanceChargeAmount", drx["InvoiceLineAllowanceChargeAmount"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxTotalTaxAmountCurrencyID", drx["InvoiceLineTaxTotalTaxAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxTotalTaxAmount", drx["InvoiceLineTaxTotalTaxAmount"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxAmountCurrencyID", drx["InvoiceLineTaxAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxAmount", drx["InvoiceLineTaxAmount"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxSubtotalTaxAmountCurrencyID", drx["InvoiceLineTaxSubtotalTaxAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxSubtotalPercent", drx["InvoiceLineTaxSubtotalPercent"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxSubtotalTaxCategoryTaxSchemeName", drx["InvoiceLineTaxSubtotalTaxCategoryTaxSchemeName"]); cmd.Parameters.AddWithValue("@InvoiceLineTaxSubtotalTaxCategoryTaxSchemeCode", drx["InvoiceLineTaxSubtotalTaxCategoryTaxSchemeCode"]); cmd.Parameters.AddWithValue("@InvoiceLineItemName", drx["InvoiceLineItemName"]); cmd.Parameters.AddWithValue("@InvoiceLinePriceAmountCurrencyID", drx["InvoiceLinePriceAmountCurrencyID"]); cmd.Parameters.AddWithValue("@InvoiceLinePriceAmountPrice", drx["InvoiceLinePriceAmountPrice"]); cmd.Connection = myConnectionTable; cmd.ExecuteNonQuery(); } } } // myConnectionTable.Close(); }
private void BTN_LOGO_SECILENLERI_AKATAR_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SqlConnection myConnectionTable = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()); myConnectionTable.Open(); re_PROGRESS_BAR.Maximum = ds.Tables["Header"].Rows.Count; int OIID = 0; // var GUID = ""; for (int index = 0; index < ds.Tables["Header"].Rows.Count; index++) { BR_PROGRESS_BAR.EditValue = index; BR_PROGRESS_BAR.Refresh(); OIID = 0; // GUID = Guid.NewGuid().ToString(); Guid GUID = Guid.NewGuid(); DataRow dr = ds.Tables["Header"].Rows[index]; using (SqlCommand cmd = new SqlCommand()) { string HEADER_TABLE_SQL = " INSERT INTO dbo.FTR_GIB_TRANSFER ( SIRKET_KODU,GUID, ID, INVID, GID, SESSIONID, SONUC, TXN_ID, [FILE], FIRMA, DONEM, KONTROL, DURUM_KODU, MESAJ, Tarih, FRM, VKN, SICILNO, MUSTERI, ACIKLAMA, FATURATARIH, PROFILID, TIP, TOPLAMTUTAR, HESAPLANANKDV, TOPLAMINDIRIM, GENELTOPLAM, SENDMAIL, GIB_STATUS_CODE, GIB_STATUS_DESCRIPTION, RESPONSE_CODE, RESPONSE_DESCRIPTION, STATUS, STATUS_DESCRIPTION, FIRMA_KODU,FATURA_TIPI) " + " Values (@SIRKET_KODU,@GUID, @ID, @INVID, @GID, @SESSIONID, @SONUC, @TXN_ID, @FILE, @FIRMA, @DONEM, @KONTROL, @DURUM_KODU, @MESAJ, @Tarih, @FRM, @VKN, @SICILNO, @MUSTERI, @ACIKLAMA, @FATURATARIH, @PROFILID,@TIP, @TOPLAMTUTAR, @HESAPLANANKDV, @TOPLAMINDIRIM, @GENELTOPLAM, @SENDMAIL, @GIB_STATUS_CODE, @GIB_STATUS_DESCRIPTION, @RESPONSE_CODE, @RESPONSE_DESCRIPTION, @STATUS, @STATUS_DESCRIPTION, @FIRMA_KODU,@FATURA_TIPI)" + " SELECT @@IDENTITY AS ID "; cmd.CommandText = HEADER_TABLE_SQL; cmd.Parameters.AddWithValue("@SIRKET_KODU", BTN_FIRMA.EditValue); cmd.Parameters.AddWithValue("@GUID", GUID); cmd.Parameters.AddWithValue("@ID", dr["ID"]); cmd.Parameters.AddWithValue("@INVID", dr["INVID"]); cmd.Parameters.AddWithValue("@GID", dr["GID"]); cmd.Parameters.AddWithValue("@SESSIONID", dr["SESSIONID"]); cmd.Parameters.AddWithValue("@SONUC", dr["SONUC"]); cmd.Parameters.AddWithValue("@TXN_ID", dr["TXN_ID"]); cmd.Parameters.AddWithValue("@FILE", dr["FILE"]); cmd.Parameters.AddWithValue("@FIRMA", dr["FIRMA"]); cmd.Parameters.AddWithValue("@DONEM", dr["DONEM"]); cmd.Parameters.AddWithValue("@KONTROL", dr["KONTROL"]); cmd.Parameters.AddWithValue("@DURUM_KODU", dr["DURUM_KODU"]); cmd.Parameters.AddWithValue("@MESAJ", dr["MESAJ"]); cmd.Parameters.AddWithValue("@Tarih", dr["Tarih"]); cmd.Parameters.AddWithValue("@FRM", dr["FRM"]); cmd.Parameters.AddWithValue("@VKN", dr["VKN"]); cmd.Parameters.AddWithValue("@SICILNO", dr["SICILNO"]); cmd.Parameters.AddWithValue("@MUSTERI", dr["MUSTERI"]); cmd.Parameters.AddWithValue("@ACIKLAMA", dr["ACIKLAMA"]); cmd.Parameters.AddWithValue("@FATURATARIH", dr["FATURATARIH"]); cmd.Parameters.AddWithValue("@PROFILID", dr["PROFILID"]); cmd.Parameters.AddWithValue("@TIP", dr["TIP"]); cmd.Parameters.AddWithValue("@TOPLAMTUTAR", dr["TOPLAMTUTAR"]); cmd.Parameters.AddWithValue("@HESAPLANANKDV", dr["HESAPLANANKDV"]); cmd.Parameters.AddWithValue("@TOPLAMINDIRIM", dr["TOPLAMINDIRIM"]); cmd.Parameters.AddWithValue("@GENELTOPLAM", dr["GENELTOPLAM"]); cmd.Parameters.AddWithValue("@SENDMAIL", dr["SENDMAIL"]); cmd.Parameters.AddWithValue("@GIB_STATUS_CODE", dr["GIB_STATUS_CODE"]); cmd.Parameters.AddWithValue("@GIB_STATUS_DESCRIPTION", dr["GIB_STATUS_DESCRIPTION"]); cmd.Parameters.AddWithValue("@RESPONSE_CODE", dr["RESPONSE_CODE"]); cmd.Parameters.AddWithValue("@RESPONSE_DESCRIPTION", dr["RESPONSE_DESCRIPTION"]); cmd.Parameters.AddWithValue("@STATUS", dr["STATUS"]); cmd.Parameters.AddWithValue("@STATUS_DESCRIPTION", dr["STATUS_DESCRIPTION"]); cmd.Parameters.AddWithValue("@FIRMA_KODU", dr["FIRMA_KODU"]); cmd.Parameters.AddWithValue("@FATURA_TIPI", "E"); cmd.Connection = myConnectionTable; SqlDataReader myReader = cmd.ExecuteReader(); while (myReader.Read()) { //OIID = Convert.ToInt32(myReader["ID"].ToString()); } myReader.Close(); } } }