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);
}
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);
}