Beispiel #1
0
        public void ChangePassword(Deliveryman Deliveryman)
        {
            conn.Open();
            string     query  = "Update Deliverymans SET  Password =('" + Deliveryman.Password + "') WHERE Email=('" + Deliveryman.Email + "')";
            SqlCommand cmd    = new SqlCommand(query, conn);
            int        result = cmd.ExecuteNonQuery();

            conn.Close();
        }
Beispiel #2
0
        public void DeleteDeliverymans(Deliveryman Deliveryman)
        {
            conn.Open();
            string     query  = "DELETE FROM Deliverymans WHERE  Name =('" + Deliveryman.Name + "')";
            SqlCommand cmd    = new SqlCommand(query, conn);
            int        result = cmd.ExecuteNonQuery();

            conn.Close();
        }
Beispiel #3
0
        public void AddDeliverymans(Deliveryman Deliveryman)
        {
            conn.Open();
            string     query  = "INSERT INTO Deliverymans (Name,Password,Phone,Username,Address,Email,Gander,DOB) VALUES('" + Deliveryman.Name + "','" + Deliveryman.Password + "','" + Deliveryman.Phone + "','" + Deliveryman.Username + "','" + Deliveryman.Address + "','" + Deliveryman.Email + "','" + Deliveryman.Gander + "','" + Deliveryman.DOB + "')";
            SqlCommand cmd    = new SqlCommand(query, conn);
            int        result = cmd.ExecuteNonQuery();

            conn.Close();
        }
Beispiel #4
0
        public Deliveryman AuthenticateUser(string Username, string Password)
        {
            conn.Open();
            Deliveryman   u      = null;
            string        query  = "SELECT * FROM Deliverymans WHERE Username='******' and Password='******'";
            SqlCommand    cmd    = new SqlCommand(query, conn);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                u          = new Deliveryman();
                u.Name     = reader.GetString(reader.GetOrdinal("Name"));
                u.Username = reader.GetString(reader.GetOrdinal("Username"));
                u.Password = reader.GetString(reader.GetOrdinal("Password"));
                u.D_id     = reader.GetInt32(reader.GetOrdinal("D_id"));
            }
            conn.Close();
            return(u);
        }