Exemple #1
0
        private void bckBtn_Click(object sender, EventArgs e)
        {
            Dpinfo d1 = new Dpinfo(user);

            d1.Show();
            this.Hide();
        }
Exemple #2
0
        private void login_Click(object sender, EventArgs e)
        {
            string ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\RIFANANJIBA\Documents\PetData.mdf;Integrated Security=True;Connect Timeout=30";
            string sql = "select Id,Password,UserName,EmailAddress,UserType" +
                         " from [dbo].[Users] where UserName='******' and Password='******'";
            SqlConnection con    = new SqlConnection(ConnectionString);
            SqlCommand    sqlcmd = new SqlCommand(sql, con);

            DataTable dt = new DataTable();

            sqlcmd.Connection.Open();
            // Users user1;
            dt.Load(sqlcmd.ExecuteReader());
            if (dt.Rows.Count > 0)
            {
                Entities.Users user = new Users()
                {
                    Id           = dt.Rows[0].Field <int>("Id"),
                    UserName     = dt.Rows[0].Field <string>("UserName"),
                    UserType     = dt.Rows[0].Field <string>("UserType"),
                    Password     = dt.Rows[0][1].ToString(),
                    EmailAddress = dt.Rows[0][3].ToString(),
                    // UserType= dt.Rows[0][2].ToString(),
                };
                if (user.UserType == "P")
                {
                    pinfo pinfo = new pinfo(user);
                    pinfo.Show();
                    this.Hide();
                }
                else if (user.UserType == "D")
                {
                    Dpinfo dpinfo = new Dpinfo(user);
                    dpinfo.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("not Correct ");
                }



                //MessageBox.Show("Correct ");
            }

            else
            {
                DataAccess            dataAccess = new DataAccess(ConnectionString);
                List <Entities.Users> users      = dataAccess.GetList <Entities.Users>();
            }

            sqlcmd.Connection.Close();
        }