public Boolean InsertInvoiceReceivingSupplier(InvoiceReceivingSupplier invR) { if (VerifyInvoiceReceivingSupplier(invR.idSupplier) == 0) { String query = "INSERT INTO DESTINATARIO_FACTURA_PROVEEDOR(ID_PROVEEDOR, CORREO, NOMBRE) " + "VALUES(@idProveedor,@email,@name)"; SqlCommand comm = new SqlCommand(query, conn); comm.Connection = conn; comm.Parameters.AddWithValue("@idProveedor", invR.idSupplier); comm.Parameters.AddWithValue("@email", invR.email); comm.Parameters.AddWithValue("@name", invR.nameSupplier); if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } comm.ExecuteNonQuery(); if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } return(true); } else { return(false); } }
public InvoiceReceivingSupplier LoadSupplier(string idSupplier) { String query = "Select * from DESTINATARIO_FACTURA_PROVEEDOR where ID_PROVEEDOR = @idSupplier"; SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.AddWithValue("@idSupplier", idSupplier); SqlDataReader reader; InvoiceReceivingSupplier Supplier = new InvoiceReceivingSupplier(); if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } reader = comm.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Supplier = (new InvoiceReceivingSupplier((string)reader["ID_PROVEEDOR"], (string)reader["NOMBRE"])); } } if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } return(Supplier); }
private void invoiceSupplier(List <DOM.InvoiceSupplier> invoiceSupplier) { DataTable tblInvoiceSupplier = new DataTable(); InvoiceReceivingSupplierManager invoiceReceivingSuppliertManager = new InvoiceReceivingSupplierManager(); lblBillSupplier.Text = "Facturas de Proveedores"; tblInvoiceSupplier.Columns.Add("Número de Factura"); tblInvoiceSupplier.Columns.Add("Nombre"); tblInvoiceSupplier.Columns.Add("identificacion"); tblInvoiceSupplier.Columns.Add("Monto"); tblInvoiceSupplier.Columns.Add("Estado"); tblInvoiceSupplier.Columns.Add("Id Método pago"); tblInvoiceSupplier.Columns.Add("MétodoPago"); tblInvoiceSupplier.Columns.Add("Fecha Recordatorio"); tblInvoiceSupplier.Columns.Add("Fecha Pago"); foreach (DOM.InvoiceSupplier invoice in invoiceSupplier) { string condition = invoice.condition.ToString(); if (condition == "0") { condition = "No pagado"; } else { condition = "Pagado"; } string payMethod = invoice.payMethod.ToString(); if (payMethod == "") { payMethod = "-"; } InvoiceReceivingSupplier invoiceReceiving = invoiceReceivingSuppliertManager.LoadSupplier(invoice.idSupplier); tblInvoiceSupplier.Rows.Add(invoice.numberInvoice.ToString(), invoiceReceiving.nameSupplier, invoice.idSupplier, invoice.money.ToString(), condition, invoice.idPayMethod.ToString().Replace("0", "-"), payMethod, invoice.reminderDate.ToString("dd/MM/yyyy"), invoice.paymentDate.ToString("dd/MM/yyyy").Replace("01/01/1900", "-")); } gdInvoiceSupplier.DataSource = tblInvoiceSupplier; gdInvoiceSupplier.DataBind(); }
private void invoiceSupplier(List <DOM.InvoiceSupplier> invoiceSupplier, InvoiceReceivingSupplier invoiceReceivingSupplier) { lblName.Text = invoiceReceivingSupplier.nameSupplier; lblID.Text = "IDENTIFICACIÓN: " + invoiceReceivingSupplier.idSupplier; DataTable tblInvoiceSupplier = new DataTable(); tblInvoiceSupplier.Columns.Add("Número de Factura"); tblInvoiceSupplier.Columns.Add("Monto"); tblInvoiceSupplier.Columns.Add("Estado"); tblInvoiceSupplier.Columns.Add("Id Método pago"); tblInvoiceSupplier.Columns.Add("MétodoPago"); tblInvoiceSupplier.Columns.Add("Fecha Recordatorio"); tblInvoiceSupplier.Columns.Add("Fecha Pago"); foreach (DOM.InvoiceSupplier invoice in invoiceSupplier) { string condition = invoice.condition.ToString(); if (condition == "0") { condition = "No pagado"; } else { condition = "Pagado"; } string payMethod = invoice.payMethod.ToString(); if (payMethod == "") { payMethod = "-"; } tblInvoiceSupplier.Rows.Add(invoice.numberInvoice.ToString(), invoice.money.ToString(), condition, invoice.idPayMethod.ToString().Replace("0", "-"), payMethod, invoice.reminderDate.ToString("dd/MM/yyyy"), invoice.paymentDate.ToString("dd/MM/yyyy").Replace("01/01/1900", "-")); } gdInvoiceSupplier.DataSource = tblInvoiceSupplier; gdInvoiceSupplier.DataBind(); }
public Boolean InsertInvoiceReceivingSupplier(InvoiceReceivingSupplier invR) { DAOInvoiceReceivingSupplier daoIRS = new DAOInvoiceReceivingSupplier(); return(daoIRS.InsertInvoiceReceivingSupplier(invR)); }
public Boolean InsertInvoiceReceivingSupplier(InvoiceReceivingSupplier invR) { }