コード例 #1
0
 public ActionResult Edit(Car car)
 {
     try
     {
         F_Car f_cars = new F_Car();
         f_cars.Update(car);
         return RedirectToAction("Index");
     }
     catch (Exception e)
     {
         TempData["Error"] = e.Message.ToString();
         return RedirectToAction("Edit");
     }
 }
コード例 #2
0
 public ActionResult Create(Car car)
 {
     try
     {
         F_Car f_cars = new F_Car();
         f_cars.Insert(car);
         return RedirectToAction("Index");
     }
     catch (Exception e)
     {
         TempData["Error"] = e.Message.ToString();
         return RedirectToAction("Create");
     }
 }
コード例 #3
0
        /// <summary>
        /// Extrae los datos de la tabla Car en SQL
        /// </summary>
        /// <returns>Listado de carros</returns>
        public List<Car> List()
        {
            List<Car> Listado = new List<Car>();
            Dt = new DataTable("Resultado");

            try
            {
                //Conexion
                SqlCon = funciones_SQL.ObtenerConexion();
                SqlCon.Open();

                SqlCmd = new SqlCommand();
                SqlCmd.CommandTimeout = 0;//Para correr queries pesados
                SqlCmd.Connection = SqlCon;

                //Mapear BD del Servidor
                SqlCmd.CommandText = "select * from Car";
                SqlCmd.CommandType = CommandType.Text;
                SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd);
                SqlDat.Fill(Dt);
                foreach (DataRow fila in Dt.Rows)
                {
                    Car aux = new Car();
                    //El nombre de la fila debe ser igual al obtenido en el Query
                    aux.car_id = Int32.Parse(fila["car_id"].ToString()); ;
                    aux.name = fila["name"].ToString();
                    aux.company = fila["company"].ToString();
                    aux.stock = Int32.Parse(fila["stock"].ToString());
                    
                    //Nuevo elemento en la lista
                    Listado.Add(aux);
                }
                Dt = null;
            }
            catch (Exception E)
            {
                throw new Exception("F_Car/Listar: " +
                    E.Message, E);
            }
            finally
            {
                if (SqlCon != null && SqlCon.State == ConnectionState.Open)
                {
                    SqlCon.Close();
                }
            }
            return Listado;
        }
コード例 #4
0
        public Car Find(int? id)
        {
            Car car = new Car();
            Dt = new DataTable("Resultado");

            try
            {
                //Conexion
                SqlCon = funciones_SQL.ObtenerConexion();
                SqlCon.Open();

                SqlCmd = new SqlCommand();
                SqlCmd.CommandTimeout = 0;//Para correr queries pesados
                SqlCmd.Connection = SqlCon;

                //Mapear BD del Servidor
                SqlCmd.CommandText = "select * from Car where car_id=@id";
                SqlCmd.Parameters.AddWithValue("@id",id);
                SqlCmd.CommandType = CommandType.Text;

                SqlDataAdapter SqlDat = new SqlDataAdapter(SqlCmd);
                SqlDat.Fill(Dt);

                if(Dt!=null)
                {
                    DataRow fila = Dt.Rows[0];
                    //El nombre de la fila debe ser igual al obtenido en el Query
                    car.car_id = Int32.Parse(fila["car_id"].ToString()); ;
                    car.name = fila["name"].ToString();
                    car.company = fila["company"].ToString();
                    car.stock = Int32.Parse(fila["stock"].ToString());
                }
                Dt = null;
            }
            catch (Exception E)
            {
                throw new Exception("F_Car/Details: " +
                    E.Message, E);
            }
            finally
            {
                if (SqlCon != null && SqlCon.State == ConnectionState.Open)
                {
                    SqlCon.Close();
                }
            }
            return car;
        }
コード例 #5
0
        public bool Update(Car car)
        {
            bool exito = false;
            try
            {
                //Conexion
                SqlCon = funciones_SQL.ObtenerConexion();
                SqlCon.Open();

                SqlCmd = new SqlCommand();
                SqlCmd.CommandTimeout = 0;//Para correr queries pesados
                SqlCmd.Connection = SqlCon;

                //Mapear BD del Servidor
                SqlCmd.CommandText = "update Car set name=@p1, company=@p2, stock=@p3 where car_id=@p4";
                SqlCmd.Parameters.AddWithValue("@p1", car.name);
                SqlCmd.Parameters.AddWithValue("@p2", car.company);
                SqlCmd.Parameters.AddWithValue("@p3", car.stock);
                SqlCmd.Parameters.AddWithValue("@p4", car.car_id);
                SqlCmd.CommandType = CommandType.Text;

                SqlCmd.ExecuteNonQuery();

                exito = true;
            }
            catch (Exception E)
            {
                throw new Exception("F_Car/Update: " +
                    E.Message, E);
            }
            finally
            {
                if (SqlCon != null && SqlCon.State == ConnectionState.Open)
                {
                    SqlCon.Close();
                }
            }
            return exito;
        }