public void getZona()
        {
            //Variables

            DataTable dt = new DataTable();

            List <clsZona> lstZona = new List <clsZona>();
            clsZona        c       = new clsZona();

            BindingSource bs = new BindingSource();

            //Lenamos el DS de Categorias

            Params.Clear();

            Data.DataModule.ParamByName(Params, "Datos", "");
            Data.DataModule.FillDataSet(spCatEstacionDS1, "spCatZona", Params.ToArray());

            dt            = spCatEstacionDS1.Tables["spCatZona"];
            lstZona       = c.FillList(dt);
            bs.DataSource = lstZona;

            this.lueZona.Properties.DataSource = bs.List;
            //this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID"));
            this.lueZona.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Descripcion", "Descripcion"));
            this.lueZona.Properties.DisplayMember = "Descripcion";
            this.lueZona.Properties.ValueMember   = "ZonaID";

            this.lueZona.Properties.DropDownRows = lstZona.Count;
        }
Exemple #2
0
        public Boolean Update(clsZona zon)
        {
            try
            {
                con.conectarBD();

                cmd             = new MySqlCommand("ActualizaZona", con.conector);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("codzon", zon.CodZona);
                cmd.Parameters.AddWithValue("descripcion", zon.Descripcion);
                int x = cmd.ExecuteNonQuery();
                if (x != 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
        }
Exemple #3
0
        public Boolean Insert(clsZona zon)
        {
            try
            {
                con.conectarBD();

                cmd             = new MySqlCommand("GuardaZona", con.conector);
                cmd.CommandType = CommandType.StoredProcedure;
                MySqlParameter oParam;
                oParam           = cmd.Parameters.AddWithValue("descripcion", zon.Descripcion);
                oParam           = cmd.Parameters.AddWithValue("codusu", zon.CodUser);
                oParam           = cmd.Parameters.AddWithValue("newid", 0);
                oParam.Direction = ParameterDirection.Output;
                int x = cmd.ExecuteNonQuery();

                zon.CodZonaNuevo = Convert.ToInt32(cmd.Parameters["newid"].Value);

                if (x != 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
        }
Exemple #4
0
        public clsZona CargaZona(Int32 Codigo)
        {
            clsZona zon = null;

            try
            {
                con.conectarBD();
                cmd = new MySqlCommand("MuestraZona", con.conector);
                cmd.Parameters.AddWithValue("codzon", Codigo);
                cmd.CommandType = CommandType.StoredProcedure;
                dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        zon               = new clsZona();
                        zon.CodZona       = Convert.ToInt32(dr.GetDecimal(0));
                        zon.Descripcion   = dr.GetString(1);
                        zon.Estado        = dr.GetBoolean(2);
                        zon.CodUser       = Convert.ToInt32(dr.GetDecimal(3));
                        zon.FechaRegistro = dr.GetDateTime(4);// capturo la fecha
                    }
                }
                return(zon);
            }
            catch (MySqlException ex)
            {
                throw ex;
            }
            finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
        }
Exemple #5
0
 public Boolean update(clsZona zon)
 {
     try
     {
         return(Mzon.Update(zon));
     }
     catch (Exception ex)
     {
         DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
         return(false);
     }
 }
Exemple #6
0
        public Boolean insert(clsZona zon)
        {
            try
            {
                return(Mzon.Insert(zon));
            }
            catch (Exception ex)
            {
                if (ex.Message.Contains("Duplicate entry"))
                {
                    DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: N°- de Documento Repetido", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

                else
                {
                    DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                return(false);
            }
        }