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); }