private void getProductos()
{
try
{
spCatProductoDS prd = new spCatProductoDS();
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", "");
DataModule.FillDataSet(prd, "spCatProducto", Params.ToArray());
DataTable dt = new DataTable();
dt = prd.Tables["spCatProducto"];
IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts;
foreach (DataRow dr in query)
{
switch (dr.Field <int>("ProductoID"))
{
case 1:
lbl87oct.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString();
break;
case 2:
lbl92oct.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString();
break;
case 3:
lbldiesel.Text = "Producto: " + dr.Field <string>("Descripcion") + " Precio: $" + dr.Field <double>("Precio").ToString();
break;
}
}
lblFecha.Text = "Precio de los combustibles a la fecha: " + DateTime.Today.ToString();
}
catch (Exception ex)
{
throw;
}
}
private void FillComboEstacion()
{
List <ValuesCombo> lista = new List <ValuesCombo>();
spCatEstacionDS ds = new spCatEstacionDS();
DataModule.FillDataSet(ds, "spCatEstacion", null);
DataTable dt = new DataTable();
dt = ds.Tables["spCatEstacion"];
IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts;
foreach (DataRow dr in query)
{
lista.Add(new ValuesCombo()
{
id = dr.Field <int>("EstacionID").ToString(), nombre = dr.Field <int>("EstacionID").ToString() + "-" + dr.Field <string>("Nombre")
});
}
cmbLimitarEstacion.DataSource = lista;
cmbLimitarEstacion.ValueField = "id";
cmbLimitarEstacion.TextField = "nombre";
cmbLimitarEstacion.DataBind();
chProductos.Items.Add("PREMIUM");
chProductos.Items.Add("MAGNA");
chProductos.Items.Add("DIESEL");
chProductos.Items.Add("OTRO");
}
private void LlenarDetallePedido(int PedidoID)
{
try
{
DataSet cdsDatos = detallePedidoDS1;
BindingSource cbsDataSource = spDetallePedidoBindingSource;
string cDataSetDatos = "spDetallePedido";
cdsDatos.Clear();
//Lenamos el DS de Categorias
Params.Clear();
DataModule.ParamByName(Params, "PedidoID", PedidoID);
DataModule.FillDataSet(cdsDatos, cDataSetDatos, Params.ToArray());
gvDetallePedido.BestFitColumns(false);
//if (gvDetallePedido.DataRowCount > 0)
//{
// IEnumerable<DataRow> query = from dts in detallePedidoDS1.Tables["spDetallePedido"].AsEnumerable() select dts;
// foreach (DataRow dr in query)
// {
// CalcularTotales(dr.Field<int>("ProductoID"));
// }
// gvDetallePedido.UpdateTotalSummary();
//}
gvDetallePedido.UpdateTotalSummary();
ButtonGenerarRecibo();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void getEstacionAutoAbasto()
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.Attributes[0].ToString());
spCatEstacionDS ds = new spCatEstacionDS();
DataModule.FillDataSet(ds, "spCatEstacion", Params.ToArray());
DataTable dt = new DataTable();
dt = ds.Tables["spCatEstacion"];
IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts;
foreach (DataRow dr in query)
{
if (dr.Field <bool>("AutoAbasto"))
{
ASPxChkAutoAbasto.Checked = dr.Field <bool>("AutoAbasto");
getTransportistaVehiculo(dr.Field <int>("TransportistaID"));
mostrarCampos(true);
}
else
{
ASPxChkAutoAbasto.Checked = dr.Field <bool>("AutoAbasto");
mostrarCampos(false);
}
}
}
private DataTable fillComboDataset(DataSet ds, string dstring)
{
DataTable dt = new DataTable();
DataModule.FillDataSet(ds, dstring, null);
dt = ds.Tables[dstring];
return(dt);
}
private void getSaldo(string EstacionID)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", EstacionID);
DataModule.FillDataSet(saldo, "spCatSaldo", Params.ToArray());
bgvSaldo.DataSource = saldo;
bgvSaldo.DataBind();
}
private DataTable fillComboDataset(DataSet ds, string dstring)
{
DataTable dt = new DataTable();
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.UserID);
DataModule.FillDataSet(ds, dstring, Params.ToArray());
dt = ds.Tables[dstring];
return(dt);
}
private void getDetallePedido(string pedidoid)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Pedido", pedidoid);
spCatDetallePedidoDS ds = new spCatDetallePedidoDS();
DataModule.FillDataSet(ds, "spCatDetallePedido", Params.ToArray());
GridDetallePedido.DataSource = ds;
GridDetallePedido.DataBind();
}
private void getPedido(string UsuarioID)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", UsuarioID);
spCatPedidoDS ds = new spCatPedidoDS();
DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray());
gvPedido.DataSource = ds;
gvPedido.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "ClienteID", DataModule.Seguridad.UserID);
spVehiculoDS ds = new spVehiculoDS();
DataModule.FillDataSet(ds, "spVehiculo", Params.ToArray());
DataTable dt = new DataTable();
dt = ds.Tables["spVehiculo"];
bgvVehiculo.DataSource = dt;
bgvVehiculo.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", DataModule.Seguridad.UserID);
spCatPedidoDS ds = new spCatPedidoDS();
DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray());
DataTable dt = new DataTable();
dt = ds.Tables[0];
gvPedidos.DataSource = dt.Select("StatusID=" + 1 + " or StatusID =" + 3);
gvPedidos.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", Session["VehiculoID"]);
spCatVehiculoDS ds = new spCatVehiculoDS();
DataModule.FillDataSet(ds, "spCatVehiculo", Params.ToArray());
DataTable dt = new DataTable();
dt = ds.Tables["spCatVehiculo"];
FillDataFirstTab(dt);
FillCombos();
FillComboEstacion();
FillDataSecondTab(dt);
FillDataThirdTab(dt);
FillDataFourthTab(dt);
FillDataFifthTab(dt);
FillDataSixthTab(dt);
}
private void LlenarBusquedaPedido(string Datos)
{
try
{
//cdsDatos = spPedidoDS1;
DataSource = spPedidoBindingSource;
NombreDataSetDatos = "spPedido";
cdsDatos.Clear();
//Lenamos el DS de Categorias
Params.Clear();
DataModule.ParamByName(Params, "Datos", Datos);
DataModule.FillDataSet(cdsDatos, NombreDataSetDatos, Params.ToArray());
gvPedido.BestFitColumns(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LlenarDetallePedido(int PedidoID)
{
try
{
cdsDatos = detallePedidoDS1;
DataSource = spDetallePedidoBindingSource;
NombreDataSetDatos = "spDetallePedido";
cdsDatos.Clear();
//Lenamos el DS de Categorias
Params.Clear();
DataModule.ParamByName(Params, "PedidoID", PedidoID);
DataModule.FillDataSet(cdsDatos, NombreDataSetDatos, Params.ToArray());
gvDetallePedido.BestFitColumns(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void getSaldo(string EstacionID)
{
try
{
Params.Clear();
Data.DataModule.ParamByName(Params, "EstacionID", EstacionID);
//DataModule.FillDataSet(saldo, "spSaldoCliente", Params.ToArray());
//DataTable dt = saldo.Tables["spSaldoCliente"];
DataModule.FillDataSet(saldo, "spSaldo", Params.ToArray());
DataTable dt = saldo.Tables["spSaldo"];
IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts;
foreach (DataRow dr in query)
{
lblCreditoOtorgado.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("LimiteCredito"));
lblSaldo.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("Disponible"));
lblCreditoUtilizado.Text = "$ " + string.Format("{0:n2}", dr.Field <double>("Saldo"));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void getPedido(string UsuarioID)
{
try
{
Params.Clear();
Data.DataModule.ParamByName(Params, "Datos", UsuarioID);
DataModule.FillDataSet(ds, "spCatPedido", Params.ToArray());
DataTable dt = new DataTable();
dt = ds.Tables["spCatPedido"];
dt.Columns.Add(new DataColumn("Imagen", typeof(byte[])));
dt.Columns.Add(new DataColumn("ImagenEstatus", typeof(byte[])));
IEnumerable <DataRow> query = from dts in dt.AsEnumerable() select dts;
ImageConverter _imageConverter = new ImageConverter();
byte[] xByte;
System.Drawing.Image img;
foreach (DataRow dr in query)
{
switch (dr.Field <int>("StatusID"))
{
case 1: //Nuevo
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["Imagen"] = xByte;
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\add.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["ImagenEstatus"] = xByte;
break;
//2.Por Validar
case 3: //Procesando
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-location.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["Imagen"] = xByte;
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\red.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["ImagenEstatus"] = xByte;
break;
//4.Cargando
case 5: //Ruta de entrega
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-location.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
//dr.Field<byte[]>("Imagen").SetValue(xByte, 0);
dr["Imagen"] = xByte;
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\red.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["ImagenEstatus"] = xByte;
break;
case 6: //Entregado
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-ok.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
//dr.Field<byte[]>("Imagen").SetValue(xByte, 0);
dr["Imagen"] = xByte;
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\ok.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["ImagenEstatus"] = xByte;
break;
case 7: //Cancelado
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\deliveryGrid-cancel.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
//dr.Field<byte[]>("Imagen").SetValue(xByte, 0);
dr["Imagen"] = xByte;
img = System.Drawing.Image.FromFile(@"C:\Users\RedPacifico\Desktop\RedCoSite\RedCoSite\RedCoSite\Image\cancel.png");
xByte = (byte[])_imageConverter.ConvertTo(img, typeof(byte[]));
dr["ImagenEstatus"] = xByte;
break;
}
//dt.Rows.Add(dr.ItemArray);
}
grid.DataSource = dt;
grid.DataBind();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
