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;
}
}
}
