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