private void LoadInformation(int id)
{
PurchaseOrder oc = ControllerManager.PurchaseOrder.GetById(id);
IList <PurchaseOrderItem> ocList = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(oc);
IList <PurchaseOrderItemInformation> poiinfo = new List <PurchaseOrderItemInformation>();
foreach (PurchaseOrderItem item in ocList)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
PurchaseOrderItemInformation temp = new PurchaseOrderItemInformation();
temp.Id = item.Id;
temp.ProductName = item.Product.Description;
temp.Quantity = item.Quantity;
temp.Price = prodscala.PurchasePrice;
temp.TotalPrice = temp.Price * temp.Quantity;
temp.Stock = prodscala.StockQ;
temp.ProductCode = item.Product.ProductCode;
temp.Status = Convert.ToInt32(item.PurchaseOrderItemStatus);
temp.QuantitySuggested = item.QuantitySuggested;
poiinfo.Add(temp);
}
Label1.Text = id.ToString();
repItems.DataSource = poiinfo;
repItems.DataBind();
//GridView1.DataSource = poiinfo;
//GridView1.DataBind();
}
private void LoadInformation(int id, int pos)
{
PurchaseOrder oc = ControllerManager.PurchaseOrder.GetById(id);
switch (oc.WOD)
{
case WayOfDelivery.Maritimo:
rblWOD.SelectedValue = "1";
break;
case WayOfDelivery.Aereo:
rblWOD.SelectedValue = "2";
break;
case WayOfDelivery.Courrier:
rblWOD.SelectedValue = "3";
break;
}
IList <PurchaseOrderItem> ocList = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(oc);
IList <PurchaseOrderItemInformation> poiinfo = new List <PurchaseOrderItemInformation>();
foreach (PurchaseOrderItem item in ocList)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
PurchaseOrderItemInformation temp = new PurchaseOrderItemInformation();
temp.Id = item.Id;
temp.ProductName = item.Product.Description;
temp.Quantity = item.Quantity;
temp.Price = prodscala.PurchasePrice;
temp.TotalPrice = temp.Price * temp.Quantity;
temp.Stock = prodscala.StockQ;
temp.ProductCode = item.Product.ProductCode;
temp.Status = Convert.ToInt32(item.PurchaseOrderItemStatus);
temp.QuantitySuggested = item.QuantitySuggested;
switch (prodscala.PurchaseCurrency)
{
case "00":
temp.Currency = "$";
break;
case "01":
temp.Currency = "U$S";
break;
case "02":
temp.Currency = "€";
break;
}
poiinfo.Add(temp);
}
Label1.Text = id.ToString();
Label3.Text = pos.ToString();
repItems.DataSource = poiinfo;
repItems.DataBind();
}
private void DisplayInfo(int pageSize, int currentPage)
{
PagedDataSource pagedItems = new PagedDataSource();
int cod = 0;
DateTime date = new DateTime();
if (TextBox1.Text != "")
{
cod = Convert.ToInt32(TextBox1.Text);
}
if (TextBox2.Text != "")
{
date = Convert.ToDateTime(TextBox2.Text);
}
else
{
date = Convert.ToDateTime("01/01/1900");
}
IList <PurchaseOrderInformation> poinfo = ControllerManager.PurchaseOrder.GetPurchaseOrders(cod, date, Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(DropDownList3.SelectedValue), 0, 0);
foreach (PurchaseOrderInformation information in poinfo)
{
IList <PurchaseOrderItem> poi = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(ControllerManager.PurchaseOrder.GetById(information.Id));
information.Amount = 0;
information.Totalcount = 0;
foreach (PurchaseOrderItem item in poi)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
information.Amount = information.Amount + (item.Quantity * prodscala.PurchasePrice);
information.Totalcount = information.Totalcount + item.Quantity;
information.Arrivaldate = information.Orderdate.AddDays(item.Product.LeadTime);
}
}
pagedItems.DataSource = poinfo;
pagedItems.AllowPaging = true;
pagedItems.PageSize = pageSize;
pagedItems.CurrentPageIndex = currentPage - 1;
Pager1.PageCount = pagedItems.PageCount;
Pager2.PageCount = Pager1.PageCount;
Pager1.CurrentPage = currentPage;
Pager2.CurrentPage = Pager1.CurrentPage;
repItems.DataSource = pagedItems;
repItems.DataBind();
if (pagedItems.PageCount < 1)
{
Pager1.Visible = false;
Pager2.Visible = false;
}
Pager1.Step = 4;
Pager2.Step = 4;
Pager1.DataBind();
Pager2.DataBind();
}
private void LoadInformation(int id)
{
Product prod = ControllerManager.Product.GetById(id);
TransactionHistoryWeekly tran = ControllerManager.TransactionHistoryWeekly.GetIndividualInfo(prod.Id, Config.CurrentWeek, Config.CurrentDate.Year);
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(prod.ProductCode);
IList <TransactionHistoryWeekly> sales = ControllerManager.TransactionHistoryWeekly.GetSalesTotal(prod, Config.CurrentWeek, Config.CurrentDate.Year);
IList <ProductStatisticWeekly> fullstats = ControllerManager.ProductStatisticWeekly.GetProductFullInfo(prod.Id);
//seguridad por si no existen registros PERO DEBEN EXISTIR AUNQUE SEA EN 0!!!!!!!!
if (tran == null)
{
tran = new TransactionHistoryWeekly();
}
//termina la seguridad
Label25.Text = id.ToString();
Label2.Text = prodscala.PurchasePrice.ToString("#,##0.00");
Label4.Text = "% " + prodscala.OverCost.ToString();
Label6.Text = "U$S " + prodscala.SalePrice.ToString("#,##0.00");
Label27.Text = "$ " + prodscala.StandardCost.ToString("#,##0.000");
Label9.Text = sales[3].Sale.ToString();
Label11.Text = sales[2].Sale.ToString();
Label13.Text = sales[1].Sale.ToString();
Label15.Text = sales[0].Sale.ToString();
Label18.Text = fullstats[4].Sale.ToString();
Label20.Text = fullstats[3].Sale.ToString();
Label22.Text = fullstats[2].Sale.ToString();
Label24.Text = fullstats[0].Sale.ToString();
if (prodscala.PurchaseCurrency == "00")
{
Label2.Text = "$ " + prodscala.PurchasePrice.ToString("#,##0.00");
}
else if (prodscala.PurchaseCurrency == "01")
{
Label2.Text = "U$S " + prodscala.PurchasePrice.ToString("#,##0.00");
}
else if (prodscala.PurchaseCurrency == "02")
{
Label2.Text = "€ " + prodscala.PurchasePrice.ToString("#,##0.00");
}
IList <BreakDown> despiece = ControllerManager.BreakDown.GetBreakDown(prod);
if (despiece.Count > 1)
{
ImageButton2.Visible = true;
}
}
private void LoadInformation(int id)
{
Product prod = ControllerManager.Product.GetById(id);
TransactionHistoryWeekly tran = ControllerManager.TransactionHistoryWeekly.GetIndividualInfo(prod.Id, Config.CurrentWeek, Config.CurrentDate.Year);
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(prod.ProductCode);
IList <TransactionHistoryWeekly> sales = ControllerManager.TransactionHistoryWeekly.GetSalesTotal(prod, Config.CurrentWeek, Config.CurrentDate.Year);
IList <ProductStatisticWeekly> fullstats = ControllerManager.ProductStatisticWeekly.GetProductFullInfo(prod.Id);
//seguridad por si no existen registros PERO DEBEN EXISTIR AUNQUE SEA EN 0!!!!!!!!
if (tran == null)
{
tran = new TransactionHistoryWeekly();
}
//termina la seguridad
Label25.Text = id.ToString();
Label2.Text = prodscala.PurchasePrice.ToString();
Label4.Text = prodscala.OverCost.ToString();
Label6.Text = prodscala.SalePrice.ToString();
Label9.Text = sales[3].Sale.ToString();
Label11.Text = sales[2].Sale.ToString();
Label13.Text = sales[1].Sale.ToString();
Label15.Text = sales[0].Sale.ToString();
if (fullstats.Count > 5)
{
Label18.Text = fullstats[4].Sale.ToString();
}
if (fullstats.Count > 4)
{
Label20.Text = fullstats[3].Sale.ToString();
}
if (fullstats.Count > 3)
{
Label22.Text = fullstats[2].Sale.ToString();
}
if (fullstats.Count > 2)
{
Label24.Text = fullstats[0].Sale.ToString();
}
}
protected void btnImprimirLP_Click(object sender, ImageClickEventArgs e)
{
IList <Product> selectedproduct = new List <Product>();
foreach (RepeaterItem rep in repItems.Items)
{
if (((CheckBox)rep.FindControl("chkGuardar")).Checked)
{
Product prod = ControllerManager.Product.GetProductInfo(((Label)rep.FindControl("lblCodigo")).Text);
selectedproduct.Add(prod);
}
}
if (selectedproduct.Count > 0)
{
DataSet objDataSet = new DataSet();
DataTable objProdList = new DataTable("rptProdList");
objProdList.Columns.Add("Codigo");
objProdList.Columns.Add("Descripcion");
objProdList.Columns.Add("Proveedor");
objProdList.Columns.Add("Stock");
objProdList.Columns.Add("NivelRep");
objProdList.Columns.Add("ModuloComp");
objProdList.Columns.Add("PromVentas");
objProdList.Columns.Add("LeadTime");
objProdList.Columns.Add("Safety");
objProdList.Columns.Add("PrecioCompra");
objProdList.Columns.Add("SobreCostos");
objProdList.Columns.Add("PrecioVenta");
objProdList.Columns.Add("VentaAnual");
objProdList.Columns.Add("VentaSemestral");
objProdList.Columns.Add("VentaTrimestral");
objProdList.Columns.Add("VentaMensual");
objProdList.Columns.Add("PromedioAnual");
objProdList.Columns.Add("PromedioSemestral");
objProdList.Columns.Add("PromedioTrimestral");
objProdList.Columns.Add("PromedioMensual");
foreach (Product prod in selectedproduct)
{
int cuenta;
ProductInformation prodinfo = ControllerManager.Product.GetProductInformation(prod.ProductCode, "N/A", 0, 0, 0, 0, out cuenta, chbViejos.Checked)[0];
TransactionHistoryWeekly tran = ControllerManager.TransactionHistoryWeekly.GetIndividualInfo(prod.Id, Config.CurrentWeek, Config.CurrentDate.Year);
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(prod.ProductCode);
IList <TransactionHistoryWeekly> sales = ControllerManager.TransactionHistoryWeekly.GetSalesTotal(prod, Config.CurrentWeek, Config.CurrentDate.Year);
IList <ProductStatisticWeekly> fullstats = ControllerManager.ProductStatisticWeekly.GetProductFullInfo(prod.Id);
DataRow myRow;
myRow = objProdList.NewRow();
myRow[0] = prodinfo.ProductCode;
myRow[1] = prodinfo.Description;
myRow[2] = prodinfo.Provider;
myRow[3] = prodinfo.Stock;
myRow[4] = prodinfo.RepositionLevel;
myRow[5] = prodinfo.RepositionPoint;
myRow[6] = prodinfo.Saleaverage;
myRow[7] = prodinfo.LeadTime;
myRow[8] = prodinfo.Safety;
myRow[9] = prodscala.PurchasePrice;
myRow[10] = prodscala.OverCost;
myRow[11] = prodscala.SalePrice;
myRow[12] = sales[3].Sale;
myRow[13] = sales[2].Sale;
myRow[14] = sales[1].Sale;
myRow[15] = sales[0].Sale;
myRow[16] = fullstats[4].Sale;
myRow[17] = fullstats[3].Sale;
myRow[18] = fullstats[2].Sale;
myRow[19] = fullstats[0].Sale;
objProdList.Rows.Add(myRow);
}
objDataSet.Tables.Add(objProdList);
//objDataSet.Relations.Add("PO_POI", objDataSet.Tables["rptPO"].Columns["Codigo"], objDataSet.Tables["rptPOI"].Columns["CodOC"]);
//objDataSet.WriteXmlSchema("c:/esquemaprod.xsd");
//objDataSet.WriteXml("c:/dataset.xml");
Session["dsListProductos"] = objDataSet;
Response.Redirect("/product-list/report.aspx");
}
else
{
lblErrorProducto.Visible = true;
}
}
protected void btnImprimirOc_Click(object sender, ImageClickEventArgs e)
{
IList <PurchaseOrderInformation> poinfo = new List <PurchaseOrderInformation>();
int totalcount = 0;
txtCodigoOc.Text = txtCodigoOc.Text.Trim();
DateTime date = Convert.ToDateTime("01/01/1900");
DateTime dateEnd = Convert.ToDateTime("01/01/1900");
foreach (RepeaterItem rep in repItems.Items)
{
if (((CheckBox)rep.FindControl("chkbItemStatus")).Checked)
{
IList <PurchaseOrderInformation> poii = ControllerManager.PurchaseOrder.GetPurchaseOrdersBetweenDates(Convert.ToInt32(((Label)rep.FindControl("lblCodigoOC")).Text), date, dateEnd, Convert.ToInt32(ddlProveedor.SelectedValue), Convert.ToInt32(ddlEstados.SelectedValue), 0, 0, Convert.ToInt32(ddlOrigen.SelectedValue), out totalcount);
poinfo.Add(poii[0]);
}
}
if (poinfo.Count > 0)
{
DataSet objDataSet = new DataSet();
DataTable objPOT = new DataTable("rptPO");
DataTable objItems = new DataTable("rptPOI");
objPOT.Columns.Add("Codigo");
objPOT.Columns.Add("FechaPedido");
objPOT.Columns.Add("Proveedor");
objPOT.Columns.Add("CantArt");
objPOT.Columns.Add("Importe");
objPOT.Columns.Add("FechaArribo");
objPOT.Columns.Add("Origen");
objItems.Columns.Add("CodOC");
objItems.Columns.Add("Codigo");
objItems.Columns.Add("Descripcion");
objItems.Columns.Add("Cantidad");
objItems.Columns.Add("PrecioUnitario");
objItems.Columns.Add("Total");
objItems.Columns.Add("Stock");
objItems.Columns.Add("CantidadSugerida");
foreach (PurchaseOrderInformation information in poinfo)
{
IList <PurchaseOrderItem> poi = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(ControllerManager.PurchaseOrder.GetById(information.Id));
foreach (PurchaseOrderItem item in poi)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
DataRow drItems;
drItems = objItems.NewRow();
drItems["CodOC"] = information.Id;
drItems["Codigo"] = item.Product.ProductCode;
drItems["Descripcion"] = item.Product.Description;
drItems["Cantidad"] = item.Quantity;
drItems["PrecioUnitario"] = prodscala.PurchasePrice;
drItems["Total"] = prodscala.PurchasePrice * item.Quantity;
drItems["Stock"] = prodscala.StockQ;
drItems["CantidadSugerida"] = item.QuantitySuggested;
objItems.Rows.Add(drItems);
}
DataRow myRow;
myRow = objPOT.NewRow();
myRow[0] = information.Id;
myRow[1] = information.Orderdate.ToShortDateString();
myRow[2] = information.Provider;
myRow[3] = information.Totalcount;
myRow[4] = information.Amount;
myRow[5] = information.Arrivaldate.ToShortDateString();
myRow[6] = information.Type;
objPOT.Rows.Add(myRow);
}
objDataSet.Tables.Add(objPOT);
objDataSet.Tables.Add(objItems);
objDataSet.Relations.Add("PO_POI", objDataSet.Tables["rptPO"].Columns["Codigo"], objDataSet.Tables["rptPOI"].Columns["CodOC"]);
//objDataSet.WriteXmlSchema("c:/esquema.xsd");
//objDataSet.WriteXml("c:/dataset.xml");
Session["dsOrdCompras"] = objDataSet;
Response.Write("<script>");
Response.Write("window.open('/purchase-order/report.aspx','_blank')");
Response.Write("</script>");
//Response.Redirect("/purchase-order/report.aspx");
}
else
{
lblCompraError.Visible = true;
lblCompraError.Text = "Por favor seleccione al menos 1 orden de compra!";
}
}
protected void Image12_Click(object sender, ImageClickEventArgs e)
{
IList <PurchaseOrderInformation> poinfo = new List <PurchaseOrderInformation>();
//IList<PurchaseOrder> selectedpo = new List<PurchaseOrder>();
foreach (RepeaterItem rep in repItems.Items)
{
if (((CheckBox)rep.FindControl("CheckBox1")).Checked)
{
//PurchaseOrder po = ControllerManager.PurchaseOrder.GetById(Convert.ToInt32(((CheckBox)rep.FindControl("CheckBox1")).ToolTip));
IList <PurchaseOrderInformation> poii = ControllerManager.PurchaseOrder.GetPurchaseOrders(Convert.ToInt32(((CheckBox)rep.FindControl("CheckBox1")).ToolTip), Convert.ToDateTime("01/01/1900"), Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToInt32(DropDownList3.SelectedValue), 0, 0);
poinfo.Add(poii[0]);
}
}
if (poinfo.Count > 0)
{
foreach (PurchaseOrderInformation information in poinfo)
{
IList <PurchaseOrderItem> poi = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(ControllerManager.PurchaseOrder.GetById(information.Id));
information.Amount = 0;
information.Totalcount = 0;
foreach (PurchaseOrderItem item in poi)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
information.Amount = information.Amount + (item.Quantity * prodscala.PurchasePrice);
information.Totalcount = information.Totalcount + item.Quantity;
information.Arrivaldate = information.Orderdate.AddDays(item.Product.LeadTime);
}
}
DataSet objDataSet = new DataSet();
DataTable objTable = new DataTable("rptPO");
objTable.Columns.Add("Codigo");
objTable.Columns.Add("FechaPedido");
objTable.Columns.Add("Proveedor");
objTable.Columns.Add("CantArt");
objTable.Columns.Add("Importe");
objTable.Columns.Add("FechaArribo");
objTable.Columns.Add("Origen");
DataRow myRow;
foreach (PurchaseOrderInformation po in poinfo)
{
myRow = objTable.NewRow();
myRow[0] = po.Id;
myRow[1] = po.Orderdate.ToShortDateString();
myRow[2] = po.Provider;
myRow[3] = po.Totalcount;
myRow[4] = po.Amount;
myRow[5] = po.Arrivaldate.ToShortDateString();
myRow[6] = po.Type;
objTable.Rows.Add(myRow);
}
objDataSet.Tables.Add(objTable);
//DataSet objDataSet=new DataSet();
//DataTable objTable=new DataTable("rptPO");
//objTable.Columns.Add("POCode");
//objTable.Columns.Add("PODate");
//objTable.Columns.Add("Provider");
//objTable.Columns.Add("dDate");
//DataRow myRow;
//foreach (PurchaseOrder po in selectedpo)
//{
// myRow=objTable.NewRow();
// myRow[0] = po.Id;
// myRow[1] = po.Date;
// myRow[2] = po.Provider.Name;
// objTable.Rows.Add(myRow);
//}
//objDataSet.Tables.Add(objTable);
//objDataSet.WriteXmlSchema("c:/esquema.xsd");
//objDataSet.WriteXml("c:/dataset.xml");
Session["dsOrdCompras"] = objDataSet;
Response.Redirect("reportesordcompras.aspx");
}
else
{
Label6.Visible = true;
}
}
protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
IList <PurchaseOrderInformation> poinfo = new List <PurchaseOrderInformation>();
int recordcount = 0;
IList <PurchaseOrderInformation> poii = ControllerManager.PurchaseOrder.GetPurchaseOrdersBetweenDates(Convert.ToInt32(Label1.Text), Convert.ToDateTime("01/01/1900"), Convert.ToDateTime("01/01/1900"), 0, Convert.ToInt32(Label3.Text), 0, 0, 0, out recordcount);
poinfo.Add(poii[0]);
if (poinfo.Count > 0)
{
DataSet objDataSet = new DataSet();
DataTable objPOT = new DataTable("rptPO");
DataTable objItems = new DataTable("rptPOI");
objPOT.Columns.Add("Codigo");
objPOT.Columns.Add("FechaPedido");
objPOT.Columns.Add("Proveedor");
objPOT.Columns.Add("CantArt");
objPOT.Columns.Add("Importe");
objPOT.Columns.Add("FechaArribo");
objPOT.Columns.Add("Origen");
objItems.Columns.Add("CodOC");
objItems.Columns.Add("Codigo");
objItems.Columns.Add("Descripcion");
objItems.Columns.Add("Cantidad");
objItems.Columns.Add("PrecioUnitario");
objItems.Columns.Add("Total");
objItems.Columns.Add("Stock");
objItems.Columns.Add("CantidadSugerida");
foreach (PurchaseOrderInformation information in poinfo)
{
IList <PurchaseOrderItem> poi = ControllerManager.PurchaseOrderItem.GetPurchaseOrderItemList(ControllerManager.PurchaseOrder.GetById(information.Id));
information.Amount = 0;
information.Totalcount = 0;
foreach (PurchaseOrderItem item in poi)
{
Grundfos.ScalaConnector.Product prodscala = Grundfos.ScalaConnector.ControllerManager.Product.GetProductInfo(item.Product.ProductCode);
information.Amount = information.Amount + (item.Quantity * prodscala.PurchasePrice);
information.Totalcount = information.Totalcount + Convert.ToInt32(item.Quantity);
DataRow drItems;
drItems = objItems.NewRow();
drItems["CodOC"] = information.Id;
drItems["Codigo"] = item.Product.ProductCode;
drItems["Descripcion"] = item.Product.Description;
drItems["Cantidad"] = item.Quantity;
drItems["PrecioUnitario"] = prodscala.PurchasePrice;
drItems["Total"] = prodscala.PurchasePrice * item.Quantity;
drItems["Stock"] = prodscala.StockQ;
drItems["CantidadSugerida"] = item.QuantitySuggested;
objItems.Rows.Add(drItems);
}
DataRow myRow;
myRow = objPOT.NewRow();
myRow[0] = information.Id;
myRow[1] = information.Orderdate.ToShortDateString();
myRow[2] = information.Provider;
myRow[3] = information.Totalcount;
myRow[4] = information.Amount;
myRow[5] = information.Arrivaldate.ToShortDateString();
myRow[6] = information.Type;
objPOT.Rows.Add(myRow);
}
objDataSet.Tables.Add(objPOT);
objDataSet.Tables.Add(objItems);
objDataSet.Relations.Add("PO_POI", objDataSet.Tables["rptPO"].Columns["Codigo"], objDataSet.Tables["rptPOI"].Columns["CodOC"]);
//objDataSet.WriteXmlSchema("c:/esquema.xsd");
//objDataSet.WriteXml("c:/dataset.xml");
Session["dsOrdCompras"] = objDataSet;
Response.Redirect("/purchase-order/report.aspx");
}
}
