Ejemplo n.º 1
0
        public int insertUserTeacher(ModeloNegocio.UserTeacher ObjUserTeacher)
        {
            try
            {
                Cmd            = new SqlCommand();
                Cmd.Connection = Conn;
                Cmd.Parameters.Clear();
                Cmd.CommandType = CommandType.StoredProcedure;
                Cmd.CommandText = "PA_ING_ASESOR_TEACHER";
                Cmd.Parameters.Add("@user_teacher_id", SqlDbType.Int).Value = ObjUserTeacher.UserTeacheId;
                Cmd.Parameters.Add("@user_asesor_id", SqlDbType.Int).Value  = ObjUserTeacher.UserAsesorId;


                Cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;

                Cmd.ExecuteNonQuery();

                ObjUserTeacher.Id = Convert.ToInt32(Cmd.Parameters["@id"].Value);

                Conn.Close();
                return(ObjUserTeacher.Id);
            }
            catch (Exception e)
            {
                // Console.WriteLine("{0} Problem insert.", e);
                //throw new Exception("Error en Acceso a Datos: InsertarMonto.", e);
                return(0);
            }
            //throw new NotImplementedException();
        }
Ejemplo n.º 2
0
 public int insertUserTeacher(ModeloNegocio.UserTeacher ObjUserTeacher)
 {
     AccesoDatos.UserTeacher userTeacher = new AccesoDatos.UserTeacher();
     return(userTeacher.insertUserTeacher(ObjUserTeacher));
 }