public void Update_Tram(DTO.Tram tram)
{
Provider p = new Provider();
try
{
p.Connect();
string strSql = "sp_SuaTram";
p.ExecuteNonQuery(CommandType.StoredProcedure, strSql,
new SqlParameter {
ParameterName = "@ID", Value = tram.ID
},
new SqlParameter {
ParameterName = "@TenTram", Value = tram.TenTram
},
new SqlParameter {
ParameterName = "@DiaDanh", Value = tram.DiaDanh
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
p.Disconnect();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
DTO.Tram tram = GetTram();
BUS_Tram.Instance.Tram_ThemTram(tram);
frmMain.Tuyen_LoadFrom();
LoadFrom();
}
private DTO.Tram GetTram()
{
DTO.Tram tram = new DTO.Tram();
tram.ID = Convert.ToInt32(txtMaTram.Text);
tram.TenTram = txtTenTram.Text;
tram.DiaDanh = txtDiaDanh.Text;
return(tram);
}
private void button3_Click(object sender, EventArgs e)
{
if (demclick == 0)
{
int cr = dgvTramXe.CurrentCell.RowIndex;
txtMaTram.Text = dgvTramXe.Rows[cr].Cells[0].Value.ToString();
txtTenTram.Text = dgvTramXe.Rows[cr].Cells[1].Value.ToString();
txtDiaDanh.Text = dgvTramXe.Rows[cr].Cells[2].Value.ToString();
demclick = 1;
button3.Text = "Lưu";
}
else
{
DTO.Tram tram = GetTram();
BUS_Tram.Instance.Tram_SuaTram(tram);
button3.Text = "Sửa";
demclick = 0;
frmMain.Tuyen_LoadFrom();
LoadFrom();
}
}
