示例#1
0
        public ResponseAgregarCamion AgregarCamion(RequestAgregarCamion request)
        {
            ResponseAgregarCamion response = new ResponseAgregarCamion();

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxANTP"].ToString());

            try
            {
                SqlCommand com = new SqlCommand("USP_AGREGAR_CAMION", con);
                com.CommandType = CommandType.StoredProcedure;
                com.Parameters.Add("@Placa", SqlDbType.VarChar, 6).Value             = request.Placa;
                com.Parameters.Add("@Carreta", SqlDbType.VarChar, 6).Value           = request.Carreta;
                com.Parameters.Add("@Tara", SqlDbType.Decimal, 10).Value             = request.Tara;
                com.Parameters.Add("@NroEjes", SqlDbType.Int).Value                  = request.NroEjes;
                com.Parameters.Add("@RucTransportista", SqlDbType.VarChar, 11).Value = request.RucTransportista;
                com.Parameters.Add("@Estado", SqlDbType.Bit).Value = request.Estado;
                com.Parameters.Add("@UsuarioCreacion", SqlDbType.VarChar, 20).Value = request.UsuarioCreacion;

                con.Open();
                com.ExecuteNonQuery();

                response.Estado  = true;
                response.Mensaje = "Exitoso";
            } catch (Exception ex)
            {
                response.Estado  = false;
                response.Mensaje = ex.Message.ToString();
            }
            finally
            {
                con.Close();
            }
            return(response);
        }
        public ResponseAgregarCamion AgregarCamion(RequestAgregarCamion request)
        {
            ResponseAgregarCamion response = new ResponseAgregarCamion();
            CamionBL cabl = new CamionBL();

            response = cabl.AgregarCamion(request);

            return(response);
        }
示例#3
0
        public ResponseAgregarCamion AgregarCamion(RequestAgregarCamion request)
        {
            ResponseAgregarCamion response = new ResponseAgregarCamion();

            CamionDA cda = new CamionDA();

            response = cda.AgregarCamion(request);

            return(response);
        }