private void btThem_Click(object sender, EventArgs e)
{
ChiTietPhieuSuaChua ct = new ChiTietPhieuSuaChua();
SuaChuaDTO sc = new SuaChuaDTO();
scBus = new SuaChuaBUS();
sc.Soluong = int.Parse(txtsoluong.Text);
sc.Tendichvu = cbDV.Text;
sc.Tiencong = Decimal.Parse(cbGTC.Text);
sc.Tenphutung = cbPhuTung.Text;
sc.Dongia = Decimal.Parse(lbPhuTung.Text);
txtThanhtien.Text = Convert.ToString(Decimal.Parse(cbGTC.Text) + Decimal.Parse(lbPhuTung.Text) * int.Parse(txtsoluong.Text));
sc.Thanhtien = Decimal.Parse(txtThanhtien.Text);
sc.Bienso = cbBS.Text;
sc.Ngaysuachua = ngaysuachua.Text;
bool kq = scBus.them(sc);
if (kq == false)
{
MessageBox.Show("Thêm thông tin thất bại. Vui lòng kiểm tra lại dữ liệu");
}
else
{
MessageBox.Show("Thêm thông tin thành công");
}
ct.loadData_Vao_GridView();
}
public bool xoa(SuaChuaDTO sc)
{
string query = string.Empty;
query += "DELETE FROM PhieuSuaChua WHERE [bienso] = @bienso";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@bienso", sc.Bienso);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(true);
}
public List <SuaChuaDTO> Find(string K)
{
string query = string.Empty;
query += "SELECT [tendichvu], [bienso], [tiencong], [ngaysuachua], [tenphutung], [dongia], [soluong], [thanhtien]";
query += "FROM [PhieuSuaChua]";
query += " WHERE ([bienso] LIKE CONCAT('%',@K,'%'))";
List <SuaChuaDTO> IsFind = new List <SuaChuaDTO>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@K", K);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
SuaChuaDTO sc = new SuaChuaDTO();
sc.Tendichvu = reader["tendichvu"].ToString();
sc.Bienso = reader["bienso"].ToString();
sc.Tiencong = Decimal.Parse(reader["tiencong"].ToString());
sc.Ngaysuachua = reader["ngaysuachua"].ToString();
sc.Tenphutung = reader["tenphutung"].ToString();
sc.Dongia = Decimal.Parse(reader["dongia"].ToString());
sc.Soluong = int.Parse(reader["soluong"].ToString());
sc.Thanhtien = Decimal.Parse(reader["thanhtien"].ToString());
IsFind.Add(sc);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(IsFind);
}
public void cbBS_SelectedIndexChanged(object sender, EventArgs e)
{
ChiTietPhieuSuaChua ct = new ChiTietPhieuSuaChua();
string K = cbBS.Text.Trim();
SuaChuaDTO sc = new SuaChuaDTO();
scBus = new SuaChuaBUS();
if (K == null || K == string.Empty || K.Length == 0)
{
ct.loadData_Vao_GridView();
}
else
{
List <SuaChuaDTO> ListFind = scBus.Find(K);
ct.loadData_Vao_GridView(ListFind);
}
}
private void btchitiet_Click(object sender, EventArgs e)
{
ChiTietPhieuSuaChua ct = new ChiTietPhieuSuaChua();
string K = cbBS.Text.Trim();
SuaChuaDTO sc = new SuaChuaDTO();
scBus = new SuaChuaBUS();
if (K == null || K == string.Empty || K.Length == 0)
{
ct.loadData_Vao_GridView();
}
else
{
List <SuaChuaDTO> ListFind = scBus.Find(K);
ct.loadData_Vao_GridView(ListFind);
}
ct.Show();
}
private void btXoa_Click(object sender, EventArgs e)
{
ChiTietPhieuSuaChua ct = new ChiTietPhieuSuaChua();
DialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa ?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DialogResult == DialogResult.Yes)
{
SuaChuaDTO sc = new SuaChuaDTO();
sc.Bienso = cbBS.Text;
bool kq2 = scBus.xoa(sc);
if (kq2 == false)
{
MessageBox.Show("Xóa thông tin thất bại. Vui lòng kiểm tra lại dữ liệu");
}
else
{
MessageBox.Show("Xóa thông tin thành công");
}
ct.loadData_Vao_GridView();
}
}
public bool them(SuaChuaDTO sc)
{
string query = string.Empty;
query += "INSERT INTO [PhieuSuaChua] (tendichvu, bienso, tiencong, ngaysuachua, tenphutung, dongia, soluong,thanhtien)";
query += "VALUES (@tendichvu,@bienso,@tiencong,@ngaysuachua,@tenphutung,@dongia,@soluong,@thanhtien)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@tendichvu", sc.Tendichvu);
cmd.Parameters.AddWithValue("@bienso", sc.Bienso);
cmd.Parameters.AddWithValue("@tiencong", sc.Tiencong);
cmd.Parameters.AddWithValue("@ngaysuachua", sc.Ngaysuachua);
cmd.Parameters.AddWithValue("@tenphutung", sc.Tenphutung);
cmd.Parameters.AddWithValue("@dongia", sc.Dongia);
cmd.Parameters.AddWithValue("@soluong", sc.Soluong);
cmd.Parameters.AddWithValue("@thanhtien", sc.Thanhtien);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
Console.WriteLine(ex);
throw;
}
}
}
return(true);
}
public bool xoa(SuaChuaDTO sc)
{
bool re = scDAO.xoa(sc);
return(re);
}
public bool them(SuaChuaDTO sc)
{
bool re = scDAO.them(sc);
return(re);
}
