Beispiel #1
0
        public DataTable GetMyProfileDetails(DO_Profile objProfile, Myprofile flag)
        {
            DataTable dt = new DataTable();

            conn = co.GetConnection();

            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand             = new SqlCommand("SP_Scrl_GetProfileDetailsByregID", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value                     = flag;
            da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value          = objProfile.RegistrationId;
            da.SelectCommand.Parameters.Add("@ConnectRegistrationId", SqlDbType.Int).Value      = objProfile.ConnectRegistrationId;
            da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value           = objProfile.intInvitedUserId;
            da.SelectCommand.Parameters.Add("@striInvitedUserId", SqlDbType.VarChar, 100).Value = objProfile.striInvitedUserId;
            // da.SelectCommand.Parameters.Add("@striInvitedUserId", SqlDbType.VarChar,100).Value = objProfile.striInvitedUserId;
            da.Fill(dt);
            co.CloseConnection(conn);
            return(dt);
        }
Beispiel #2
0
        public DataSet GetMyOrgProfileDetails(DO_Profile objProfile, Myprofile flag)
        {
            DataSet       ds   = new DataSet();
            SqlConnection conn = new SqlConnection();
            SQLManager    co   = new SQLManager();

            conn = co.GetConnection();

            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand             = new SqlCommand("SP_Scrl_GetProfileDetailsByregID", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value                = flag;
            da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value     = objProfile.RegistrationId;
            da.SelectCommand.Parameters.Add("@ConnectRegistrationId", SqlDbType.Int).Value = objProfile.ConnectRegistrationId;
            da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value      = objProfile.intInvitedUserId;
            da.SelectCommand.Parameters.Add("@intInstituteUserId", SqlDbType.Int).Value    = objProfile.intInstituteUserId;
            da.Fill(ds);
            co.CloseConnection(conn);
            return(ds);
        }