private int Cap_nhat_DT(DienThoai dd)
{
try
{
DataTable ds = new DataTable();
using (SqlConnection connection = new SqlConnection(@"Server=DESKTOP-30D4PD3;Database=QuanlyDT;Integrated Security=SSPI"))
using (SqlCommand command = new SqlCommand("SELECT * FROM DIENTHOAI", connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
using (SqlCommandBuilder builder = new SqlCommandBuilder(adapter))
{
adapter.FillSchema(ds, SchemaType.Source);
adapter.Fill(ds);
DataRow[] dt = ds.Select(
"MaHang = '" + dd.MaHang + "'");
dt[0]["DonGia"] = dd.DonGia;
dt[0]["TonKho"] = dd.TonKho;
adapter.Update(ds);
}
}
catch (Exception ex)
{
MessageBox.Show("Loi khi mo ket noi:" + ex.Message);
}
return(-1);
}
private void KT_DT(DienThoai dd)
{
int GiaDT;
try
{
DataTable danhsach = new DataTable();
using (SqlConnection connection =
new SqlConnection(@"Server=DESKTOP-30D4PD3; Database=QuanlyDT; Integrated Security=SSPI"))
using (SqlCommand command = new SqlCommand("SELECT * FROM DIENTHOAI", connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
using (SqlCommandBuilder builder = new SqlCommandBuilder(adapter))
{
adapter.FillSchema(danhsach, SchemaType.Source);
adapter.Fill(danhsach);
DataRow[] dt = danhsach.Select("MaHang = '" + dd.MaHang + "'");
GiaDT = (int)dt[0]["DonGia"];
}
if (GiaDT > Int32.Parse(txtGia.Text))
{
GiamGia(dd);
}
else
if (GiaDT < Int32.Parse(txtGia.Text))
{
TangGia(dd);
}
}
catch (Exception ex)
{
MessageBox.Show("Loi khi mo ket noi: " + ex.Message);
}
}
private void TangGia(DienThoai dd)
{
MessageBoxResult result = MessageBox.Show("Khuyen mai tang gia", "Khuyen mai", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes);
if (result == MessageBoxResult.Yes)
{
Cap_nhat_DT(dd);
}
else
{
return;
}
}
private void btnCapNhat_Click(object sender, RoutedEventArgs e)
{
if (cbg == 1)
{
MessageBoxResult result = MessageBox.Show("Cap Nhat DT va SL", "Cap nhat kho", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (result == MessageBoxResult.No)
{
return;
}
else
{
if (txtGia.Text.Length == 0 || txtMaHang.Text.Length == 0 || txtSL.Text.Length == 0)
{
MessageBox.Show("Nhap day du de cap nhat");
}
else
{
int Gia = int.Parse(txtGia.Text);
int SL = int.Parse(txtSL.Text);
if (Gia < 0 || SL < 0)
{
MessageBox.Show("Lam gi co gia do, nhap lai");
}
else
{
if (Gia % 1000 != 0)
{
MessageBox.Show("Yeu cau de bai, nhap lai");
}
else
{
DienThoai dd = new DienThoai();
dd.MaHang = txtMaHang.Text;
dd.DonGia = txtGia.Text;
dd.TonKho = txtSL.Text;
KT_DT(dd);
MessageBox.Show("Cap nhat thanh cong");
}
}
}
}
}
else
{
MessageBox.Show("Click vao checkbox Cap nhat gia va tk");
}
}
private void Xoa_Dien_Thoai(DienThoai dd)
{
try
{
DataTable danhsach = new DataTable();
using (SqlConnection connection = new SqlConnection(@"Server=DESKTOP-30D4PD3;Database=QuanlyDT;Integrated Security=SSPI"))
using (SqlCommand command = new SqlCommand("SELECT * FROM DIENTHOAI", connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
using (SqlCommandBuilder builder = new SqlCommandBuilder(adapter))
{
adapter.FillSchema(danhsach, SchemaType.Source);
adapter.Fill(danhsach);
DataRow[] dt = danhsach.Select(
"MaHang = '" + dd.MaHang + "'");
if ((int)dt[0]["Tonkho"] == 0)
{
MessageBoxResult result = MessageBox.Show("Hang DT se bi xoa", "Xoa DT", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (result == MessageBoxResult.No)
{
return;
}
else
{
danhsach.Select("MaHang = '" + dd.MaHang + "'");
dt[0].Delete();
adapter.Update(dt);
MessageBox.Show("Da Het Hang");
dth.ItemsSource = danhsach.DefaultView;
}
}
else
{
MessageBox.Show("Ton kho, khong xoa");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Loi khi mo ket noi: " + ex.Message);
}
}
private void btnXoa_Click(object sender, RoutedEventArgs e)
{
if (txtMaHang.Text == "")
{
MessageBox.Show("Ban phai nhap Ma Hang");
}
else
{
MessageBoxResult result = MessageBox.Show("Bạn chac chan muon xoa?", "Xoa DT", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (result == MessageBoxResult.No)
{
return;
}
else
{
DienThoai dd = new DienThoai();
dd.MaHang = txtMaHang.Text;
dd.TonKho = txtSL.Text;
Xoa_Dien_Thoai(dd);
}
}
}