Exemple #1
0
        public bool insert(monhoc item)
        {
            String query = "Insert into monhoc values  ('" + item.mamonhoc + "' , N'" + item.tenmonhoc + "', " + item.tongsotiet + " ,"
                           + item.sotinchi + ", " + item.hocky + ");";

            try {
                SqlCommand cmd = new SqlCommand(query, getConnection());
                cmd.ExecuteNonQuery();
                return(true);
            } catch (Exception e) {
                return(false);
            }
        }
Exemple #2
0
        public bool update(monhoc l)
        {
            String query = "update monhoc set tenmonhoc =N'" + l.tenmonhoc + "'," +
                           "sotinchi=" + l.sotinchi + "," + "tongsotiet=" + l.tongsotiet + "," + "hocky=" + l.hocky + " where mamonhoc='" + l.mamonhoc + "'";

            try {
                SqlCommand cmd = new SqlCommand(query, getConnection());
                cmd.ExecuteNonQuery();
                return(true);
            } catch (Exception e) {
                return(false);
            }
        }
Exemple #3
0
        public bool delete(monhoc l)
        {
            String query = "delete monhoc where mamonhoc = '" + l.mamonhoc + "'";

            try {
                SqlCommand cmd = new SqlCommand(query, getConnection());
                cmd.ExecuteNonQuery();
                BangDiemController bangdiemController = new BangDiemController();
                List <bangdiem>    list = bangdiemController.getListBangdiem();
                foreach (bangdiem diem in list)
                {
                    bangdiemController.update(diem);
                }
                return(true);
            } catch (Exception e) {
                return(false);
            }
        }
Exemple #4
0
        public List <monhoc> getListMon(String msv)
        {
            List <monhoc> list  = new List <monhoc>();
            String        query = "Select monhoc.* from monhoc,bangdiem where bangdiem.mamonhoc = monhoc.mamonhoc  and bangdiem.masv = '" + msv + "'" +
                                  "";

            try {
                SqlCommand    cmd    = new SqlCommand(query, getConnection());
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    monhoc m = new monhoc();
                    m.monIDataReader(reader);
                    list.Add(m);
                }
                reader.Close();
            } catch (Exception e) {
            }
            return(list);
        }
Exemple #5
0
        public List <monhoc> searchMon(String search)
        {
            List <monhoc> list = new List <monhoc>();

            String query = "Select * from monhoc where mamonhoc='" + search + "' or tenmonhoc='"
                           + search + "'";

            try {
                SqlCommand    cmd    = new SqlCommand(query, getConnection());
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    monhoc m = new monhoc();
                    m.monIDataReader(reader);
                    list.Add(m);
                }
                reader.Close();
            } catch (Exception e) {
                Console.WriteLine(e.Message);
            }
            return(list);
        }
Exemple #6
0
        public List <monhoc> getListMon()
        {
            List <monhoc> list  = new List <monhoc>();
            String        query = "Select * from monhoc";

            try
            {
                SqlCommand    cmd    = new SqlCommand(query, getConnection());
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    monhoc m = new monhoc();
                    m.monIDataReader(reader);
                    list.Add(m);
                }
                reader.Close();
            }
            catch (Exception e)
            {
            }
            return(list);
        }