private void btnThemMon_Click(object sender, EventArgs e)
{
//lay du lieu
string id = dataGridViewDSTiec.CurrentRow.Cells[0].Value.ToString();
string mon = dataGridViewDSMon.CurrentRow.Cells[1].Value.ToString();
float dongia = float.Parse(dataGridViewDSMon.CurrentRow.Cells[2].Value.ToString());
int soluong = 0;
if (txtSoLuong.Text == "")
{
MessageBox.Show("Bạn chưa nhập số lượng! Vui lòng thử lại.");
return;
}
else
{
soluong = int.Parse(txtSoLuong.Text);
}
CTTiec_DTO tiec = new CTTiec_DTO(id, mon, dongia, soluong);
//them vao CTTiec
CTTiec_BUS t = new CTTiec_BUS();
t.ThemCTTiec(tiec);
//hien thi CTTiec
dataGridViewDSDaDat.DataSource = t.LoadCTHDTheoIDTiec(id);
//cap nhat tong tien
float kq = 0;
int dong = dataGridViewDSDaDat.RowCount;
for (int i = 0; i < dong; i++)
{
kq += (float.Parse(dataGridViewDSDaDat.Rows[i].Cells[1].Value.ToString()) * float.Parse(dataGridViewDSDaDat.Rows[i].Cells[2].Value.ToString()));
}
labelTongTien.Text = kq.ToString();
//cap nhat tong tien TIEC
Tiec_BUS tiecbus = new Tiec_BUS();
tiecbus.CapNhatTongTien(id, float.Parse(labelTongTien.Text));
//cap nhat ds
dataGridViewDSTiec.DataSource = tiecbus.LoadTiec();
//bingding
bingding();
}
public bool ThemCTTiec(CTTiec_DTO cttiec)
{
SqlConnection cnn = ConnectToSQL.HamKetNoi();
string str = @"INSERT INTO CTTIEC(IDTiec, Mon, Dongia, Soluong) VALUES (@IDTiec, @Mon, @Dongia, @Soluong)";
SqlCommand cmd = new SqlCommand(str, cnn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@IDTiec", SqlDbType.NChar, 10);
cmd.Parameters.Add("@Mon", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@Dongia", SqlDbType.Float);
cmd.Parameters.Add("@Soluong", SqlDbType.Int);
cmd.Parameters["@IDTiec"].Value = cttiec.Id;
cmd.Parameters["@Mon"].Value = cttiec.Mon;
cmd.Parameters["@Dongia"].Value = cttiec.Dongia;
cmd.Parameters["@Soluong"].Value = cttiec.Soluong;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
return(true);
}
public bool ThemCTTiec(CTTiec_DTO cttiec)
{
CTTiec_DAO t = new CTTiec_DAO();
return(t.ThemCTTiec(cttiec));
}
