void XulyTimKiemTCL()
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
dto_c = new DTO_Chuyen();
int Tuyen = -1;
dto_c.ID_Chuyen = -1;
if (cbbTuyenXe.SelectedIndex != 0)
{
if (Int32.TryParse(cbbTuyenXe.Text.ToString(), out int x))
{
Tuyen = x;
}
}
if (cbbChuyenXe.SelectedIndex != 0)
{
if (Int32.TryParse(cbbChuyenXe.Text.ToString(), out int x))
{
dto_c.ID_Chuyen = x;
}
}
string Loai = cbbLoaiXe.Text.ToString();
if (cbbChuyenXe.Text.ToString() == "All" && cbbLoaiXe.Text.ToString() == "All" && cbbTuyenXe.Text.ToString() == "All")
{
LoaddgvChuyen();
}
dt = c.ListChuyenDK(Tuyen, dto_c.ID_Chuyen, Loai);
dgvChuyenXe.DataSource = dt;
}
public void InsertChuyen(DTO_Chuyen c)
{
DAL dal = new DAL();
dal.Connect();
dal.ExecuteNonQuery(CommandType.StoredProcedure, "insertChuyen",
new SqlParameter {
ParameterName = "ID_Chuyen", Value = c.ID_Chuyen
},
new SqlParameter {
ParameterName = "Tuyen", Value = c.Tuyen_ID_Tuyen
},
new SqlParameter {
ParameterName = "GKH", Value = c.Gio_khoi_hanh
},
new SqlParameter {
ParameterName = "Ghichu", Value = c.Ghi_chu
},
new SqlParameter {
ParameterName = "Xe", Value = c.Xe_XeID
},
new SqlParameter {
ParameterName = "TaiXe", Value = c.Tai_xe_ID_TaiXe
});
dal.DisConnected();
}
public bool UpdateChuyen(DTO_Chuyen c)
{
try {
SqlConnection conn = DBConnect.Connect();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "updateChuyen";
cmd.Parameters.Add(new SqlParameter {
ParameterName = "ID_Chuyen", Value = c.ID_Chuyen
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "Tuyen", Value = c.Tuyen_ID_Tuyen
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "GKH", Value = c.Gio_khoi_hanh
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "Ghichu", Value = c.Ghi_chu
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "Xe", Value = c.Xe_XeID
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "TaiXe", Value = c.Tai_xe_ID_TaiXe
});
int row = cmd.ExecuteNonQuery();
DBConnect.Close(conn);
if (row > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void InsertChuyen(DTO_Chuyen c)
{
dal_chuyen.InsertChuyen(c);
}
public void UpdateChuyen(DTO_Chuyen c)
{
dal_chuyen.UpdateChuyen(c);
}
public frmIUChuyen(DTO_Chuyen dto, int i)
{
InitializeComponent();
dto_c = dto;
xet = i;
}