protected void Page_Load(object sender, EventArgs e)
{
VerifySession();
InvoiceReceivingClientManager invoiceReceivingClientManager = new InvoiceReceivingClientManager();
createContend(invoiceReceivingClientManager.LoadAllClients());
}
protected void Page_Load(object sender, EventArgs e)
{
VerifySession();
String idClient = Request["idClient"];
InvoiceClientManager invoiceClientManager = new InvoiceClientManager();
InvoiceReceivingClientManager invoiceReceivingClientManager = new InvoiceReceivingClientManager();
invoiceClient(invoiceClientManager.LoadInvoiceClient(idClient), invoiceReceivingClientManager.LoadClient(idClient));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
contentClientsName.Controls.Clear();
InvoiceReceivingClientManager invoiceReceivingClientManager = new InvoiceReceivingClientManager();
createContend(invoiceReceivingClientManager.LoadClients(tbxInsertClientName.Text.Trim().ToString()));
}
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();
}
protected void btnUploadInvoice_Click(object sender, EventArgs e)
{ //VALIDAR LA FECHA = 9999/99/99
// VAIDAR EL NULL DE LA FECHA DE PAGO
string clientBillNumberCell = "";
string idClientCell = "";
string conditionClientCell = "";
string totalClientCell = "";
string dateClientCell = ""; // PARA HACER LA VALIDACION DE SI ES UN ARCHIVO QUE POSEE FACTURAS!!
string dateSupplierCell = "";
string supplierBillNumberCell = "";
string idSupplierCell = "";
string totalSupplierCell = "";
if (isClient == true)
{
clientBillNumberCell = table.Rows[0][1].ToString();
idClientCell = table.Rows[0][8].ToString();
conditionClientCell = table.Rows[0][11].ToString();
totalClientCell = table.Rows[0][24].ToString();
dateClientCell = table.Rows[0][26].ToString();
}
else
{
dateSupplierCell = table.Rows[0][3].ToString();
supplierBillNumberCell = table.Rows[0][4].ToString();
idSupplierCell = table.Rows[0][9].ToString();
totalSupplierCell = table.Rows[0][23].ToString();
}
if (clientBillNumberCell == customerTemplateId && idClientCell == customerId && conditionClientCell == customerTemplateIndicator &&
totalClientCell == customerTotal && dateClientCell == customerDate)
{
for (int row = 1; row < table.Rows.Count; row++)
{
DateTime dateBill = DateTime.ParseExact(table.Rows[row][26].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime dateCompare = new DateTime(2100, 12, 30);
int result = DateTime.Compare(dateBill, dateCompare);
if (result < 0 && idClientCell.Length <= 35)
{
//relationship = "is earlier than";
InvoiceReceivingClientManager invoiceReceivingClientM = new InvoiceReceivingClientManager();
invoiceReceivingClientM.InsertInvoiceReceivingClient(new InvoiceReceivingClient(idClientCell, table.Rows[row][9].ToString(), table.Rows[row][7].ToString()));
InvoiceClientManager invoiceClientManager = new InvoiceClientManager();
invoiceClientManager.InsertInvoiceClient(new DOM.InvoiceClient(int.Parse(clientBillNumberCell), idClientCell, 0, "", double.Parse(totalClientCell), 0, conditionClientCell, DateTime.ParseExact(dateClientCell, "dd/MM/yyyy", CultureInfo.InvariantCulture)));
}
else
{
//relationship = "is later than";
failDateBillClient++;
}
}
lblInformationInvoice.Text = "Se ingresaron todas las facturas de cliente, y no se ingresaron " + failDateBillClient + " facturas fallidas por formato erróneo";
return;
}
else //VALIDAR LO MISMO EU ARRIBA PARA LAS DE PROVEEDOR
{
if (dateSupplierCell == supplierDate && supplierBillNumberCell == supplierTemplateId && idSupplierCell == supplierId &&
totalSupplierCell == supplierTotal)
{
for (int row1 = 1; row1 < table.Rows.Count; row1++)
{
DateTime dateBill = DateTime.ParseExact(table.Rows[row1][3].ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime dateCompare = new DateTime(2100, 12, 30);
int result = DateTime.Compare(dateBill, dateCompare);
if (result < 0 && supplierBillNumberCell.Length <= 50 && idSupplierCell.Length <= 35)
{
InvoiceReceivingSupplierManager invoiceReceivingSupplierM = new InvoiceReceivingSupplierManager();
invoiceReceivingSupplierM.InsertInvoiceReceivingSupplier(new InvoiceReceivingSupplier(table.Rows[row1][9].ToString(), table.Rows[row1][10].ToString()));
InvoiceSupplierManager invoiceSupplierManager = new InvoiceSupplierManager();
invoiceSupplierManager.InsertInvoiceSupplier(new DOM.InvoiceSupplier(supplierBillNumberCell, idSupplierCell, 0, "", double.Parse(totalSupplierCell), 0, DateTime.ParseExact(dateSupplierCell, "dd/MM/yyyy", CultureInfo.InvariantCulture)));
}
else
{
//relationship = "is later than";
failDateBillSupplier++;
}
}
lblInformationInvoice.Text = "Se ingresaron todas las facturas de proveedor, y no se ingresaron " + failDateBillSupplier + " facturas fallidas por formato erróneo";
return;
}
else
{
lblInformationInvoice.Text = noSupplierTemplateFile;
return;
}
lblInformationInvoice.Text = noClientTemplateFile;
}
}
private void createContend(List <InvoiceReceivingClient> invoiceReceivingClient)
{
//HtmlGenericControl createH3Code = new HtmlGenericControl("H3");
//createH3Code.ID = "createH3Code";
//createH3Code.InnerHtml = "Lista de clientes";
//createH3Code.Style.Add("class", "tittle");
HtmlGenericControl createDivCont = new HtmlGenericControl("DIV");
createDivCont.ID = "createDivCont";
HtmlGenericControl createDiv = new HtmlGenericControl("DIV");
createDiv.ID = "createDiv";
//createDivCont.Controls.Add(createH3Code);
//createDiv.Style.Add(HtmlTextWriterStyle.BackgroundColor, "Black");
createDiv.Style.Add(HtmlTextWriterStyle.Color, "White");
//createDiv.Style.Add(HtmlTextWriterStyle.MarginBottom, "20px");
//createDiv.Attributes.Add("class", "col-md-3 text-center");
if (invoiceReceivingClient.Count > 0)
{
if (invoiceReceivingClient.Count > 10)
{
for (int i = 0; i < 10; i++)
{
HtmlGenericControl createDetail = new HtmlGenericControl("a");
HtmlGenericControl createBr = new HtmlGenericControl("br");
createDetail.Style.Add(HtmlTextWriterStyle.Color, "White");
createDetail.Attributes.Add("class", "clientDiv");
createDetail.Attributes.Add("href", "ViewBillsClient.aspx?idSupplier=" + invoiceReceivingClient[i].idClient);
createDetail.InnerHtml = "<span class='glyphicon glyphicon-info-sign'></span> " + invoiceReceivingClient[i].nameClient + "<br/>";
createDivCont.Controls.Add(createBr);
createDivCont.Controls.Add(createDetail);
createDiv.Controls.Add(createDivCont);
}
}
else
{
foreach (InvoiceReceivingClient client in invoiceReceivingClient)
{
HtmlGenericControl createDetail = new HtmlGenericControl("a");
HtmlGenericControl createBr = new HtmlGenericControl("br");
createDetail.Style.Add(HtmlTextWriterStyle.Color, "White");
createDetail.Attributes.Add("class", "clientDiv");
createDetail.Attributes.Add("href", "ViewBillsClient.aspx?idClient=" + client.idClient);
createDetail.InnerHtml = "<span class='glyphicon glyphicon-info-sign'></span> " + client.nameClient + "<br/>";
createDivCont.Controls.Add(createBr);
createDivCont.Controls.Add(createDetail);
createDiv.Controls.Add(createDivCont);
}
}
contentClientsName.Controls.Add(createDiv);
}
else
{
Response.Write("<script> alert('No se encontraron coincidencias') </script>");
InvoiceReceivingClientManager invoiceReceivingClientManager = new InvoiceReceivingClientManager();
createContend(invoiceReceivingClientManager.LoadAllClients());
}
}
