public bool Update(BusDTO dto)
{
string query = "Update Bus set BSX = @bsx , brand = @brand , DateRegistration = @DateRegistration , OwnerId = @ownerId , IdTuyenDuong = @idTuyenDuong Where busId = @id";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = dto.Id
};
sqlParameters[1] = new SqlParameter("@bsx", SqlDbType.NVarChar)
{
Value = dto.BSX
};
sqlParameters[2] = new SqlParameter("@brand", SqlDbType.NVarChar)
{
Value = dto.Brand
};
sqlParameters[3] = new SqlParameter("@DateRegistration", SqlDbType.Date)
{
Value = dto.DateRegistration
};
sqlParameters[4] = new SqlParameter("@ownerId", SqlDbType.NVarChar)
{
Value = dto.OwnerID
};
sqlParameters[5] = new SqlParameter("@idTuyenDuong", SqlDbType.Int)
{
Value = int.Parse(dto.RouteID)
};
try
{
conn.ExecuteUpdateQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteById(object id)
{
string query = "delete from BusStation where id = @id ";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.Int)
{
Value = id
};
try
{
conn.ExecuteUpdateQuery(query, sqlParameters);
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public bool DeleteById(object id)
{
bool check = true;
SqlParameter[] sqlParameters = new SqlParameter[1];
string sql = "delete from Staff where MSNV = @id";
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = id
};
try
{
check = conn.ExecuteUpdateQuery(sql, sqlParameters);
}
catch (Exception)
{
return(false);
throw;
}
return(check);
}
public bool Update(OwnerDTO dto)
{
string query = "Update Owner set Name = @name , Phone = @phone, DateOfBirth = @DoB , CMND = @CMND , Address = @address Where Id = @id";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@id", SqlDbType.NVarChar)
{
Value = dto.Id
};
sqlParameters[1] = new SqlParameter("@name", SqlDbType.NVarChar)
{
Value = dto.Name
};
sqlParameters[2] = new SqlParameter("@phone", SqlDbType.NVarChar)
{
Value = dto.Phone
};
sqlParameters[3] = new SqlParameter("@DoB", SqlDbType.Date)
{
Value = dto.DateOfBirth
};
sqlParameters[4] = new SqlParameter("@CMND", SqlDbType.NVarChar)
{
Value = dto.CMND
};
sqlParameters[5] = new SqlParameter("@address", SqlDbType.NVarChar)
{
Value = dto.Address
};
try
{
conn.ExecuteUpdateQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(RouteDTO dto)
{
string query = "Update Route set TuyenDuong = @name Where Id = @id";
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@name", SqlDbType.NVarChar)
{
Value = dto.TuyenDuong
};
sqlParameters[1] = new SqlParameter("@id", SqlDbType.Int)
{
Value = dto.Id
};
try
{
conn.ExecuteUpdateQuery(query, sqlParameters);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
