private void dgvListaItems_SelectionChanged(object sender, EventArgs e) { try { int ItemId = Convert.ToInt32(dgvListaItems.Rows[dgvListaItems.CurrentCell.RowIndex].Cells["Id"].Value); Item ItemConsulta = ItemsBL.GetItemId(ItemId).FirstOrDefault(); txtCodigoC.Text = ItemConsulta.Codigo; txtDescripcionC.Text = ItemConsulta.Descripcion; txtNombreC.Text = ItemConsulta.Nombre; txtEspesorC.Text = ItemConsulta.Espesor.ToString(); txtAnchoC.Text = ItemConsulta.Ancho.ToString(); txtLargoC.Text = ItemConsulta.Largo.ToString(); txtDiametroC.Text = ItemConsulta.Diametro.ToString(); txtVolumenC.Text = ItemConsulta.Volumen.ToString(); txtPesoC.Text = ItemConsulta.Peso.ToString(); //txtPesoC.Text = ItemConsulta.cos.ToString(); pictureBox10.BackgroundImage = null; if (ItemConsulta.Imagen != null) { pictureBox10.BackgroundImage = ImageExtensions.byteArrayToImage(ItemConsulta.Imagen); } } catch { } }
/// <summary> /// METODOS ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /// </summary> private void CargarGridListadoItem() { //Listado de Items dtItems = ItemsBL.GetItemsBusqueda(null); dgvListaItems.DataSource = dtItems; //dgvListaItems.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //dgvListaItems.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dgvListaItems.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; List <int> visibleColumns = new List <int> { 0, 1, 2, 3, 4, 5, 6, 7, 10 }; foreach (DataGridViewColumn col in dgvListaItems.Columns) { if (!visibleColumns.Contains(col.Index)) { col.Visible = false; } } dgvListaItems.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvListaItems.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvListaItems.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvListaItems.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvListaItems.Columns[5].DefaultCellStyle.Format = "#,0.00###"; dgvListaItems.Columns[6].DefaultCellStyle.Format = "#,0.00###"; dgvListaItems.Columns[7].DefaultCellStyle.Format = "#,0.00###"; dgvListaItems.Columns[8].DefaultCellStyle.Format = "#,0.00###"; ((DataGridViewImageColumn)dgvListaItems.Columns[10]).ImageLayout = DataGridViewImageCellLayout.Zoom; }
public IHttpActionResult GetItemsForAllSubjects() { try { return(Ok(ItemsBL.GetItemsForAllSubjects())); }catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetItemById(int itemId) { try { return(Ok(ItemsBL.GetItemById(itemId))); } catch { return(NotFound()); } }
// DELETE: api/Items/5 public IHttpActionResult Delete(Items1 item) { try { ItemsBL.DeleteItem(item); return(Ok()); } catch (Exception e) { return(Conflict()); } }
private void CargarGridListado() { DataTable dt = new DataTable(); dt = ItemsBL.ListadoItemsAutorizacion(); dgvListado.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dgvListado.DataSource = dt; FormatearGridListado(); }
public IHttpActionResult Put([FromBody] Items1 item) { try { ItemsBL.UpdateItem(item); return(Ok()); } catch (Exception e) { return(NotFound()); } }
// POST: api/Items public IHttpActionResult Post([FromBody] Items1 item) { try { ItemsBL.AddItem(item); return(Ok()); } catch (Exception e) { return(Conflict()); } }
//GetAllItems public IHttpActionResult GetAllItems() { try { return(Ok(ItemsBL.GetAllItems())); } catch (Exception ex) { Console.WriteLine(ex.Message); return(Ok()); } }
public IHttpActionResult GetAllByName(string item) { try { Items1 it = ItemsBL.GetItemByName(item); return(Ok(it)); } catch (Exception e) { Console.WriteLine(e); return(NotFound()); } }
public IHttpActionResult GetAllByKind(int kindId) { try { List <Items1> items = ItemsBL.GetAllByKind(kindId); if (items.Count == 0) { throw new Exception(); } return(Ok(items)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetItemsBySubjectId(int subjectId) { try { ItemsForSubject items = ItemsBL.GetItemsBySubjectId(subjectId); if (items == null) { throw new Exception(); } return(Ok(items)); } catch (Exception ex) { Console.WriteLine(ex); return(Ok()); } }
public IHttpActionResult GetItemsBySubjectIdAndKind(int subjectId, int kindId) { try { List <Items1> items = ItemsBL.GetItemsBySubjectIdAndKind(subjectId, kindId); if (items.Count == 0) { throw new Exception(); } return(Ok(items)); } catch (Exception ex) { Console.WriteLine(ex); return(Ok()); } }
private void CargarGridsDependenciasItem(int itemId) { dtItemDetalle = ItemsBL.GetItemsDependencias(itemId); bAgregandoRow = true; if (dtItemDetalle.Rows.Count > 0) { dgvDetalleItemAmp.DataSource = dtItemDetalle; MetroFramework.Controls.MetroGrid[] ArrDgv = { dgvDetalleItemAmp }; foreach (MetroFramework.Controls.MetroGrid dgvActual in ArrDgv) { List <int> visibleColumns = new List <int> { 2, 3, 8, 9 }; foreach (DataGridViewColumn col in dgvActual.Columns) { if (!visibleColumns.Contains(col.Index)) { col.Visible = false; } col.ReadOnly = true; } dgvActual.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvActual.Columns[9].DefaultCellStyle.Format = "#,0.00###"; dgvActual.Columns[9].ReadOnly = false; dgvActual.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dgvActual.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; if (dgvDetalleItemAmp.Rows.Count > 0) { dgvDetalleItemAmp.CurrentCell = dgvDetalleItemAmp.Rows[0].Cells[2]; } } } else { this.Close(); } bAgregandoRow = false; }
public void showItems() { // while (true) // { string row = ("=================================================================="); Console.WriteLine(row); Console.WriteLine("MENU"); Console.WriteLine(row); ItemsBL itemBL = new ItemsBL(); Items it = new Items(); List <Items> li = new List <Items>(); try { li = itemBL.getItemsByItemID(1); } catch (System.Exception) { Console.WriteLine("Disconnect from datebase !"); Environment.Exit(0); } var table = new ConsoleTable("ID", "ITEM NAME"); foreach (var item in li) { table.AddRow(item.ItemID, item.ItemName); } table.Write(); showItemDetail(); // } }
private void dgvListado_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewCheckBoxCell cell = dgvListado.CurrentCell as DataGridViewCheckBoxCell; DataGridViewRow row = dgvListado.CurrentRow as DataGridViewRow; if (cell != null && !cell.ReadOnly) { cell.Value = cell.Value == null || !((bool)cell.Value); if ((bool)cell.Value) { row.DefaultCellStyle.ForeColor = Color.Green; } else { row.DefaultCellStyle.ForeColor = Color.Red; } CargarEntidadItem(); ItemsBL.UpdateItem(ItemEntidad); dgvListado.RefreshEdit(); dgvListado.NotifyCurrentCellDirty(true); } }
private void CargarEntidadItem() { ItemEntidad = ItemsBL.GetItemId(Convert.ToInt32(dgvListado.Rows[dgvListado.CurrentCell.RowIndex].Cells[7].Value)).FirstOrDefault(); ItemEntidad.Autorizado = (bool)dgvListado.Rows[dgvListado.CurrentCell.RowIndex].Cells[8].Value ? 1 : 0; }
private void CargarGridGistado() { DataTable dt = new DataTable(); List <int> NumericColumns = new List <int> { }; switch (metroComboBox1.SelectedIndex) { case 0: dt = ItemsBL.ListadoItemsResumen(); for (int i = 6; i <= dt.Columns.Count; i++) { NumericColumns.Add(i); } break; case 1: dt = ItemsBL.ListadoItemsCostoResumen(); for (int i = 6; i <= dt.Columns.Count - 2; i++) { NumericColumns.Add(i); } break; case 2: dt = ItemsBL.ListadoItemsCostoDetallado(); for (int i = 6; i <= dt.Columns.Count - 2; i++) { NumericColumns.Add(i); } break; case 3: dt = ItemsBL.ListadoItemsTipoCostoFactorRES("T"); NumericColumns.Add(3); NumericColumns.Add(4); break; case 4: dt = ItemsBL.ListadoItemsTipoCostoFactor("T"); NumericColumns.Add(4); NumericColumns.Add(5); break; } dgvListado.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dgvListado.DataSource = dt; DTListado = dt.Copy(); if (metroComboBox1.SelectedIndex == 2) { dgvListado.Columns[5].Visible = false; } foreach (DataGridViewColumn col in dgvListado.Columns) { if (NumericColumns.Contains(col.Index)) { col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; col.DefaultCellStyle.Format = "N2"; } } }
public void showItemDetail() { while (true) { string row = ("=================================================================="); ItemsBL itBL = new ItemsBL(); Items it = new Items(); List <Items> li = new List <Items>(); Customers custom = new Customers(); CustomersBL cutomBL = new CustomersBL(); string choice; int itID; try { li = itBL.getItemsByItemID(1); Console.Write("Enter item id: "); itID = int.Parse(Console.ReadLine()); } catch (System.Exception) { Console.WriteLine("Item id must be integer and in the options !"); continue; } if (itID > li.Count || validateChoice(itID.ToString()) == false) { Console.Write("You are only entered in the number of existing ids !"); while (true) { Console.Write("Do you want re-enter ? (Y/N): "); choice = Console.ReadLine().ToUpper(); if (choice != "Y" && choice != "N") { Console.Write("You can only enter (Y/N): "); choice = Console.ReadLine().ToUpper(); continue; } break; } switch (choice) { case "Y": continue; case "N": showItems(); break; default: continue; } } try { it = itBL.GetItemByItemID(itID); } catch (System.Exception) { Console.WriteLine("Disconnect from database !"); } if (it == null) { Console.WriteLine("The item does not exist !"); } else { Console.WriteLine(row); Console.WriteLine("DETAIL OF ITEM"); Console.WriteLine(row); var table = new ConsoleTable("ID", "ITEM NAME", "ITEM PRICE", "SIZE"); table.AddRow(it.ItemID, it.ItemName, it.ItemPrice, it.Size); table.Write(); Console.WriteLine("DESCRIPTION : "); Console.WriteLine(it.ItemDescription); } string select; Console.WriteLine("\n" + row + "\n"); Console.WriteLine("1. Add to cart"); Console.WriteLine("2. Back to Menu"); Console.Write("Enter your selection: "); select = Console.ReadLine(); switch (select) { case "1": AddToCart(it); break; case "2": showItems(); break; default: Console.WriteLine("You are only entered in the number existing !"); continue; } string conti; Console.Write("Do you continue ? (Y/N): "); conti = checkYN(); if (conti == "Y") { showItems(); } else { break; } } }