public InvoiceReceivingClient LoadClient(string idClient)
{
String query = "Select * from DESTINATARIO_FACTURA_CLIENTE where ID_CLIENTE = @idClient";
SqlCommand comm = new SqlCommand(query, conn);
comm.Parameters.AddWithValue("@idClient", idClient);
SqlDataReader reader;
InvoiceReceivingClient Client = new InvoiceReceivingClient();
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
reader = comm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Client = (new InvoiceReceivingClient((string)reader["ID_CLIENTE"], (string)reader["CORREO"], (string)reader["NOMBRE"]));
}
}
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
return(Client);
}
public Boolean InsertInvoiceReceivingClient(InvoiceReceivingClient invC)
{
if (VerifyInvoiceReceivingClient(invC.idClient) == 0)
{
String query = "INSERT INTO DESTINATARIO_FACTURA_CLIENTE(ID_CLIENTE, CORREO, NOMBRE) " +
"VALUES(@idClient,@email,@nameClient)";
SqlCommand comm = new SqlCommand(query, conn);
comm.Connection = conn;
comm.Parameters.AddWithValue("@idClient", invC.idClient);
comm.Parameters.AddWithValue("@email", invC.email);
comm.Parameters.AddWithValue("@nameClient", invC.nameClient);
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);
}
}
private void invoiceClient(List <DOM.InvoiceClient> invoiceClient, InvoiceReceivingClient invoiceReceivingClient)
{
lblName.Text = invoiceReceivingClient.nameClient;
lblEmail.Text = "CORREO: " + invoiceReceivingClient.email;
lblID.Text = "IDENTIFICACIÓN: " + invoiceReceivingClient.idClient;
DataTable tblInvoiceClient = new DataTable();
tblInvoiceClient.Columns.Add("Número de Factura");
tblInvoiceClient.Columns.Add("Monto");
tblInvoiceClient.Columns.Add("Estado");
tblInvoiceClient.Columns.Add("Id Método pago");
tblInvoiceClient.Columns.Add("MétodoPago");
tblInvoiceClient.Columns.Add("Condición");
tblInvoiceClient.Columns.Add("Fecha Recordatorio");
tblInvoiceClient.Columns.Add("Fecha Pago");
foreach (DOM.InvoiceClient invoice in invoiceClient)
{
string condition = invoice.condition.ToString();
if (condition == "0")
{
condition = "No pagado";
}
else
{
condition = "Pagado";
}
string payMethod = invoice.payMethod.ToString();
if (payMethod == "")
{
payMethod = "-";
}
tblInvoiceClient.Rows.Add(invoice.numberInvoice.ToString(), invoice.money.ToString(), condition, invoice.idPayMethod.ToString().Replace("0", "-"), payMethod, invoice.paymentCondition, invoice.reminderDate.ToString("dd/MM/yyyy"), invoice.paymentDate.ToString("dd/MM/yyyy").Replace("01/01/1900", "-"));
}
gdInvoiceClient.DataSource = tblInvoiceClient;
gdInvoiceClient.DataBind();
}
private void invoiceClient(List <DOM.InvoiceClient> invoiceClient)
{
DataTable tblInvoiceClient = new DataTable();
InvoiceReceivingClientManager invoiceReceivingClientManager = new InvoiceReceivingClientManager();
lblBillClient.Text = "Facturas de Clientes";
tblInvoiceClient.Columns.Add("Número de Factura");
tblInvoiceClient.Columns.Add("Nombre");
tblInvoiceClient.Columns.Add("identificacion");
tblInvoiceClient.Columns.Add("Monto");
tblInvoiceClient.Columns.Add("Estado");
tblInvoiceClient.Columns.Add("Id Método pago");
tblInvoiceClient.Columns.Add("MétodoPago");
tblInvoiceClient.Columns.Add("Condición");
tblInvoiceClient.Columns.Add("Fecha Recordatorio");
tblInvoiceClient.Columns.Add("Fecha Pago");
foreach (DOM.InvoiceClient invoice in invoiceClient)
{
string condition = invoice.condition.ToString();
if (condition == "0")
{
condition = "No pagado";
}
else
{
condition = "Pagado";
}
string payMethod = invoice.payMethod.ToString();
if (payMethod == "")
{
payMethod = "-";
}
InvoiceReceivingClient invoiceReceiving = invoiceReceivingClientManager.LoadClient(invoice.idClient);
tblInvoiceClient.Rows.Add(invoice.numberInvoice.ToString(), invoiceReceiving.nameClient.ToString(), invoice.idClient.ToString(), invoice.money.ToString(), condition, invoice.idPayMethod.ToString().Replace("0", "-"), payMethod, invoice.paymentCondition, invoice.reminderDate.ToString("dd/MM/yyyy"), invoice.paymentDate.ToString("dd/MM/yyyy").Replace("01/01/1900", "-"));
}
gdInvoiceClient.DataSource = tblInvoiceClient;
gdInvoiceClient.DataBind();
}
public Boolean InsertInvoiceReceivingClient(InvoiceReceivingClient invC)
{
}
public Boolean InsertInvoiceReceivingClient(InvoiceReceivingClient invC)
{
DAOInvoiceReceivingClient daoIRC = new DAOInvoiceReceivingClient();
return(daoIRC.InsertInvoiceReceivingClient(invC));
}
