public void Update_TuyenKhongTram2(DTO.Tuyen tuyen)
{
Provider p = new Provider();
try
{
p.Connect();
string strSql = "sp_UpdateTuyenNotTram2";
p.ExecuteNonQuery(CommandType.StoredProcedure, strSql,
new SqlParameter {
ParameterName = "@ID", Value = tuyen.ID
},
new SqlParameter {
ParameterName = "@KhoangCach", Value = tuyen.KhoangCach
},
new SqlParameter {
ParameterName = "@ThoiGianChay", Value = tuyen.ThoiGian
},
new SqlParameter {
ParameterName = "@IdTram1", Value = tuyen.IDTram1
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
p.Disconnect();
}
}
public void Tuyen_SuaTuyen(ComboBox cbb, DTO.Tuyen tuyen)
{
DAO_Tuyen daTuyen = new DAO_Tuyen();
if (cbb.Items.Count > 0)
{
daTuyen.Update_Tuyen(tuyen);
}
else
{
daTuyen.Update_TuyenKhongTram2(tuyen);
}
}
private DTO.Tuyen Tuyen_InsertDTO()
{
DTO.Tuyen tuyen = new DTO.Tuyen();
tuyen.ID = Convert.ToInt32(txtMaTuyen.Text);
tuyen.KhoangCach = Convert.ToInt32(txtKhoangCach.Text);
tuyen.ThoiGian = Convert.ToInt32(txtThoiGianChay.Text);
tuyen.IDTram1 = Convert.ToInt32(cbbTenTram1.SelectedIndex);
if (cbbTenTram2.Items.Count > 0)
{
int ID_Tram2 = DAO.DAO_Tram.Instance.Find_IDTramByName(cbbTenTram2.SelectedValue.ToString());
tuyen.IDTram2 = Convert.ToInt32(ID_Tram2);
}
return(tuyen);
}
private void btnUpdate_Click_1(object sender, EventArgs e)
{
if (demclick == 0)
{
int cr = dgvTuyenXe.CurrentCell.RowIndex;
txtMaTuyen.Text = dgvTuyenXe.Rows[cr].Cells[0].Value.ToString();
txtKhoangCach.Text = dgvTuyenXe.Rows[cr].Cells[1].Value.ToString();
txtThoiGianChay.Text = dgvTuyenXe.Rows[cr].Cells[2].Value.ToString();
int idTram1 = DAO_Tram.Instance.Find_IDTramByName(dgvTuyenXe.Rows[cr].Cells[3].Value.ToString());
cbbTenTram1.SelectedIndex = idTram1;
btnUpdate.Text = "Lưu";
demclick = 1;
}
else
{
DTO.Tuyen tuyen = Tuyen_InsertDTO();
BUS_Tuyen.Instance.Tuyen_SuaTuyen(cbbTenTram2, tuyen);
btnUpdate.Text = "Sửa";
demclick = 0;
Tuyen_LoadFrom();
}
}
private void btnAdd_Click_1(object sender, EventArgs e)
{
DTO.Tuyen tuyen = Tuyen_InsertDTO();
BUS_Tuyen.Instance.Tuyen_ThemTuyen(tuyen);
Tuyen_LoadFrom();
}
public void Tuyen_ThemTuyen(DTO.Tuyen tuyen)
{
DAO_Tuyen daTuyen = new DAO_Tuyen();
daTuyen.Add_Tuyen(tuyen);
}
