C# (CSharp) WcfServiceKaraoke ThietBi Exemples

Exemple #1

        public string InsertThietBi(ThietBi ttThietBi)
        {
            string        Message;
            SqlConnection con = new SqlConnection(strQuery);

            con.Open();
            SqlCommand cmd = new SqlCommand("insert into ThietBi(TenTB,DonGia,SoLuong,TrangThai,MaLoaiTB) values(@tenTB,@donGia,@soLuong,@trangThai,@maLoaiTB)", con);

            cmd.Parameters.AddWithValue("@tenTB", ttThietBi.tenTB);
            cmd.Parameters.AddWithValue("@donGia", ttThietBi.donGia);
            cmd.Parameters.AddWithValue("@soluong", ttThietBi.soLuong);
            cmd.Parameters.AddWithValue("@trangThai", ttThietBi.trangThai);
            cmd.Parameters.AddWithValue("@maLoaiTB", ttThietBi.maLoaiTB);
            int result = cmd.ExecuteNonQuery();

            if (result == 1)
            {
                Message = ttThietBi.tenTB + "them thanh cong";
            }
            else
            {
                Message = ttThietBi.tenTB + "them khong thanh cong";
            }
            con.Close();
            return(Message);
        }

Exemple #2

        public bool DeleteThietBi(ThietBi ttThietBi)
        {
            SqlConnection con = new SqlConnection(strQuery);

            con.Open();
            SqlCommand cmd = new SqlCommand("delete from ThietBi where MaTB=@idTB", con);

            cmd.Parameters.AddWithValue("@idTB", ttThietBi.maTB);
            cmd.ExecuteNonQuery();
            con.Close();
            return(true);
        }

Exemple #3

        public void UpdateThietBi(ThietBi ttThietBi)
        {
            SqlConnection con = new SqlConnection(strQuery);

            con.Open();
            SqlCommand cmd = new SqlCommand("update ThietBi set TenTB=@tenTB, DonGia=@donGia, SoLuong=@soLuong, TrangThai=@trangthai, MaLoaiTB=@maLoaiTB where MaTB=@idTB", con);

            cmd.Parameters.AddWithValue("@idTB", ttThietBi.maTB);
            cmd.Parameters.AddWithValue("@tenTB", ttThietBi.tenTB);
            cmd.Parameters.AddWithValue("@donGia", ttThietBi.donGia);
            cmd.Parameters.AddWithValue("@soluong", ttThietBi.soLuong);
            cmd.Parameters.AddWithValue("@trangThai", ttThietBi.trangThai);
            cmd.Parameters.AddWithValue("@maLoaiTB", ttThietBi.maLoaiTB);
            cmd.ExecuteNonQuery();
            con.Close();
        }

Exemple #4

        public DataSet timKiemTB(ThietBi tkTB)
        {
            SqlConnection con = new SqlConnection(strQuery);

            con.Open();
            SqlCommand cmd = new SqlCommand("select * from ThietBi where TenTB=@TenTB", con);

            cmd.Parameters.AddWithValue("@TenTB", tkTB.tenTB);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet        ds  = new DataSet();

            cmd.ExecuteNonQuery();
            sda.Fill(ds);
            con.Close();
            return(ds);
        }