userlogin.cs

学术会议在线投稿系统 fghgfhgfhgfhfgh

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

    public class UserLogin : DataAccess
    {
        public int insert_user(Int32 RoleId, String Password, String FirstName, String LastName, String Gender, String Mobile,
        String Email, String Prefix, String Region, String Telephone, String Fax, String Address)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_InsertPersonInformations";
            comm.Connection = conn;
            comm.Parameters.Add("@RoleId", SqlDbType.Int).Value = RoleId;
            comm.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Password;
            comm.Parameters.Add("@FirstName", SqlDbType.NChar).Value = FirstName;
            comm.Parameters.Add("@LastName", SqlDbType.NChar).Value = LastName;
            comm.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = Gender;
            comm.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = Mobile;
            comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
            comm.Parameters.Add("@Prefix", SqlDbType.NVarChar).Value = Prefix;
            comm.Parameters.Add("@Region", SqlDbType.NVarChar).Value = Region;
            comm.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = Telephone;
            comm.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = Fax;
            comm.Parameters.Add("@Address", SqlDbType.NVarChar).Value = Address;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 1;
            }

            conn.Close();
            return 0;
        }
        public DataTable select_user_profile_basicinformation(String Email, String Password)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_SelectBasicInformationByEmailandPassword";
            comm.Connection = conn;
             SqlDataAdapter sda=new SqlDataAdapter(comm);
            sda.SelectCommand.Parameters .Add("@Email", SqlDbType.NVarChar).Value = Email;
            sda.SelectCommand.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Password;
            //定义一个数据集对象，并填充数据集
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            try
            {
             sda.Fill(ds, "basicinformation");
             dt = ds.Tables["basicinformation"];

            }
            catch(SqlException e)
            { String error_string = e.ToString();
               conn.Close();
               return dt;
            }
            return dt;
            conn.Close();

        }
        public int update_user_profile_basicinformation(int UserId,String FirstName, String LastName, String Gender, String Mobile,
       String Email, String Prefix, String Region, String Telephone, String Fax, String Address,String Resume)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_UpdateBasicInformationByUserId";
            comm.Connection = conn;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value =UserId;
            comm.Parameters.Add("@FirstName", SqlDbType.NChar).Value = FirstName;
            comm.Parameters.Add("@LastName", SqlDbType.NChar).Value = LastName;
            comm.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = Gender;
            comm.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = Mobile;
            comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
            comm.Parameters.Add("@Prefix", SqlDbType.NVarChar).Value = Prefix;
            comm.Parameters.Add("@Region", SqlDbType.NVarChar).Value = Region;
            comm.Parameters.Add("@Telephone", SqlDbType.NVarChar).Value = Telephone;
            comm.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = Fax;
            comm.Parameters.Add("@Address", SqlDbType.NVarChar).Value = Address;
            comm.Parameters.Add("@Resume", SqlDbType.NVarChar).Value = Resume;
            try
            {
             comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }

        public DataTable select_user_profile_basicinformation_2(String Email)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_SelectBasicInformationByEmail";
            comm.Connection = conn;
            SqlDataAdapter sda = new SqlDataAdapter(comm);
            sda.SelectCommand.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
        
            //定义一个数据集对象，并填充数据集
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            try
            {
                sda.Fill(ds, "basicinformation");
                dt = ds.Tables["basicinformation"];

            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return dt;
            }
            return dt;
            conn.Close();

        }

        public int insert_Envoyers(Int32 RoleId, Int32 UserId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_InsertEnvoyerInformation_Profile";
            comm.Connection = conn;
            comm.Parameters.Add("@RoleId", SqlDbType.Int).Value = RoleId;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value =UserId;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }
        public int update_envoyers_articleid(Int32 ArticleId, Int32 UserId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_UpdateEnvoyer_ArticleIdbyUserId";
            comm.Connection = conn;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId;
            comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }
        public int insert_Envoyers_SubmitPapers(Int32 RoleId, Int32 UserId,Int32 ArticleId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_InsertEnvoyer_ArticleId";
            comm.Connection = conn;
            comm.Parameters.Add("@RoleId", SqlDbType.Int).Value = RoleId;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId;
            comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }
        public int update_Experts_Assign(Int32 ArticleId, Int32 UserId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_UpdateExperts_ArticleId";
            comm.Connection = conn;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId;
            comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }
        public int insert_Experts_Assign(Int32 RoleId, Int32 UserId, Int32 ArticleId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_InsertExpert_ArticleId";
            comm.Connection = conn;
            comm.Parameters.Add("@RoleId", SqlDbType.Int).Value = RoleId;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId;
            comm.Parameters.Add("@ArticleId", SqlDbType.Int).Value = ArticleId;
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
        }
        public DataTable select_user_profile_organisation(Int32 UserId)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_SelectOrganisationInformationsByUserId";
            comm.Connection = conn;
            SqlDataAdapter sda = new SqlDataAdapter(comm);
            sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value=UserId;
            //定义一个数据集对象，并填充数据集
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            try
            {
                sda.Fill(ds, "organisation");
                dt = ds.Tables["organisation"];

            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return dt;
            }
            return dt;
            conn.Close();

        }

        public int update_user_profile_organisation(Int32 UserId, String Name, String Region, String Fax,
            String Address, String Web, String Postion, String Email,String Phone)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_UpdateOrganisationInformations";
            comm.Connection = conn;
            comm.Parameters.Add("@UserId", SqlDbType.Int).Value = UserId;
            comm.Parameters.Add("@Name", SqlDbType.NVarChar).Value = Name;
            comm.Parameters.Add("@Region", SqlDbType.NVarChar).Value = Region;
            comm.Parameters.Add("@Fax", SqlDbType.NVarChar).Value = Fax;
            comm.Parameters.Add("@Address", SqlDbType.NVarChar).Value = Address;
            comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
            comm.Parameters.Add("@Postion", SqlDbType.NVarChar).Value = Postion;
            comm.Parameters.Add("@Phone", SqlDbType.NVarChar).Value =Phone;
            comm.Parameters.Add("@Web", SqlDbType.NVarChar).Value =Web;
           
            try
            {
                comm.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                String error_string = e.ToString();
                conn.Close();
                return 0;
            }

            conn.Close();
            return 1;
          
        }


        public int update_user_changepwd(String Email, String Password)
        {
            SqlCommand comm = new SqlCommand();
            conn.Open();
            comm.CommandType = CommandType.StoredProcedure;
            comm.CommandText = "User_UpdatePasswordbyEmail";
            comm.Connection = conn;
     
            comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
           
            comm.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Password;