public FrmShowBidEntry(List <ArtShowItem> items)
{
InitializeComponent();
Items = items;
Current = null;
CurrentIndex = -1;
LstItems.BeginUpdate();
foreach (var showItem in items)
{
var item = new ListViewItem {
Text = showItem.ShowNumber.ToString()
};
item.SubItems.Add(showItem.Title);
item.SubItems.Add(showItem.PurchaserNumber.ToString());
item.SubItems.Add(showItem.FinalSalePrice != null ? ((decimal)showItem.FinalSalePrice).ToString("C") : "");
item.BackColor = showItem.Auctioned ? Color.LightGreen : Color.White;
item.Tag = showItem;
LstItems.Items.Add(item);
}
LstItems.ListViewItemSorter = new ListViewItemComparer(0, true);
LstItems.Sort();
LstItems.EndUpdate();
LstItems.Items[0].Selected = true;
}
protected void TxtSearch_TextChanged(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("select firstName from del_user where firstname like'" + (TxtSearch.Text).Trim() + "%'", con);
SqlDataReader rdr = cmd.ExecuteReader();
LstItems.DataSource = rdr;
LstItems.DataTextField = "FirstName";
LstItems.DataBind();
}
private void OnClose(string msg)
{
RxApp.MainThreadScheduler.Schedule(_ =>
{
if (IsOpen)
{
IsOpen = false;
}
LstItems.Clear();
LstLastOrdersButtons.Clear();
});
}
/// <summary>
/// Permet de verouiller la liste
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void chkBoxVerrouiller_CheckStateChanged(object sender, System.EventArgs e)
{
if (chkBoxVerrouiller.CheckState == CheckState.Checked)
{
LstItems.ClearSelected();
LstItems.Enabled = false;
}
else if (chkBoxVerrouiller.CheckState == CheckState.Unchecked)
{
LstItems.ClearSelected();
LstItems.Enabled = true;
}
}
public FrmSellItems(Person purchaser)
{
InitializeComponent();
Purchaser = purchaser;
StripeFirstTry = true;
TotalPrice = 0;
TotalTax = 0;
TotalDue = 0;
LblTaxes.Text = "Taxes @ " + decimal.Round(Program.TaxRate * 100, 1) + "%";
var data = Encoding.ASCII.GetBytes("action=GetPrintShopList&year=" + Program.Year.ToString());
var request = WebRequest.Create(Program.URL + "/functions/artQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
Items = JsonConvert.DeserializeObject <List <PrintShopItem> >(results);
LstItems.BeginUpdate();
foreach (var shopItem in Items)
{
var item = new ListViewItem
{
Text = shopItem.ShowNumber.ToString()
};
item.SubItems.Add(shopItem.Title);
item.SubItems.Add(shopItem.ArtistName);
item.SubItems.Add(shopItem.Price.ToString("C"));
item.SubItems.Add((shopItem.QuantitySent - shopItem.QuantitySold).ToString());
if (shopItem.QuantitySent - shopItem.QuantitySold == 0)
{
item.ForeColor = Color.Red;
item.BackColor = Color.LightGray;
}
else if (shopItem.IsCharity)
{
item.BackColor = Color.LightGreen;
}
item.Tag = shopItem;
LstItems.Items.Add(item);
}
LstItems.EndUpdate();
}
public FrmSellItems(Person recipient)
{
InitializeComponent();
StripeFirstTry = true;
OneTimeRecipients = new Dictionary <int, Person>();
Recipients = new Dictionary <int, Person>();
if (recipient.PeopleID != null)
{
Recipients.Add((int)recipient.PeopleID, recipient);
}
else if (recipient.OneTimeID != null)
{
Recipients.Add((int)recipient.OneTimeID, recipient);
}
Purchaser = recipient;
CmbRecipient.Items.Add(recipient);
CmbRecipient.Items.Add("Someone Else...");
CmbRecipient.SelectedIndex = 0;
var data = Encoding.ASCII.GetBytes("action=AvailableItems");
var request = WebRequest.Create(Program.URL + "/functions/salesQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
Items = JsonConvert.DeserializeObject <List <SaleItem> >(results);
LstItems.BeginUpdate();
foreach (var saleItem in Items)
{
var item = new ListViewItem
{
Text = saleItem.Year + " " + saleItem.Description
};
item.SubItems.Add(saleItem.Category);
item.SubItems.Add(saleItem.Price.ToString("C"));
item.SubItems.Add(saleItem.AvailableUntil.ToShortDateString());
item.Tag = saleItem;
LstItems.Items.Add(item);
}
LstItems.EndUpdate();
}
private void OnPosCheckError(Exception ex)
{
RxApp.MainThreadScheduler.Schedule(_ =>
{
IsGettingSelectedOrder = false;
PropagateOrder = null;
LstItems.Clear();
});
MessageBus.Current.SendMessage(new MessageBoxSettings
{
Message = "Existe el siguiente problema al obtener el pedido: " + ex.Message,
Title = "Error al obtener el pedido",
}, SharedMessageConstants.MSG_SHOW_ERRQST);
}
/// <summary>
/// Permet de définir le mode de sélection de la liste
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void rdBtnChanged(object sender, System.EventArgs e)
{
if (rdBtnSimple.Checked)
{
LstItems.ClearSelected();
LstItems.SelectionMode = SelectionMode.One;
}
else if (rdBtnMultiple.Checked)
{
LstItems.ClearSelected();
LstItems.SelectionMode = SelectionMode.MultiSimple;
}
else if (rdBtnEtendue.Checked)
{
LstItems.ClearSelected();
LstItems.SelectionMode = SelectionMode.MultiExtended;
}
}
void carga_productos(int d_familia, int id_categoria, int id_subcategoria)
{
string sql = "";
sql = "SELECT dbo.tbl_Items.Id_Linea_Venta, dbo.tbl_Familias_Productos.ID_Familia, dbo.tbl_Items.Id_Categoria, dbo.tbl_Items.Id_SubCategoria, Publicar_Web, ";
sql = sql + "Ultimo_Factor, Ultimo_Precio , Fecha_precio, dbo.tbl_Items.Sigla, dbo.tbl_Items.Precio, dbo.tbl_Items.ID_Item, dbo.tbl_Items.Codigo, dbo.tbl_Items.Descripcion, ";
sql = sql + "dbo.tbl_Categorias.Nombre AS Categoria, ";
sql = sql + "dbo.tbl_Subcategorias.Nombre AS SubCategoria, dbo.tbl_Proveedores.Nombre_Fantasia AS Proveedor, dbo.tbl_Items.Unidad, dbo.tbl_Items.Activo, ";
sql = sql + "dbo.tbl_Items.Cod_Barra ";
sql = sql + "FROM dbo.tbl_Items with(nolock) LEFT OUTER JOIN ";
sql = sql + "dbo.tbl_Categorias ON dbo.tbl_Items.Id_Categoria = dbo.tbl_Categorias.ID_Categoria LEFT OUTER JOIN ";
sql = sql + "dbo.tbl_Subcategorias ON dbo.tbl_Items.Id_SubCategoria = dbo.tbl_Subcategorias.ID_SubCategoria LEFT OUTER JOIN ";
sql = sql + "dbo.tbl_Proveedores ON dbo.tbl_Items.Id_proveedor = dbo.tbl_Proveedores.ID_Proveedor LEFT OUTER JOIN ";
sql = sql + "dbo.tbl_Familias_Productos ON dbo.tbl_Familias_Productos.ID_Familia = dbo.tbl_categorias.Id_Familia ";
sql = sql + "WHERE dbo.tbl_Familias_Productos.ID_Familia = " + id_familia;
sql = sql + "AND dbo.tbl_Items.Id_Categoria = " + id_categoria;
sql = sql + "AND dbo.tbl_Items.Id_SubCategoria = " + id_subcategoria;
using (SqlConnection connection = new SqlConnection(Sserver))
{
try
{
connection.Open();
SqlDataAdapter reader = new SqlDataAdapter(sql, connection);
DataSet dr = new DataSet();
reader.Fill(dr, "tbl_Items");
LstItems.DataSource = dr;
LstItems.DataBind();
connection.Close();
connection.Dispose();
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
connection.Close();
connection.Dispose();
}
}
}
private void LstItems_ColumnClick(object sender, ColumnClickEventArgs e)
{
if (Math.Abs(ItemsSortColumn) == Math.Abs(e.Column))
{
ItemsSortAscend = !ItemsSortAscend;
LstItems.Columns[e.Column].ImageIndex = ItemsSortAscend ? 0 : 1;
}
else
{
LstItems.Columns[ItemsSortColumn].ImageIndex = -1;
LstItems.Columns[ItemsSortColumn].TextAlign = LstItems.Columns[ItemsSortColumn].TextAlign;
ItemsSortAscend = true;
ItemsSortColumn = e.Column;
LstItems.Columns[e.Column].ImageIndex = 0;
}
LstItems.BeginUpdate();
LstItems.ListViewItemSorter = new ListViewItemComparer(e.Column, ItemsSortAscend);
LstItems.Sort();
LstItems.EndUpdate();
}
private void OnLastNthOrdersReady(IStale <ResponseMessageData <LastOrderInfoModel> > obj)
{
RxApp.MainThreadScheduler.Schedule(_ => { IsOpen = false; });
if (obj.IsStale || obj.Data.IsSuccess == false || obj.Data.LstData == null || !obj.Data.LstData.Any())
{
return;
}
try
{
RxApp.MainThreadScheduler.Schedule(_ =>
{
PropagateOrder = null;
LstItems.Clear();
LstLastOrdersButtons.Clear();
foreach (var order in obj.Data.LstData)
{
LstLastOrdersButtons.Add(new StackButtonModel(order));
}
var firstOrderToStoreId = LstLastOrdersButtons[0].OrderToStoreId;
OnPosOrderIdSelected(firstOrderToStoreId);
SingleSelectButton(firstOrderToStoreId);
IsOpen = true;
});
}
catch (Exception ex)
{
SharedLogger.LogError(ex);
MessageBus.Current.SendMessage(new MessageBoxSettings
{
Message = "Existe el siguiente problema al obtener los últimos pedidos: " + ex.Message,
Title = "Error al obtener los últimos pedidos",
}, SharedMessageConstants.MSG_SHOW_ERRQST);
}
}
protected void Buscar_Click(object sender, EventArgs e)
{
string sql = "";
sql = "SELECT tbl_Items.id_item ID, tbl_Items.codigo Codigo, dbo.PadreHijo(id_item) ph, isnull(tbl_Items.sigla, '') Letra, tbl_items.descripcion, tbl_items.Unidad, ";
sql = sql + "isnull(tbl_Familias_Productos.ID_Familia,0) ID_Familia, isnull(tbl_Categorias.ID_Categoria,0) ID_Categoria, isnull(tbl_Subcategorias.ID_SubCategoria,0) ID_SubCategoria, ";
sql = sql + " isnull((select 1 from tbl_items_web where Id_Item = dbo.tbl_Items.ID_Item),0) item_web ";
/* sql = "SELECT tbl_Items.id_item, tbl_Items.codigo,dbo.PadreHijo(id_item) ph, dbo.tbl_Items.Id_Linea_Venta, dbo.tbl_Items.Id_Categoria, dbo.tbl_Items.Id_SubCategoria, Publicar_Web, Ultimo_Factor, Ultimo_Precio , Fecha_precio, dbo.tbl_Items.Sigla, dbo.tbl_Items.Precio, dbo.tbl_Items.ID_Item, dbo.tbl_Items.Codigo, dbo.tbl_Items.Descripcion, dbo.tbl_Categorias.Nombre AS Categoria, ";
* sql = sql + " dbo.tbl_Subcategorias.Nombre AS SubCategoria, dbo.tbl_Proveedores.Nombre_Fantasia AS Proveedor, dbo.tbl_Items.Unidad, dbo.tbl_Items.Activo, ";
* sql = sql + " dbo.tbl_Items.Cod_Barra";*/
sql = sql + " FROM dbo.tbl_Items LEFT OUTER JOIN";
sql = sql + " dbo.tbl_Categorias ON dbo.tbl_Items.Id_Categoria = dbo.tbl_Categorias.ID_Categoria LEFT OUTER JOIN";
sql = sql + " dbo.tbl_Familias_Productos ON tbl_Familias_Productos.ID_Familia = dbo.tbl_Categorias.Id_Familia LEFT OUTER JOIN ";
sql = sql + " dbo.tbl_Subcategorias ON dbo.tbl_Items.Id_SubCategoria = dbo.tbl_Subcategorias.ID_SubCategoria LEFT OUTER JOIN";
sql = sql + " dbo.tbl_Proveedores ON dbo.tbl_Items.Id_proveedor = dbo.tbl_Proveedores.ID_Proveedor";
sql = sql + " where tbl_Items.Activo = 1 ";
if (Txt_Codigo.Text != "")
{
sql = sql + " and tbl_items_web.codigo like '" + Txt_Codigo.Text + "%'";
}
if (Txt_CodigoProv.Text != "")
{
sql = sql + "and tbl_items_web.Codigo_prov like '" + Txt_CodigoProv.Text + "%'";
}
if (Lst_Cat.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_items.Id_Categoria = " + Lst_Cat.SelectedItem.Value.ToString();
}
if (Lst_SubCat.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_items.Id_Subcategoria = " + Lst_SubCat.SelectedItem.Value.ToString();
}
if (Lst_Letra.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_items.Sigla = '" + Lst_Letra.SelectedItem.Value.ToString() + "'";
}
if (Lst_LV.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_items.Id_Linea_Venta = '" + Lst_LV.SelectedItem.Value.ToString() + "'";
}
if (Lst_division.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_Familias_Productos.Id_Familia = '" + Lst_division.SelectedItem.Value.ToString() + "'";
}
if (Lst_Prov.SelectedItem.Value.ToString() != "0")
{
sql = sql + "and tbl_items.Id_proveedor = " + Lst_Prov.SelectedItem.Value.ToString();
}
if (Chk_sin_cat.Checked)
{
sql = sql + "and isnull(tbl_items.Id_Categoria,0) = 0 ";
}
if (Chk_publicados.Checked)
{
sql = sql + " and tbl_Items.Publicar_Web = 1";
}
if (Chk_sin_cat.Checked)
{
sql = sql + " (tbl_Items.ID_Categoria = 0 or tbl_Items.ID_Categoria IS Null)";
}
using (SqlConnection connection = new SqlConnection(Sserver))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataAdapter reader = new SqlDataAdapter(sql, connection);
DataSet dr = new DataSet();
reader.Fill(dr, "tbl_clientes");
LstItems.DataSource = dr;
LstItems.DataBind();
//SqlCommand command = new SqlCommand(sql, connection);
//SqlDataReader reader = command.ExecuteReader();
//DataSet ds = new DataSet();
//DataTable table = new DataTable("items");
//table.Columns.Add(new DataColumn("Id", typeof(int)));
//table.Columns.Add(new DataColumn("Código", typeof(string)));
//table.Columns.Add(new DataColumn("PH", typeof(string)));
//table.Columns.Add(new DataColumn("Sigla", typeof(string)));
//table.Columns.Add(new DataColumn("Descripción", typeof(string)));
//table.Columns.Add(new DataColumn("Unidad", typeof(string)));
//table.Columns.Add(new DataColumn("ID_Familia", typeof(int)));
//table.Columns.Add(new DataColumn("ID_Categoria", typeof(int)));
//table.Columns.Add(new DataColumn("ID_SubCategoria", typeof(int)));
//table.Columns.Add(new DataColumn("item_web", typeof(int)));
//int v_id = 0;
//string v_codigo = "";
//string v_ph = "";
//string v_sigla = "";
//string v_descripcion = "";
//string v_unidad = "";
//int v_id_fam = 0;
//int v_id_cat = 0;
//int v_id_subcat = 0;
//int v_web = 0;
//while (reader.Read())
//{
// v_id = reader.GetInt32(0);
// v_codigo = reader.GetString(1);
// v_ph = reader.GetString(2);
// v_sigla = reader.GetString(3);
// v_descripcion = reader.GetString(4);
// v_unidad = reader.GetString(5);
// v_id_fam = reader.GetInt32(6);
// v_id_cat = reader.GetInt32(7);
// v_id_subcat = reader.GetInt32(8);
// v_web = reader.GetInt32(9);
// table.Rows.Add(v_id,
// v_codigo,
// v_ph,
// v_sigla,
// v_descripcion,
// v_unidad,
// v_id_fam,
// v_id_cat,
// v_id_subcat,
// v_web);
//}
// LstItems.DataSource = table;
//LstItems.DataBind();
connection.Close();
connection.Dispose();
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
connection.Close();
connection.Dispose();
}
}
}
private void OnPosCheckReady(IStale <ResponseMessageData <PropagateOrderModel> > obj)
{
try
{
if (obj.IsStale || obj.Data.IsSuccess == false || obj.Data.Data == null ||
obj.Data.Data.PosCheck == null || obj.Data.Data.PosCheck.LstItems.Count == 0)
{
OnPosCheckError(new Exception("No hay datos que mostrar. Información no válida"));
return;
}
RxApp.MainThreadScheduler.Schedule(_ =>
{
IsGettingSelectedOrder = false;
LstItems.Clear();
PropagateOrder = obj.Data.Data;
try
{
if (PropagateOrder != null && PropagateOrder.PosCheck != null)
{
PropagateOrder.PosCheck.FixItemParents();
}
}
catch (Exception ex)
{
SharedLogger.LogError(ex);
MessageBus.Current.SendMessage(new MessageBoxSettings
{
Message = "Existe el siguiente problema al jerarquizar el pedido: " + ex.Message,
Title = "Error al obtener el pedido",
}, SharedMessageConstants.MSG_SHOW_ERRQST);
return;
}
var lstNewItems = PropagateOrder.PosCheck.LstItems.Select(e => new QtItemModel
{
ItemId = e.ItemId,
Name = e.Name,
Quantity = 1
}).ToList();
foreach (var item in lstNewItems)
{
LstItems.Add(item);
}
LastOrderDateTx = PropagateOrder.PosCheck.OrderDateTime.ToString(" dd/MM/yyyy | HH:mm:ss");
TitleLastOrder = String.Format("Pedido del {0}", PropagateOrder.Order.Phone);
FranchiseName = String.Format("Franquicia: {0}", PropagateOrder.Franchise.Name);
IsOpen = true;
});
}
catch (Exception ex)
{
SharedLogger.LogError(ex);
MessageBus.Current.SendMessage(new MessageBoxSettings
{
Message = "Existe el siguiente problema al obtener la información del pedido: " + ex.Message,
Title = "Error al obtener el pedido",
}, SharedMessageConstants.MSG_SHOW_ERRQST);
}
}
private void CheckBox_Unchecked(object sender, RoutedEventArgs e)
{
LstItems.UnselectAll();
}