示例#1
0
 public void AddEditDel_OrgJoin(DO_Registrationdetails objRegistration, OrganizationJoin flag)
 {
     conn = co.GetConnection();
     //conn.Open();
     cmd             = new SqlCommand("Scrl_OrgAddEditOrgJoin", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value               = flag;
     cmd.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value    = objRegistration.ConnectRegistrationId;
     cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value           = objRegistration.AddedBy;
     cmd.Parameters.Add("@intModifiedBy", SqlDbType.Int).Value        = objRegistration.ModifiedBy;
     cmd.Parameters.Add("@intOrgJoinId", SqlDbType.Int).Value         = objRegistration.intOrgJoinId;
     cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = objRegistration.IpAddress;
     cmd.Parameters.Add("@OrgId", SqlDbType.VarChar, 50).Value        = objRegistration.OrgId;
     objRegistration.FollowId = Convert.ToInt32(cmd.ExecuteScalar());
     co.CloseConnection(conn);
 }
示例#2
0
        public DataTable GetOrgnizationName(DO_Registrationdetails objRegistration, OrganizationJoin flag)
        {
            DataTable dt = new DataTable();

            conn = co.GetConnection();

            SqlDataAdapter da = new SqlDataAdapter();

            da.SelectCommand             = new SqlCommand("Scrl_OrgAddEditOrgJoin", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value            = flag;
            da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = objRegistration.ConnectRegistrationId;
            da.SelectCommand.Parameters.Add("@intOrgJoinId", SqlDbType.Int).Value      = objRegistration.intOrgJoinId;
            da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value        = objRegistration.AddedBy;
            da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value  = objRegistration.intInvitedUserId;
            da.SelectCommand.Parameters.Add("@intUserTypeID", SqlDbType.Int).Value     = objRegistration.UserTypeId;

            da.Fill(dt);
            co.CloseConnection(conn);
            return(dt);
        }