public Peminjaman returnLend(string username, string lendId) { Peminjaman temp = new Peminjaman(); query = $"SELECT * FROM Lendings WHERE Username = '******' AND LendId ='{lendId}'"; SqlDataReader sdr; SqlCommand command = new SqlCommand(query, sqlConn); sqlConn.Open(); sdr = command.ExecuteReader(); //Get value sdr.Read(); temp.lendId = sdr.GetString(0).Trim(); temp.username = sdr.GetString(1).Trim(); temp.bookId = sdr.GetString(2).Trim(); temp.strLendDate = sdr.GetString(3).Trim(); temp.strDueDate = sdr.GetString(4).Trim(); temp.converToDateTime(); temp.fineCount(); //return class sqlConn.Close(); return(temp); }