public void addnewProSer(string name, int idcategory, int soluong, string mota, float price)
        {
            PRO_SER proser = new PRO_SER();

            proser.NAME       = name;
            proser.IDCATEGORY = idcategory;
            proser.SOLUONG    = soluong;
            proser.MOTA       = mota;
            proser.Price      = price;

            spa.PRO_SERs.InsertOnSubmit(proser);
            spa.SubmitChanges();
        }
        public void UpdateProSer(int id, string name, int soluong, string mota, float price)
        {
            PRO_SER proser = spa.PRO_SERs.Where(t => t.ID == id).FirstOrDefault();

            if (proser != null)
            {
                proser.NAME    = name;
                proser.SOLUONG = soluong;
                proser.MOTA    = mota;
                proser.Price   = price;

                spa.SubmitChanges();
            }
        }