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)
{
}
