public void addChuyenDi(ChuyenDi chuyenDi)
{
using (SqlConnection connection = new SqlConnection("Server=localhost; Database=QLChuyenDi; Trusted_Connection=True;"))
{
String query = "INSERT INTO dbo.CHUYENDI (MACHUYENDI,TENCHUYENDI,TRANGTHAI,DIADIEM,MOTA,ANHBIA)" +
" VALUES (@MaChuyenDi,@TenChuyenDi,@TrangThai,@DiaDiem,@MoTa, @AnhBia)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@MaChuyenDi", chuyenDi.MaChuyenDi);
command.Parameters.AddWithValue("@TenChuyenDi", chuyenDi.TenChuyenDi);
command.Parameters.AddWithValue("@TrangThai", chuyenDi.TrangThai);
command.Parameters.AddWithValue("@DiaDiem", chuyenDi.DiaDiem);
command.Parameters.AddWithValue("@MoTa", chuyenDi.MoTa);
command.Parameters.AddWithValue("@AnhBia", chuyenDi.AnhBia);
connection.Open();
int result = command.ExecuteNonQuery();
if (result < 0)
{
MessageBox.Show("fail");
}
}
}
}
public ChuyenDi getChuyenDiById(string Id)
{
ChuyenDi result = new ChuyenDi();
foreach (var cd in chuyenDiList)
{
if (cd.MaChuyenDi == Id)
{
result = new ChuyenDi(cd.MaChuyenDi, cd.TenChuyenDi, cd.TrangThai, cd.DiaDiem, cd.MoTa, cd.AnhBia);
break;
}
}
return(result);
}
public ChuyenDiDAOImpl()
{
chuyenDiList = new List <ChuyenDi>();
currentTripList = new List <ChuyenDi>();
passedTripList = new List <ChuyenDi>();
string strConn = $"Server=localhost; Database=QLChuyenDi; Trusted_Connection=True;";
SqlConnection sqlConnection = new SqlConnection(strConn);
SqlCommand sqlCommand = new SqlCommand();
String query = "select * from CHUYENDI";
try
{
sqlCommand.CommandText = query;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
ChuyenDi chuyenDi = new ChuyenDi();
var currentFolder = AppDomain.CurrentDomain.BaseDirectory;
chuyenDi.MaChuyenDi = reader[0].ToString();
chuyenDi.TenChuyenDi = reader[1].ToString();
//chuyenDi.TrangThai = Int32.Parse(reader[2].ToString());
chuyenDi.DiaDiem = reader[3].ToString();
chuyenDi.MoTa = reader[4].ToString();
chuyenDi.AnhBia = $"{currentFolder}Assets\\Images\\{reader[5].ToString()}";
int rs;
bool success = Int32.TryParse(reader[2].ToString(), out rs);
if (success)
{
chuyenDi.TrangThai = rs;
}
else
{
chuyenDi.TrangThai = 0;
}
chuyenDiList.Add(chuyenDi);
if (success && rs == 1)
{
passedTripList.Add(chuyenDi);
}
else if (success && rs == 0)
{
currentTripList.Add(chuyenDi);
}
}
sqlConnection.Close();
}
catch (Exception ex)
{
sqlConnection.Close();
throw ex;
}
}
public void deleteChuyenDi(ChuyenDi chuyenDi)
{
String delQuery = $"DELETE FROM CHUYENDI WHERE MACHUYENDI = '{chuyenDi.MaChuyenDi}';";
DatabaseHelper.executeQuery(delQuery);
}