protected void Page_Load(object sender, EventArgs e)
{
VerifySession();
InvoiceReceivingSupplierManager invoiceReceivingSupplierManager = new InvoiceReceivingSupplierManager();
createContend(invoiceReceivingSupplierManager.LoadAllSuppliers());
}
protected void Page_Load(object sender, EventArgs e)
{
VerifySession();
String idSupplier = Request["idSupplier"];
InvoiceSupplierManager invoiceSupplierManager = new InvoiceSupplierManager();
InvoiceReceivingSupplierManager invoiceReceivingSupplierManager = new InvoiceReceivingSupplierManager();
invoiceSupplier(invoiceSupplierManager.LoadInvoiceSupplier(idSupplier), invoiceReceivingSupplierManager.LoadSupplier(idSupplier));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
contentSuplierName.Controls.Clear();
InvoiceReceivingSupplierManager invoiceReceivingSupplierManager = new InvoiceReceivingSupplierManager();
createContend(invoiceReceivingSupplierManager.LoadSuppliers(tbxInsertSupplierName.Text.Trim().ToString()));
}
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();
}
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 <InvoiceReceivingSupplier> invoiceReceivingSupplier)
{
//HtmlGenericControl createH3Code = new HtmlGenericControl("H3");
//createH3Code.ID = "createH3Code";
//createH3Code.InnerHtml = "Lista de clientes";
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.Padding, "20px");
//createDiv.Attributes.Add("class", "col-sm-3 text-center");
if (invoiceReceivingSupplier.Count > 0)
{
if (invoiceReceivingSupplier.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", "ViewBillsSupplier.aspx?idSupplier=" + invoiceReceivingSupplier[i].idSupplier);
createDetail.InnerHtml = "<span class='glyphicon glyphicon-info-sign'></span> " + invoiceReceivingSupplier[i].nameSupplier + "<br/>";
createDivCont.Controls.Add(createBr);
createDivCont.Controls.Add(createDetail);
createDiv.Controls.Add(createDivCont);
}
}
else
{
foreach (InvoiceReceivingSupplier client in invoiceReceivingSupplier)
{
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", "ViewBillsSupplier.aspx?idSupplier=" + client.idSupplier);
createDetail.InnerHtml = "<span class='glyphicon glyphicon-info-sign'></span> " + client.nameSupplier + "<br/>";
createDivCont.Controls.Add(createBr);
createDivCont.Controls.Add(createDetail);
createDiv.Controls.Add(createDivCont);
}
}
contentSuplierName.Controls.Add(createDiv);
}
else
{
Response.Write("<script> alert('No se encontraron coincidencias') </script>");
InvoiceReceivingSupplierManager invoiceReceivingSupplierManager = new InvoiceReceivingSupplierManager();
createContend(invoiceReceivingSupplierManager.LoadAllSuppliers());
}
}
