C# (CSharp) ProjectLab.Areas.Admin.Models.member.Member示例

示例#1

文件： Model.cs 项目： jkasaudhan/ProjectLab

        //public  bool ValidateUser(string username, string password)
        // {
        //     bool userExit = false;
        //     SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
        //     try
        //     {
        //         sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
        //         sqlConn.Query = "select 1 from tbl_member as tbm where tbm.username=@username and tbm.password=@password";
        //         sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
        //         sqlConn.Command.Parameters.AddWithValue("@username", username);
        //         sqlConn.Command.Parameters.AddWithValue("@password", password);
        //         sqlConn.Connection.Open();

        //         using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
        //         {
        //             while (sqlConn.Reader.Read())
        //             {
        //                 userExit = true;

        //             }
        //         }



        //     }
        //     catch (Exception ex)
        //     {

        //         throw ex;
        //     }
        //     finally
        //     {
        //         if (sqlConn.Reader != null)
        //             sqlConn.Reader.Close();
        //         sqlConn.Connection.Close();
        //         sqlConn.Connection.Dispose();

        //     }
        //     return userExit;
        // }

        public string GetEncryptedPassword(string username)
        {
            ProjectLab.Areas.Admin.Models.member.Member mem = new ProjectLab.Areas.Admin.Models.member.Member();
            string encPassword = "";

            // var encPassword = "";
            SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
            try
            {
                sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
                sqlConn.Query      = "select MemberID,Password from tbl_member as tbm where tbm.username=@username";
                sqlConn.Command    = new SqlCommand(sqlConn.Query, sqlConn.Connection);
                sqlConn.Command.Parameters.AddWithValue("@username", username);

                sqlConn.Connection.Open();

                using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
                {
                    if (sqlConn.Reader.Read())
                    {
                        encPassword = sqlConn.Reader["Password"].ToString();
                        // mem.MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString());
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (sqlConn.Reader != null)
                {
                    sqlConn.Reader.Close();
                }
                sqlConn.Connection.Close();
                sqlConn.Connection.Dispose();
            }
            return(encPassword);
        }

示例#2

文件： Model.cs 项目： jkasaudhan/ProjectLab

        //public  bool ValidateUser(string username, string password)
        // {
        //     bool userExit = false;
        //     SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
        //     try
        //     {
        //         sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
        //         sqlConn.Query = "select 1 from tbl_member as tbm where tbm.username=@username and tbm.password=@password";
        //         sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
        //         sqlConn.Command.Parameters.AddWithValue("@username", username);
        //         sqlConn.Command.Parameters.AddWithValue("@password", password);
        //         sqlConn.Connection.Open();
        //         using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
        //         {
        //             while (sqlConn.Reader.Read())
        //             {
        //                 userExit = true;
        //             }
        //         }
        //     }
        //     catch (Exception ex)
        //     {
        //         throw ex;
        //     }
        //     finally
        //     {
        //         if (sqlConn.Reader != null)
        //             sqlConn.Reader.Close();
        //         sqlConn.Connection.Close();
        //         sqlConn.Connection.Dispose();
        //     }
        //     return userExit;
        // }
        public string GetEncryptedPassword(string username)
        {
            ProjectLab.Areas.Admin.Models.member.Member mem = new ProjectLab.Areas.Admin.Models.member.Member();
            string encPassword = "";
            // var encPassword = "";
            SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
            try
            {
                sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
                sqlConn.Query = "select MemberID,Password from tbl_member as tbm where tbm.username=@username";
                sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
                sqlConn.Command.Parameters.AddWithValue("@username", username);

                sqlConn.Connection.Open();

                using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
                {
                    if (sqlConn.Reader.Read())
                    {
                        encPassword = sqlConn.Reader["Password"].ToString();
                        // mem.MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString());
                    }
                }

            }
            catch (Exception ex)
            {

                throw ex;
            }
            finally
            {
                if (sqlConn.Reader != null)
                    sqlConn.Reader.Close();
                sqlConn.Connection.Close();
                sqlConn.Connection.Dispose();

            }
            return encPassword;
        }

示例#3

文件： LogonController.cs 项目： jkasaudhan/ProjectLab

 //
 // GET: /Admin/Logon/
 public ActionResult Index()
 {
     ProjectLab.Areas.Admin.Models.member.Member membr = new ProjectLab.Areas.Admin.Models.member.Member();
     return View("AdminLogon");
 }

示例#4

        /// <summary>
        /// //details

        public ActionResult Details(int id)
        {
            ProjectLab.Areas.Admin.Models.member.Member pro = new ProjectLab.Areas.Admin.Models.member.Member();
            pro = model.Details(id);
            return(View("Details", pro));
        }

示例#5

 public ActionResult Edit(int id)
 {
     ProjectLab.Areas.Admin.Models.member.Member proj = model.GetData(id);
     // proj = model.GetData(id);
     return(View("Edit", proj));
 }

示例#6

        //
        // GET: /Admin/Project/Delete/5

        public ActionResult Delete(int id)
        {
            ProjectLab.Areas.Admin.Models.member.Member proj = new ProjectLab.Areas.Admin.Models.member.Member();

            return(View("Delete"));
        }

示例#7

文件： memberController.cs 项目： jkasaudhan/ProjectLab

        //
        // GET: /Admin/Project/Delete/5
        public ActionResult Delete(int id)
        {
            ProjectLab.Areas.Admin.Models.member.Member proj = new ProjectLab.Areas.Admin.Models.member.Member();

            return View("Delete");
        }

示例#8

文件： memberController.cs 项目： jkasaudhan/ProjectLab

 /// <summary>
 /// //details
 public ActionResult Details(int id)
 {
     ProjectLab.Areas.Admin.Models.member.Member pro = new ProjectLab.Areas.Admin.Models.member.Member();
     pro = model.Details(id);
     return View("Details",pro);
 }

示例#9

        //
        // GET: /Admin/Logon/

        public ActionResult Index()
        {
            ProjectLab.Areas.Admin.Models.member.Member membr = new ProjectLab.Areas.Admin.Models.member.Member();
            return(View("AdminLogon"));
        }