private void btnLuupanelVe_Click(object sender, EventArgs e)
{
int n = listViewVe.Items.Count;
if (n == 0)
{
lbThemDSV.Visible = true;
lbThemDSV.ForeColor = Color.Red;
lbThemDSV.Text = "Vui lòng thêm ít nhất một hạng vé";
return;
}
DanhSachVe[] dsv = new DanhSachVe[n];
for (int i = 0; i < n; i++)
{
dsv[i] = new DanhSachVe
{
HangVe = listViewVe.Items[i].SubItems[0].Text,
TiLe = float.Parse(listViewVe.Items[i].SubItems[1].Text)
};
}
if (bllDSV.InsertHangVe(dsv, n))
{
lbThemDSV.Visible = true;
lbThemDSV.ForeColor = Color.Green;
lbThemDSV.Text = "Thêm thông tin hạng vé thành công";
SetEmptyTextBoxDSV();
listViewVe.Items.Clear();
GetDataDanhSachVe();
}
}
public DanhSachVe GetInfo1HangVe(string HV)
{
string sql = "select * from DANHSACHVE where HangVe = N'" + HV + "'";
using (SqlConnection con = dc.getConnect())
{
DataTable dt = new DataTable();
try
{
da = new SqlDataAdapter(sql, con);
con.Open();
da.Fill(dt);
da.Dispose();
con.Close();
}
catch
{
return(null);
}
DanhSachVe dsv = new DanhSachVe
{
HangVe = HV,
TiLe = float.Parse(dt.Rows[0][1].ToString())
};
return(dsv);
}
}
private DanhSachVe SetInfoDSVFromGridView()
{
DanhSachVe dsv = new DanhSachVe
{
HangVe = dgvDanhSachVe.Rows[IndexSB].Cells["dgvcolHangVe"].Value.ToString(),
TiLe = float.Parse(dgvDanhSachVe.Rows[IndexSB].Cells["dgvcolTiLe"].Value.ToString())
};
return(dsv);
}
public void ShowData1HangVe()
{
DanhSachVe dsv = bllDSV.GetInfo1HangVe(HangVe);
dgvDanhSachVe.Rows[IndexDSV].Cells["dgvcolTiLe"].Value = dsv.TiLe.ToString();
}
